Overview
The Stock On Hand Report is used to view the current and historical Quantity and Cost On Hand.
The report is commonly used to see the Stock Holdings at the end of a month.
Prerequisites
- For an Operator to be able to access and run a Stock On Hand Report within BackOffice, the Allow Stock Reports flag within the Reporting tab of Operator Maintenance must first be enabled
- If this flag is not enabled, an Operator cannot access Stock On Hand Reports
Viewing Current Stock On Hand
- Run BackOffice and Login
- From the Stock Reports menu, select Stock On Hand
- From the Store drop-down, select a Store or All Stores to view the Stock On Hand
- From the View drop-down, select _Standard
- Click the Display button
- The Sub Products flag will list every Product below the Group selected (e.g., highlighting Beverage will list every Product from every Subgroup below Beverage) and by selecting to Group By Parent Name, the Report will group Products according to their Group
Viewing Stock On Hand for a Previous Period
- Run BackOffice and Login
- From the Stock Reports menu, select Stock On Hand
- From the Store drop-down, select the Store to view the stock on hand
- From the View drop-down, select _Standard
- Deselect the Current checkbox
- From the Date drop-down, select the date for the previous Stock On Hand figure
- From the Start of drop-down, select the shift to view the Stock On Hand for
- The Stock On Hand reported will be for the start of trade of the selected shift
- Click on the Display button
Stock on Hand Report Formulas
- The Stock on Hand Report Standard View contains the following data columns by default:
- These fields can be calculated by two different methods which are as follows:
Method 1 - FIFO
- Here, the Cost on Hand is calculated on the basis of the FIFO (First In First Out) rule; this rule includes the cost price of each individual line of a stocked product if the same product has been purchased at different costs over the time by the business
- I.e., if the purchasing cost of one (1) Corona (out of the three stocked) is $1 and the purchasing cost of other two (2) is $2 each, Cost on Hand will be calculated as = (1 x 1) + (2 x 2) = $5
- Another way of calculating Cost on Hand is by taking the average Cost of the stocked Product
- To do this, a flag has to be active in the Venue Maintenance > Flags section as shown below
- This will take an average of purchasing cost of the product while calculating Cost on Hand
- I.e., if the purchasing cost of one (1) Corona (out of the two stocked) is $1 and the purchasing cost of another is $2, the average cost will be calculated as $1.5
- In this case, the Stock on Hand formulas will be as follows