The item age composition page shows a summary (quantity and total value) of the current inventory by aging bands. This is important for showing the turnover of stock.
The item age composition can be accessed by selecting the Item Age Composition action from the Statistics group on the ribbon of the either the Item, Stockkeeping Unit or Location List or Card:
Depending on where the page is accessed from it will show different information.
- Item List/Card
The view will show item aging for all stock of the particular item.
- Stockkeeping List/Card
The view will show item aging for all stock of the particular item for the specified location and item variant (if applicable).
- Location List/Card
The view will show item aging for all items for the particular location.
The view can be changed by amending the fields on the options tab.
The Aged as at Date determines the starting date used for the aging of stock.
The No. of Periods defines the number of aging bands shown on the analysis.
The Period Length determines the duration of the aging band. This should be entered as a date formula.
The Heading Type determines if the titles of the aging bands should be shows as a Date Interval or a Number of Days.
For the inventory value you can choose whether to show the value including expected costs by enabling the Include Expected Costs field. If you choose not to include expected costs then the inventory value will not include stock which and been received but not yet invoiced.
The chart tab shows a visual representation of the aging bands.
The chart can be shown as either a Pie Chart or Column Chart by selection the appropriate option from the Chart Type group of the ribbon above the chart:
The chart can show values either Inventory Quantity or Inventory Value by selection the appropriate option from the Show group of the ribbon above the chart:
Select Refresh from the ribbon above the chart to update the chart data: