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).
Group: 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.
Location: Paste Special Locations setting Stock module; To produce an Aged Stock Analysis report for one stock Location, enter its Location Code here.
Department: 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).
Supplier: 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.
Date: 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.

Previous Next Top Entire Chapter in Printable Form