Consolidated Vendor Orders

The Consolidated Vendor Orders report displays a list of vendor orders for all locations in a selected hierarchy and allows users to view the details of any Vendor Order. This will enable users to see which vendor orders have not been reconciled and which orders are missing electronic invoices so they can follow up with the vendor. The report will also allow the user to view any Payment Information or Files Attached to the transactions.

Menu Paths: Net-Chef > Purchasing: Reports > Consolidated Vendor Orders
Menu Paths: Net-Chef > Reports: Purchasing > Consolidated Vendor Orders

Report Controls

Search field: Enter the Location Name, Vendor, Ref #, PO #, Vendor Invoice # for the order(s) you want to locate.

Hierarchy: Select the desired hierarchy level from the drop-down

Filter By Date: N/A, Order Date (default), Expected Delivery Date, Actual Delivery Date, Invoice Date

Date Range Start/Finish: Calendar widgets; can select any dates

Funnel (Filters): Any report column

Printer (Export): PDF, Excel, CSV formats

Report Columns:

Click any column header to sort by the data in that column. {Note}: Values in this report are expressed in the location's base currency.

Location Name – The name of the location that created the order.
Vendor – The name of the vendor for which the order was created, selected during order creation.
Ref # – Entered/edited during order creation or reconcile.
PO # – "Drill Down" link; see below for details. This is the Purchase Order transaction number, assigned based on the Numbering setup in Enterprise Manager.
Vendor Invoice # – Entered by the user during reconcile; from the vendor's invoice.
Order Date – Date the order was created.
Expected Delivery Date – Date the order should be delivered; entered during order creation.
Actual Delivery Date – Date the order was received; entered during order reconcile.
Invoice Date – Date the order was invoiced; entered during order reconcile.
Order Type – "VO" for Vendor Order or "VR" for Vendor Return.
Order Status – Options include: New Order, Submitted, Submitted/Not Transmitted, Confirmed Receipt, Awaiting Invoice, Awaiting Invoice/Confirmed Receipt, Awaiting Invoice/Reconciled, Invoice Received, Reconciled, Canceled.
Invoice Total – The total value of the order based on the Invoice Quantity, calculated as [ Sum of (Invoice Quantity x Invoice Price) for all products + Order Surcharges (Tax, Freight/Shipping, Misc 1, Misc 2) ].
Reconciled Invoice Total – The total value of the order based on the Physical Quantity, calculated as [ Sum of (Physical Quantity x Invoice Price) for all products + Order Surcharges (Tax, Freight/Shipping, Misc 1, Misc 2) ].
Payment – Will display an icon if payment data has been uploaded for reconciled orders.
File(s) – Will display an icon if one or more files has been attached to the order.

Note: Authorized users can click on these icons to display the files/payment data.

“Drill Down” Links:

PO # – Opens the vendor order in "View" mode.