Consolidated Inventory Summary
The Consolidated
Inventory Summary displays posted inventory data per product, adding
up the information from all storage locations at each location in the selected hierarchy level. The Physical Inventory
Summary report provides the same data for a specific location. {Note}
Menu Paths: Net-Chef > Inventory: Reports > Consolidated
Inventory Summary
Menu Paths: Net-Chef > Reports: Inventory > Consolidated
Inventory Summary
Transactions Included: Inventory, Inventory Variances
Report Controls
From/To: Drop-downs; can select Post Period dates.
Group By: Storage Location (default), Product, Category, Subcategory, Microcategory, GL Code - Description; enabled when "Summarize" is unchecked.
Summarize: Product (default), Category, Subcategory, Microcategory, GL Code / Description.
Hierarchy: Select the desired hierarchy level from the drop-down
View By: Value (in Company currency), Quantity (in inventory units), Custom (user-selected columns; default)
Funnel (Filters): Any report column; Storage Location, Product Type, GL Code/Description, User Defined Category, Storage Type, Category/Subcategory/Microcategory, Lot (if applicable), On Hand <> 0, Order Activity
Printer (Export): PDF, Excel, CSV formats
Report Columns:
Click any column header to sort by the data in that column.
- Product Number – The company product number.
- Product Name – The company product name. “Drill Down” link; see below for details.
- Unit – The company product inventory unit.
- Beginning Quantity/$ – The amount on hand at the beginning of the post period.
- Received Quantity/$ – Includes all reconciled incoming orders, finalized daily prep, and incoming transfers; also includes vendor returns (which reduce total incoming vendor orders).
- Sold Quantity/$ – Includes POS Depletion, Buffet Consumption, and reconciled outgoing commissary/customer orders.
- Adjusted Quantity/$ – Includes inventory adjustments (manually entered or system-generated for Buffet Consumption waste), mid-period variances, production depletion, outgoing location transfers, and incoming/outgoing storage transfers.
- Book Quantity/$ = [ Begin + Received – Sold – Adjusted ]
- Physical Quantity/$ – Actual On Hand quantity/value for counts entered during Physical Inventory.
- In Transit Quantity/$ – Includes unreconciled outgoing commissary/customer orders & location transfers.
- Variance Quantity = [ Physical Qty + In Transit Qty – Book Qty ]
- Variance $ = [ Physical Value + In Transit Value – Book Value ]
- Cumulative Variance Quantity/$ – The sum of all variances for each included post period; this includes mid-period variances (which also appear in the "Adjusted" column.)
Additional Columns (hidden by default):
- Category – The category assigned to the company product.
- Subcategory – The subcategory assigned to the company product.
- Microcategory– The microcategory assigned to the company product.
- GL Code/Description – The GL Code/Description associated with the company product's assigned category.
- Inventory Change Quantity/$ = [ Beginning – Physical ]
- Retail Price – The "Standard" Retail Price from the Location Product record.
- Retail Book $ = [ Book Quantity x Retail Price ]
- Retail Physical $ = [ Physical Quantity x Retail Price ]
- Retail Variance $ = [ Retail Book $ – Retail Physical $ ]
“Drill Down” Links:
- Product Name – Opens a report with totals by location for the selected product.