Consolidated Customer Order Summary

The Consolidated Customer Order Summary shows all final-reconciled product issues from all supply locations within the selected hierarchy during the selected time period. The report shows subtotals by GL for each customer, or it can be grouped as indicated below.

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

Transactions Included: Reconciled Customer Orders, Final Reconciled Warehouse or Commissary 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: Customer Name, GL Code/Description, Market Master Status, Category, Subcategory, Microcategory, Location/{option} for any of the previous options

Summarize: Product, Customer, GL Code/Description, Location

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

Printer (Export): PDF, Excel, CSV formats

Report Columns:

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

Location Name – The supply location name.
Location Code – The supply location number.
Customer Name – The name of the customer to which the product was issued.
Reconcile Units – The total quantity issued.
Reconcile Value (Selling Price) – The total value of the issued quantity, including any markups, discounts, and/or special customer pricing.
Reconcile Value (Issue Cost) – The value of the issued quantity based on the location product's Issue Cost.

Additional Columns (hidden by default):

Customer Code – The code for the customer to which the product was issued.
GL Code – The GL Code associated with the company product's assigned category.
GL Description – The GL Description associated with the company product's assigned category.
GL for CGS – The GL for CGS associated with the company product's assigned category.
Location Department – The name of the location department associated with the customer.
Location Department Code – The Code for the location department associated with the customer.
Company Department – The name of the company department associated with the customer's location department.
Company Department Code – The Code for the company department associated with the customer's location department.
P&L Grouping – The GL grouping associated with the GL Account linked to the company product's assigned category.
P&L Substructure – The GL substructure associated with the GL Account linked to the company product's assigned category.
Voyage Number (Cruise only) – The number of the voyage during which the order was created.
Market Master Status – Displays "Market Master Products" for bid sheet products/recipes or "Non-Market Master Products" for those not attached to a bid sheet.