11 | Stock Summaries Data Explained

This article explains the formulas that are used to generate different columns of Stock Summaries Report data.

The system provides three types of View options to display the report, which are: Standard View; Transfers View; and Loss View. These View options have different data columns which can be generated by using general or customized formulas.

Prerequisites

To access Stock Summary Settings, the applicable Operator Privileges will need to be enabled

Operator Maintenance 'Reporting' Tab

Sales Reports: "Allow Stock Reports" Flag

"_Standard" View Formulas

The Standard View for the Stock Summaries Report consists of the following data columns by default:

Column Heading	Data Description	Formulas
Cost Ex Received	This is the total cost of products received excluding tax	Total Sum of ( Stock Variation X Cost of each Unit( Excluding Tax)) where Stock Variation= Units Purchased
Cost Ex Stock Sold	This is the total cost of sold products excluding tax	Total Sum of (Stock Variation X Cost of each Unit (Excluding Tax)) where Stock Variation= Sold Products
Cost Ex Stock-Take	This is the cost of Stock-Take excluding Tax	Total Sum of (Stock Variation X Cost of Adjusted Stock) where Stock Variation = Stock Takes
Cost Ex Loss	This is the total cost of lost or damaged products	Total Sum of (Stock Variation X Cost of Stock (Excluding Tax)) where Stock Variation= Lost or Damaged products
Cost Ex Adjust	This is the adjusted cost of the products	Total Sum of (Stock Variation X CostEx of each line) where Stock Variation = Quantity adjusted manually
Cost Ex Correction	This is the cost value of product correction	Total Sum of (Stock Variation X CostEx of Correction)
Cost Ex XferIn	This is the cost of Product transferred In excluding Tax	Total Sum of (Stock Variation X CostEx of each line) where Stock Variation = Items Transferred In
Cost Ex XferOut	This is the cost of Product transferred Out excluding Tax	Total Sum of (Stock Variation X CostEx of each line) where Stock Variation = Items Transferred Out
Qty Received	This is the Total quantity of Stock received or purchased	Total Sum of (Opening Stock- Final Stock After Receiving Order)
Qty StockSold	This is the Total quantity of Stock Sold	Total Sum of (Opening Stock- Final Stock(excluding Lost or Damaged Stock))
Qty Stocktake	This is the value of quantity Stocktake	N/A
Qty Loss	This is the Total quantity of products Lost	Quantity Loss = Opening Stock - Final Stock ( Excluding sold products)
Qty Adjust	This is the value of total quantity adjusted	N/A
Qty Correction	This is the value of quantity corrected	N/A
Qty XferIn	This is the value of Product Quantity Transferred In	N/A
Qty XferOut	This is the value of Product Quantity Transferred Out	N/A

"_Transfers" View Formulas

The Transfers View contains the following data columns by default:

Column Heading	Data Description
Qty XferIn	This shows the value of the total quantity transferred In
CostEx XferIn	This shows the cost of products transferred In
Qty XferOut	This shows the value of total quantity transferred Out
CostEx XferOut	This shows the cost of products transferred Out

"_Loss" View Formulas

The Loss View contains the following data columns by default:

Column Heading	Data Description	Formula
Qty Loss	This shows the total quantity of products lost	Closing Stock - Units Sold
CostEx Loss	This shows the total cost of products lost	Closing CostEx - CostEx Sold
Retail Losses	This is the total value of retail loss that has occurred	Qty Loss X CostEx Loss

11 | Stock Summaries Data Explained

Column Heading

Data Description

Formulas

Column Heading

Data Description

Column Heading

Data Description

Formula