Report Type - Unimarket Receiving Report

  • Updated

The Receiving Report provides a comprehensive log of all receiving actions taken within your community. This report is vital for verifying delivery fulfillment, assisting in the 3-way match process, and identifying outstanding items that have been ordered but not yet delivered.

 

Purpose of the Report

This report is used by Warehouse Managers, Procurement Officers, and Accounts Payable teams to:

  • Audit Delivery History: Track exactly when goods arrived and who acknowledged the receipt.
  • Resolve Matching Issues: Investigate discrepancies where an invoice quantity exceeds the received quantity.
  • Identify Backorders: Use the "Outstanding Quantity" column to see what is still owed by suppliers.
  • Asset Verification: Confirm that high-value items have been physically received before approving payment.
  • Sample report: Unimarket Receiving Report Example

 

Best Practices for Use

  • Desktop Receiving Audit: Periodically review the Received By Name, to ensure that the individuals actually taking delivery are the ones logging the receipts.
  • Follow up on Backorders: Filter the report by Outstanding Quantity > 0. To identify suppliers who are consistently failing to deliver full orders on the first shipment.
  • Investigate "Over-Receiving": Compare Total Received against the original Quantity. To identify errors where more items were logged than were authorized on the PO.
  • AP Reconciliation: If an invoice is stuck in a "Quantity Variance," use this report to verify if a corrected receipt was ever entered to clear the match.

Note: Because this report logs every action, a single order line may appear multiple times if it was received in several partial shipments.

 

Report Columns and Definitions

Receipt Identity & Action

Column Name Description
Receipt Date The date the user recorded the goods as arriving.
Created Date The system timestamp of when the receipt record was generated.
Receipt Number The unique identifier for the specific receiving transaction.
Action The type of receiving action (e.g., Receive, Return).
Note Any comments or packing slip references entered by the receiver.

Receiving Quantities & Status

Column Name Description
Received Quantity The quantity recorded in this specific receipt transaction.
Total Received The cumulative quantity received for this line across all receipts.
Total Invoiced Qty The total quantity that has been matched to invoices so far.
Outstanding Qty The remaining quantity still to be received (Ordered - Total Received).
Receiving State The current status of the line (e.g., Part Received, Fully Received).

Personnel & Order Context

Column Name Description
Received By Name/User The person who performed the receiving action in Unimarket.
Buyer Name/User The individual who placed the original Purchase Order.
Order Number The Purchase Order number associated with the receipt.
Line Number The specific line item on the PO being received.
Order Type Indicates if it is a Standard or Blanket order.

Supplier & Product Details

Column Name Description
Store Name / Vendor ID The supplier name and their internal ERP identifier.
Product Code / Name The SKU and description of the items delivered.
Currency Code The currency used for the transaction.

Financials & Accounting

Column Name Description
Unit Price / Subtotal The financial value of the items being received.
Account Code The General Ledger string where the expense is recorded.
Distribution % / Amt The split details if the expense is shared across accounts.