Aged Stock Analysis

The Aged Stock Analysis report illustrates how long each Item has been in stock. It is calculated on a FIFO basis. The report shows for each Item the Item Number and Name, the total stock level and the stock level for each ageing period, as defined in the specification window. The report supports up to six ageing periods.

Item No.
Paste Special    Item register
Range Reporting    Alpha
Enter an Item Number (or range of numbers) to produce an Aged Stock Analysis report for specific Item(s). Use a colon (:) to separate the first and last number.

Only Stocked Items in the range will be shown (not Plain, Service or Structured Items).

Paste Special    Item Group register, Sales Ledger
Range Reporting    Alpha
Enter an Item Group Code to produce a report covering all Stocked Items in a particular Item Group.

Paste Special    Locations setting Stock module
To produce an Aged Stock Analysis report for one stock Location, enter its Location Code here.

Paste Special    Departments setting, Assets module/System module
Enter a Department Code, to include in the report only those Items assigned to a particular Department (specified on the 'Stock' card of the Item record).

Paste Special    Suppliers in Contact register
If a Supplier Code is entered here, only those Items whose Default Purchase Item features that Supplier will be shown in the report.

Paste Special    Choose date
Enter the date when the ageing calculation is to start. If you leave the field blank, the current date will be used.

Age Limits 1-6
Use these fields to define the ageing periods.

By default and as shown in the illustration, the Age Limit 1 will be set to 30 and the Age Limit 2 will be set to 60. This will result in a report with three columns showing stock aged 0-30 days, 31-60 days and 61 days and over.

If you would like the first column in the report to show stock that arrived today (or on the Date specified above), enter 0 as the Age Limit 1. If you then enter 30 as the Age Limit 2, the second column in the report will show stock that is between 1 and 30 days old.

The age of the stock is taken from the Goods Receipt date. If you have any returned stock, its age will depend on whether you are using the Insert at Original Position in Cost Queue option in the Cost Accounting setting.

Only with Balance
Use this option to ensure only Items of which you have stock (positive or negative) will be listed.