Inventory On Hand Report

The Inventory On Hand report allows you to generate a report showing the inventory transactions for a specified time period and a theoretical ending inventory. This can be useful for assessing inventory on-hand between physical counts. This report is similar to the Inventory Count Variance report, except it does not have the variance data. The report is sorted by inventory level, with the Restaurant Inventory Items and Prep Items listed alphabetically.

 

This report can be run for a single entity or for multiple entities by using the Entity Filter. Alternatively, you can limit by store groups (defined under Enterprise Definitions) or leave blank to include all.

Both of these options will allow you to run a report for multiple entities at once. Entity filter groups can be defined at Setup > Entities > Entity Filter.   You can compare multiple entities next to one another or this data can be consolidated to give you a rolled up report for multiple entities. (This can be useful for assessing area wide data)

 

The theoretical ending inventory quantity is calculated by taking the actual ending inventory count from the preceding period as the beginning inventory, then adding all the purchases (from AP invoices and manual checks, or from portion cut sheets; or for prep items from the prep item creation posting), and subtracting all of the usages, the sales of the items (from the recipes in the menu items, the POS sales data, the ingredients in a prep items when creating, and the whole cuts when portioning) and any inter-store transfers of inventory or wasted and/or donated inventory (inventory adjustments, which are not broken out in this report).

Note: An asterisk is displayed on the report in the Beginning Inventory column for uncounted items— that is, items for which no count was entered. The theoretical count is used in place of an actual count when no count is available.

Report Options

baby_down.jpg Click to view/hide picture.

Use the following options to customize your report:

Note: In order to consolidate data you will need to run the report for multiple units using a filter group. Investors, Area, Entity Filter

Note: In order to view costs on this report, your group must have "Show Costs on Inventory Count Variance Report" checked under Inventory > Inventory Counts of the Security > Groups > Screen Access tab.

Report Data

The Inventory On Hand report appears similar to the following:

Note: All portioning and prep productions, both incoming and outgoing values, are reported in a single column (+/- Prod/Portioning). This means the Theo Usage column now only reflects salesmix, commissary shipments, and outside order shipments.

InvonHandRpt.png

Description of report columns

Each item is identified by its Description and/or Item # at the beginning of the row.

Note that the math used to calculate the Theoretical Ending Inventory is shown in the column headers.