SA4576 - Valuation (stock turns for date period)

Start of date range for analysis.

Ending date range for analysis.

Limits results to items whose Product group or Parent product group is one of the groups you select.

Limits results to stock movement for warehouses you select.

Determines how the data is combined and totalled in the results.

• Product group
  • Results are grouped based on the Product code column.
• Item code
  • The Item code and Item description columns are added, and results are grouped based on these columns.

Excludes items that are marked as Don't allow item to be used.

The Product group code of the results included in this line.

The Product group name of the results included in this line.

The Item code of the results included in this line.

This column is only displayed if Item code is selected in the Group by filter.

The Description of the results included in this line.

This column is only displayed if Item code is selected in the Group by filter.

The quantity in stock at the start of the selected reporting period.

The quantity in stock at the end of the selected reporting period.

The average quantity in stock over the period. This is calculated as (Start qty + End qty) / 2.

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.

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.

The value of stock at the start of the reporting period.

The value of stock at the end of the reporting period.

The average value of stock at any point in time. This is calculated as (Start value + End value) / 2.

The total cost value of items that have been consumed in the reporting period (taken out of stock).

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.