How to view PO Fill Rate Report by PO in Adempiere Retail

A PO Fill Rate by PO Report shows how much of each individual Purchase Order (PO) was successfully delivered by the supplier, compared to what was originally ordered.

User Access

Who Can Access

  • Admin
  • Back Office
  • Purchase Manager
  • Manager

What User Can Do

  • Track Supplier Fulfillment Accuracy
  • Plan Inventory More Accurately
  • Support Payment and Reconciliation

Pre-Requisite Activities

  • Accurate PO Creation
  • Receive Goods Recording
  • Unique PO Identification
  • Reporting Period
  • Establish Fill Rate Calculation

Business Rules

  • Unique PO Identification
  • Complete and Accurate PO Entry
  • Fill Rate Calculation
  • Partial Deliveries Handling
  • Timely Recording of Receipts

User Interface

STEP 1: Click Purchase Reports Folder.

TenthPlanet-ADempiere-POS-POFillRateByPO-1

STEP 2: Click PO Fill Rate By PO.

TenthPlanet-ADempiere-POS-POFillRateByPO-2

STEP 3: Choose Parameter From Date, To Date and Vendor Mandatory.

TenthPlanet-ADempiere-POS-POFillRateByPO-3

STEP 4: To show the report based on the given data.

TenthPlanet-ADempiere-POS-POFillRateByPO-4
TenthPlanet-ADempiere-POS-POFillRateByPO-5

STEP 5: Vendor Name-refers to the name of a company, individual, or organization that provides products, goods, or services to another business or consumer.

Purchase Order Number -A Purchase Order Number (PO Number) is a unique identifier assigned to a purchase order when it is created. It helps track and manage orders between buyers and suppliers.

Purchase Order Date-The Purchase Order Date is the date on which a purchase order (PO) is created or issued by the buyer. It serves as an official record of when the order was placed, and it’s important for tracking purposes, payment schedules, and delivery timelines.

Purchase Order Quantity-The purchase order quantity (PO quantity) refers to the amount of a product or material specified in a purchase order (PO) that a buyer requests from a supplier. It represents the number of units of goods or services that the buyer intends to acquire.

Purchase Order Value-The Purchase Order (PO) Value refers to the total monetary amount specified in a purchase order document. It represents the cost of the goods or services being ordered from a supplier. The PO value includes the unit prices of each item or service, the quantities being ordered, and any applicable taxes, shipping costs, discounts, or other adjustments.

GRN Document Number-The term GRN (Goods Receipt Note) Document Number typically refers to a unique identification number assigned to a goods receipt note in inventory or supply chain management. This number is used to track and reference the receipt of goods or materials from a supplier or vendor into a company’s inventory system.

GRN Date-The GRN date would refer to the date when goods are received and recorded into the inventory system.

GRN Quantity– GRN Quantity refers to the quantity of goods or items that are recorded on a Goods Receipt Note (GRN) when the goods are received from a supplier. The GRN is an important document used in inventory management and supply chain processes to confirm that the goods received match the order placed in terms of quantity, type, and condition.

GRN Value -refers to the total value of goods that have been received and logged into the system as part of a goods receipt process. It is essentially a record confirming that items have been received, and it typically includes information about the quantity, price, and type of goods delivered.

Return Document Number-A GRN (Goods Receipt Note) return document number refers to a specific identifier assigned to a return transaction related to goods that were previously received. The GRN is typically used in inventory and supply chain management to confirm the receipt of goods, and when goods are returned, a separate document number is often generated to track and manage that return.

Return Date-Purchase Order Returns: In a business-to-business (B2B) context, the vendor return date could refer to the last date a company can return unsold or defective inventory to the vendor.

Return Quantity-Retail & E-commerce: The return quantity refers to the number of items a customer returns after purchasing them. This could be due to reasons like defects, dissatisfaction with the product, wrong item received

Return Value-The GRN return value essentially represents the outcome or response after processing a GRN, whether it’s a success, error, inventory update, or other related results in the context of goods receipt and inventory management.

Quantity Wise %-Part Quantity is the specific amount you’re interested in (e.g., the number of items in a category).Total Quantity is the total amount or the sum of all quantities you’re comparing against (e.g., the total number of items).