Consolidated Customer Order Journal

The Consolidated Customer Order Journal shows product-level details of each customer order created or reconciled at all supply locations within the selected hierarchy during the selected time period. Orders of all statuses are included, and the current status is listed. The order number, reference number, order date and quantity are displayed. If the order has been invoiced, users will also see the invoice date and quantity, and if the order has been reconciled users will see the reconcile date, quantity and value.

 

Menu Paths: Net-Chef > Sales: Reports > Consolidated Customer Order Journal
Menu Paths: Net-Chef > Reports: Sales > Consolidated Customer Order Journal

 

Transactions Included: Commissary Orders, Customer Orders, Warehouse Orders

 

Report Controls

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

Post Date: Drop-down; can select post period End Dates.

From/To: Calendar widgets; can select any dates

Group By: Category, Customer, Invoice #, Subcategory, Microcategory, Location, Location/{option} for any of the previous options

Summarize: Product, Customer, Location, Location/Product, Location/Customer  {Note}Closed: Checking the "Summarize" box removes all unreconciled order data from the report and rolls up the remaining data to display only Reconciled/Final Reconciled orders.

Funnel (Filters): Any report column; User Defined Category, Category/Subcategory/Microcategory

Printer (Export): PDF, Excel, CSV formats

 

Detail view (Unsummarized)

Report Columns:

Click any column header to sort by the data in that column.

  • Location Name – The supply location name; visible when not grouped by location.
  • Invoice # – The system-generated transaction number.
  • Customer Name – The customer to which the products was issued.
  • Product # – The company product number.
  • Product Name – The company product name; “Drill Down” link; see below for details.
  • Reference # – The number entered manually when the order was created.
  • Status – The last completed step of the order process.
  • Inventory Order
  • Date – The date the order was created and saved.
  • Units – The order quantity, in inventory units.
  • Inventory Approval (Cruise only)
  • Date – The date the order was approved.
  • Units – The approval quantity, in inventory units.
  • Inventory Invoice
  • Date – The date the order was invoiced.
  • Units – The invoice quantity, in inventory units.
  • Inventory Reconcile
  • Date – The date the order was reconciled.
  • Units – The reconcile quantity, in inventory units.
  • Value = [ Reconciled Quantity x Selling Price ]
  • Ratio
  • Invoice/Order = [ Invoice Qty ÷ Order Qty]; the percentage of the ordered quantity that was invoiced.
  • Invoice/Approval (Cruise only) = [ Invoice Qty ÷ Approval Qty]; the percentage of the approved quantity that was invoiced.
  • Reconcile/Order = [ Reconcile Qty ÷ Order Qty ]; the percentage of the ordered quantity that was reconciled.
  • Reconcile/Approval (Cruise only) = [ Reconcile Qty ÷ Approval Qty ]; the percentage of the approved quantity that was reconciled.

“Drill Down” Links:

  • Product Name – Displays product details from the original order.

 

 

 

Related Topics Link IconRelated Topics