PO Receipts/Deliveries Discrepancy

Description

Categories
Enginatics, R12 only
Repository
GitHub
PO Receipts/Deliveries Discrepancy highlights, at purchase order line and release level, differences between the quantities and amounts received into receiving (transaction type RECEIVE) and delivered to their final destination (DELIVER), including the impact of any CORRECT transactions applied to either side.

Quantity Received and Quantity Delivered show the original transaction quantities, Quantity Corrected Receipt and Quantity Corrected Delivery the net correction impact, and Total Quantity Received and Total Quantity Delivered the corrected totals. Quantity Variance and Cost Variance compare the corrected totals, with amounts valued at the purchase price of each receiving transaction.

Return to Vendor and Return to Receiving quantities (net of their corrections) are shown for reference but are not netted into the variance columns.

Provide a Last Receipt Date range (required): the report shows purchase order lines that had a receipt within that range, and for each it nets ALL of the line's receiving transactions to date, so the variance reflects the current outstanding received-vs-delivered position, not just activity in the window. Narrow the range (and/or add a PO, Supplier or Item filter) to keep large organizations fast.

By default the report shows discrepancy rows only (quantity or cost variance different from zero). Set parameter Discrepancies Only to No to list all purchase order receiving activity for the selected lines.

SQL 130 lines

Parameters 8

ParameterTypeList of values SQL
Operating UnitLOV
hou.name=:operating_unit
Organization CodeLOV
mp.organization_code=:organization_code
SupplierLOV
aps.vendor_name=:supplier
PO NumberLOV
pha.segment1=:po_number
ItemLOV
msiv.concatenated_segments=:item
Last Receipt Date FromDate
rt2.transaction_date>=:last_receipt_date_from
Last Receipt Date ToDate
rt2.transaction_date<:last_receipt_date_to+1
Discrepancies OnlyLOV Oracle
(x.quantity_variance<>0 or x.cost_variance<>0)