This report shows vendor orders containing quantity and/or price discrepancies that were reconciled during the selected time frame, in any market linked to the user's profile. The report compares the invoiced and received quantities and the invoiced and contract/bid prices for both contracted and non-contracted products. It shows the quantities and prices, the variances between them, and the total variance value. This allows management to identify vendors that are not meeting the terms of their contracts or bid prices, and to see each instance that the company was overcharged or shorted quantities for a delivered product. Only those products showing a discrepancy are displayed in the report.
Transactions Included: Reconciled Vendor Orders
Report Controls
Location: All (default), or select a location from the drop-down. {Franchise Note}
Period: Current Month, Current Post, Current Week, Day, Period (limited to 31 days), Post
Group by: Delivery Date, Invoice Number, Location Name, Product Number, Reference Number
Sort by: Any report column (ASC, DESC)
Funnel (Filters): Any report column; Location Code, Market
Printer (Export): PDF, Excel, CSV formats
Report Columns:
- Vendor Name and Vendor Code (default grouping) – Denotes the vendor associated with the order
- Reference/Voyage Number – Entered/populated when the order was created.
- For Cruise Lines, this is the Voyage Number.
- For all other Company Types, this is the Reference Number.
- Location Name – Displayed if "Location" = 'All'.
- Invoice Number – From the vendor’s invoice; entered during reconcile.
- (Actual) Delivery Date – The date the order was received; entered during reconcile.
- Product Number and Product Description – The number and name of the product, from the Company Product record.
- Pack Size – The company product inventory unit.
- Physical Quantity – The quantity actually received (in vendor units); entered at reconcile.
- Invoice Quantity – The quantity delivered, according to the vendor’s invoice; entered at reconcile.
- Variance Quantity = [ Invoice Quantity – Physical Quantity ]; a positive Variance Quantity indicates delivery of less than what was invoiced.
- Contract Price – The contract/bid price per vendor unit for that vendor on the Actual Delivery Date.
- Invoice Price – The price per vendor unit, according to the vendor’s invoice; entered during reconcile.
- Variance Price = [ Invoice Price – Contract Price ]; a positive Variance Price means the company was over-charged.
- Contract Total = [ Contract Price x Physical Quantity ]
- Invoice Total = [ Invoice Price x Invoice Quantity ]
- Variance Total = [ Invoice Total – Contract Total ]
Notes: Values in this report are expressed in Vendor Base Currency. For vendors with the "Non-Contract Items Use Invoice Price Override" pricing rule enabled, this report will not include Net-Chef vendor orders containing non-contracted products with a discrepancy between the Contract and Invoice price.