Sample Report

Filters

From date	Start of date range for analysis
To date	Ending date range for analysis
Product group or parent	Filters the results down to certain groups or products
Warehouse	Filters the results down to specific warehouses
Warehouse	Groups results by Product group or Item code

Data Returned

All data presented on this report is extracted from the list of inventory transactions in your database (these can be seen by using SA3497).

Columns

This table represents the list of Columns and the calculations that are being displayed:

Column	Meaning
Product code	The product group code of the data being returned
Product name	The full product group name related to the product code above
Item code	If grouping by item, this is the item code for the data being returned
Item description	The item description from the item record
Start qty	The quantity in stock at the start of the selected reporting period
End qty	The quantity in stock at the end of the selected reporting period
Avg qty	The average quantity in stock over the period. This is calculated as (Start Qty + End Qty) / 2
Qty sold	Total quantity of items (in their base UOM) that were removed from stock over the reporting period. Note that this includes transactions that are typically classified as "consumption" transactions: Dispatch, Work order start, Stock assignment, Receive assignments, Repairs.
Qty stockturns	This is a calculation of Qty sold / Avg qty. It represents how many times your stock qty has been turned over (sold or consumed) in the reporting period
Start value	The value of stock at the start of the reporting period
End value	The value of stock at the end of the reporting period
Avg value	The average value of stock at any point in time. This is calculated as (Start value + End value) / 2
Val sold	The total cost value of items that have been consumed in the reporting period (taken out of stock)
Val stockturns	This is a calculation of Val sold / Avg value. It represents how many times your stock value has been turned over (sold or consumed) in the reporting period

Last edit: 17/03/22