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

"_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	This is the number of lines counted per product
Qty Difference	This is the difference between Start Quantity and Quantity Counted E.g., Qty Difference = Qty Counted- Start Qty
Start Qty	This is the quantity of products at the start of Stocktake
End Cost Ex	This is the Cost on Hand (excluding tax) at the end of Stocktake
CostEx Difference	This is the difference between End Cost Ex and Start Cost Ex E.g., CostEx Difference = End CostEx- Start Cost Ex
Start CostEx	This is the cost (excluding tax) at the beginning of Stocktake
Variance%	This is the quantity variance percent after the Stocktake has been performed E.g., Variance % = (Qty Difference / Start Qty) X 100%

"_Report" View Formulas

Column Heading	Data Description/Formula
Start Qty	This is the quantity of product at the start of the Stocktake
End Qty	This is the quantity of product at the end of Stocktake
Qty Difference	This is the difference between the start quantity and end quantity E.g., Qty Difference= Start Qty- End Qty
Start CostEx	This is the cost (excluding tax) at the start of the stocktake
End CostEx	This is the cost (excluding tax) at the end of the stocktake
Cost Difference	This is the difference between the Start CostEx and End CostEx E.g., Cost Difference= Start CostEx- End CostEx Here, Cost is the Purchasing Cost of Product
Variance %	This is the quantity variance percent after the stocktake has been performed E.g., Variance % = (Qty Difference / Start Qty) X 100%

"_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	This is the difference between the start quantity and end quantity of product E.g., Qty Difference= Start Qty- End Qty
CostEx Difference	This is the difference between End Cost Ex and Start Cost Ex E.g., CostEx Difference = End CostEx- Start Cost Ex
Variance%	This is the quantity variance percent after the stocktake has been performed E.g., Variance % = (Qty Difference / Start Qty) X 100%
Last Date Start	This is the last Date Stocktake started
Last Qty Diff	This is the quantity difference occurred in the previous stocktake
Last CostEx Diff	This is the CostEx difference occurred in the previous stocktake
Last Variance%	This is the Quantity Variance % in the previous stocktake
2nd Last Date Start	This is the second last Date Stocktake started
2nd Last Qty Diff	This is the quantity difference occurred in second last stocktake
2nd Last CostEx Diff	This is the CostEx difference occurred in second last stocktake
2nd Last Variance%	This is the Quantity Variance % occurred in second last stocktake
3rd last Date Start	This is the third last Date Stocktake started
3rd Last Qty Diff	This is the quantity difference occurred in third last stocktake
3rd Last CostEx Diff	This is the CostEx difference occurred in third last stocktake
3rd last Variance%	This is the Quantity Variance % occurred in third last stocktake

"_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	This is the CostEx Difference of the first store
_sp_VariancStore1	This is the Quantity Variance of the first store
_sp_CtDiffStore2	This is CostEx Difference of the second store
_sp_VariancStore2	This is Quantity Variance of the second store

If there are more Stores in the Venue, the Report will show the data of all of the additional Stores as well