This report will identify products on Vendor Orders and Warehouse Orders that were received within the selected date range and that have either a Qualitative Judgment linked to them and/or a quantity or price discrepancy. This report provides an audit trail of vendor performance, which can facilitate better tracking of quality and accuracy of orders, and allows users to follow up on a group of product defects for a particular vendor whose has many orders. When retrieved, the report will be grouped by 'Supplier'.
Retrieval Notes:
The locations displayed in this report are based on the selected Hierarchy. When retrieved for multiple locations, report values are expressed in the Company Base Currency. When retrieved from Corporate for a single location, the user can select either the Company or Location Base Currency (if not the same)
Transactions Included: Reconciled Vendor Orders and Warehouse Orders
Report Controls
Hierarchy: Select the desired hierarchy level from the drop-down
Period: Current Month, Current Post, Current Week, Day, Period (limited to 31 days), Post
Group By: Delivery Date, Invoice Number, Location, Product, Qualitative Judgment, Reconcile Date, Supplier (default), Transaction Number, Voyage Number (for Cruise Lines)
Funnel (Filters): Any report column or group header, Recon. User
Printer (Export): PDF, Excel, CSV formats
-><-, <-->: Click to minimize/maximize the report header
Report Columns
Click any column header to sort by the data in that column.
- Location – Displays the Location Code and Name.
- Transaction Number – Generated by the system when the order was created.
- Invoice Number – From the vendor’s invoice; entered during reconcile.
- Delivery Date – The date the order was delivered, entered during reconcile.
- Recon. Date – The date the order was reconciled.
- Recon. User – The user that reconciled order.
- Product Number – The company product number.
- Product Name – The company product name.
- Vend. Unit – The vendor unit for the product, assigned in Vendor Bids.
- Order Quantity (Non-Cruise only) – The quantity entered when the order was created.
- Confirm Quantity (Cruise only) – The quantity entered at Confirm Terms.
- Physical Quantity – The quantity actually received, entered during reconcile.
- Invoice Quantity – The quantity from the vendor’s invoice, entered during reconcile.
- Discrep. Quantity = [ Invoice Quantity – Physical Quantity ]
- Contract Price – The vendor's bid price for the product, from Vendor Bids.
- Invoice Price – The price from the vendor’s invoice, entered during reconcile.
- Contract Value = [ Physical Quantity x Contract Price ]
- Invoice Value = [ Invoice Quantity x Invoice Price ]
- Discrep. Value = [ Invoice Value – Contract Value ]
- Qualitative Judgment – The judgment applied by the user at reconcile.
Related Topics