14 | Stocktake Report Data Explained
This article covers the formulas implemented in the _All Stores View of the Stocktake Report. As suggested by the name, the _Entry view allows viewing all of the Quantity and Cost of Products entered into the system. _Report view displays the basic Start and End Quantity of Products and Costs of those Products and their variance percentage. The _History view allows comparing the Variance percentage and CostEx with past reports. Lastly, the _All Stores View allows for comparing CostEX difference and Quantity Variance between multiple stores.
This article covers the formulas implemented in the _All Stores View of the Stocktake Report.
As suggested by the name, the _Entry view allows viewing all of the Quantity and Cost of Products entered into the system.
_Report view displays the basic Start and End Quantity of Products and Costs of those Products and their variance percentage.
The _History view allows comparing the Variance percentage and CostEx with past reports.
Lastly, the _All Stores View allows for comparing CostEX difference and Quantity Variance between multiple stores.
Prerequisites- To access Stocktake Report Settings, the applicable Operator Privileges will need to be enabled
- Operator Maintenance 'Reporting' Tab
- Sales Reports: "Allow Stock Reports" Flag
"_Entry" View Formulas
- This is one of the default Views for the Stocktake Report and includes the following data columns by default:
Column Heading |
Data Description/Formula |
Qty Counted |
|
Qty Difference |
|
Start Qty |
|
End Cost Ex |
|
CostEx Difference |
|
Start CostEx |
|
Variance% |
|
"_Report" View Formulas
- This View consists of the following data columns by default:
Column Heading |
Data Description/Formula |
Start Qty |
|
End Qty |
|
Qty Difference |
|
Start CostEx |
|
End CostEx |
|
Cost Difference |
|
Variance % |
|
"_History" View Formulas
- This View allows for comparing and contrasting present data with past reports; it contains the following data columns by default:
Column Heading |
Data Description/Formula |
Qty Difference |
|
CostEx Difference |
|
Variance% |
|
Last Date Start |
|
Last Qty Diff |
|
Last CostEx Diff |
|
Last Variance% |
|
2nd Last Date Start |
|
2nd Last Qty Diff |
|
2nd Last CostEx Diff |
|
2nd Last Variance% |
|
3rd last Date Start |
|
3rd Last Qty Diff |
|
3rd Last CostEx Diff |
|
3rd last Variance% |
|
"_All Stores" View Formulas
- This View allows for comparing the Quantity Difference and CostEx Difference between multiple Stores or all of the available Stores
Column Heading |
Data Description |
_sp_CtDiffStore1 |
|
_sp_VariancStore1 |
|
_sp_CtDiffStore2 |
|
_sp_VariancStore2 |
|
- If there are more Stores in the Venue, the Report will show the data of all of the additional Stores as well