Theoretical On Hand

The Theoretical On Hand Report tells a User how much product is on hand as of the selected date. The report will pull the most recent count up to 90 days before the provided date and will calculate the changes in Inventory based off Sales, Purchases, Transfers, and Waste from the point the count was taken until the selected date. This will provide an accurate depiction of how much of a counted item should be at a selected Location.


Navigation

To navigate to the Theoretical on Hand Report, click 'My Reports' under 'Reports' in the left pane and then select 'Purch. & Inv.' in the top header of the reporting window. Once opened, a listing of reports will be shown. 

Find 'Theoretical on Hand' and select 'Customize' next to the report. This will open up a listing of all Report Parameters that can be used to define your report.


Report Parameters

Field

Description

1

Location

The list of location(s) available for selection of which to run the report by.

2

As Of

The date the report is ran as of.

3

Item Category

The item categories to include on the report. These reflect the item categories set up for the items in R365.

4

Count Time

This option specifies the time of the day the inventory count was performed.

5

Show Amounts

Elect whether to show or hide the dollar amounts tied to the item amounts.

6

Run Button

Runs the report. Users can also send, export, or print the report directly from this button by clicking the down arrow portion and selecting the desired action.

Click here to learn more about Report Views and their added functionality.


Report Columns

Column

Description

Item

The item name, which is hyperlinked to its item record.

Inv UofM

The Unit of Measure used for this item in inventory.

Cost

The cost of the item.

Count

The last amount counted for the item.

Purch (+)

The amount purchased. This number is drawn from AP invoices (and corresponding purchase orders).

Trans (+)

The amount transferred to / from another store. This number is drawn from item transfers both sent and received.

Waste (-)

The amount wasted. This number is drawn from approved waste logs.

Sales (-)

The estimated sales amount for the item since the last inventory count, calculated based on the item's usage per $1,000 in sales.

Calculation: (Usage Per 1000 rate of the item × sales between the item's last inventory count and the report date) ÷ 1000

Theo On Hand

The amount of the item theoretically available at the selected location

Usage Per 1000

The item’s usage rate per $1000 in sales

If Show Amounts was set to Yes in the report parameters, the dollar amounts for each item will be displayed below the listed item.


Email, Export, or Print the Report

This report can be emailed, exported, or printed in custom formatting directly from the reporting window. Click here to learn how to send, export, or print this report.