HansaManuals Home   >> Standard ERP   >> Stock   >> Reports  

Previous   Next               Entire Chapter in Printable Form               Search  

This text refers to program version 5.1  

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).

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