Adjustment Summary

The Adjustment Summary report shows 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 > Adjustment Summary
Menu Paths: Net-Chef > Reports: Inventory > 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.

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

Group By: Product, 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), Storage Location, Transaction Type, Daypart, Weekday, Ingredient Type (Major, Minor), Storage Type (Central, Customer), Storage Group, Category (Subcategory/Microcategory), Unit, Qualitative Judgment, Comments, Transaction #, Department, Quantity, Unit Price, Adjustment Value, Adjustment Date

Transaction Type (Can select more than one) – 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. (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 (Can select more than one) – Lists all dayparts and weekdays respectively.

Printer (Export): PDF, Excel, CSV formats

Report Columns (default view):

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

Product Number, Product Name – The company product number/name.
Storage Location – The storage that the adjusted quantity was subtracted from (positive value) or added to (negative value).
Storage Group (for Cruise, only when "Non-Default Storage Locations" are enabled) – The group that the storage location belongs to.
Adjustment Date – The date the transaction was saved.
Adjustment Type – Displays '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'.
Qualitative Judgment – Displays for Inventory & Recipe Adjustment transactions.
Quantity – The amount subtracted from (positive value) or added to (negative value) the storage location’s inventory.
Unit – The unit (inventory, recipe, or alternate count) used in the transaction.
Unit Price – The unit price of the product from the transaction details.
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.

Additional Columns (hidden by default):

Daypart – Displays the Daypart for which the transaction was performed, as elected by the user; will be left blank if none is selected. For Daily Prep (Production or Production Depletion) transactions, this may include "All Day".
Transaction Destination – For outgoing location transfers, this is the location where the transfer was sent. Not populated for any other transaction.
Lot Number – The lot number associated with the transaction; only available/populated if Lot Tracking is enabled for the location and product/recipe.