Consolidated Adjustment Summary

The Consolidated Adjustment Summary report shows for all locations in the selected hierarchy the quantity and/or value of each product adjusted out of (or into) inventory. Transactions shown include inventory and recipe adjustments, transfers, produced recipes, and depletion from daily prep, and point-of-sale, as well as variances that result during physical inventory.

Menu Paths: Net-Chef > Inventory: Reports > Consolidated Adjustment Summary
Menu Paths: Net-Chef > Reports: Inventory > Consolidated Adjustment Summary

Retrieval Note: On initial selection, users will be given the option to exclude POS, Recipe Depletion, Internal Variance Adjustment, and Internal Customer Order Transfer transactions in order to allow for faster retrieval.

Transactions Included: Inventory Adjustments, Recipe Adjustments, Transfers, Customer Orders (Issues), Production/Daily Prep, POS Depletion, Buffet Consumption, Inventory Variances

Report Controls

From/To: Calendar widgets; can select any dates

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

Post Period: Drop-down; displays past and current Post Dates

Group By: Product, Location, Transaction #, Adjustment Type, Adjustment Type - Combined, Daypart, Weekday, GL Code/Description (Product), GL Code/Description (Qualitative Judgment), Storage Location, Comments, Category, Subcategory, Microcategory. ('Adjustment Type – Combined' groups Inventory and Recipe Adjustments together.)

Funnel (Filters): Product Name, Product #, GL Code-Description (for Product or Qualitative Judgment), Daypart, Weekday, Transaction Type, Ingredient Type (Major, Minor), Location, Storage Type (Central, Customer), Storage Group, Category (Subcategory/Microcategory), Unit, Qualitative Judgment, Comments, Transaction #, Department, Quantity, Adjustment Value

Storage Location – Displays storage locations only for locations within hierarchies linked to the current application user.
Transaction Type – Options include: Buffet Consumption, Customer Order, Inventory Adjustment, Inventory /Recipe Adjustment by Component, Inventory Variance, POS, Production, Production Depletion, Recipe Adjustment by Component, Recipe Adjustment by Recipe, Transfer-Customer, Transfer-Location, Transfer-Storage. Hold the [CTRL] key and click to select more than one, or the [SHIFT] key to select a range. (If 'Recipe Adjustment by Component' and 'Recipe Adjustment by Recipe' are both selected, the report will display increased totals because components used to make a recipe are being counted along with the recipe that contains them.)
Daypart, Weekday – Lists all dayparts and weekdays respectively; hold the [CTRL] key and click to select more than one, or the [SHIFT] key to select a range.

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.
Quantity – The total amount subtracted from (positive value) or added to (negative value) inventory.
Unit – The unit (inventory, recipe, or alternate count) used in the transaction.
Adjustment Value – Total value of the product subtracted from (positive value) or added to (negative value) inventory; this may not equal "Price x Quantity" as it may include a value variance not reflected in either of those variables.

“Drill Down” Links:

Product Name – Opens a sub-report with adjustment totals for that product for locations in the selected hierarchy; the sub-report includes a [+] expander control in the Location Name column that displays additional details. The data is similar to that in the "Adjustment Summary" report for those locations.

The "Totals" section at the bottom of the report displays location subtotals. Click the Expand ( V ) or Collapse ( ^ ) control at the right of the section header to show/hide the details.

Location Name – Opens the "Adjustment Summary" report for that location.