https://help.tallysolutions.com/docs/te9rel64/Reports/Display_Inventory_Reports/H.htm

Changing the Default Ageing Period

The Ageing Analysis report produces a default ageing period of <45 days, 45-90 days, 90-180 days, and >180 days. You can define the ageing slabs, depending on the requirement.

By default, the age of the items is ascertained from the date of purchase. You can change this by altering the configuration options. To define the ageing slab press F6 .

To get the value of the stock other than by the default method

Press F7 , and select from List of Valuation Methods for e.g. Avg Cost, Avg Price, FIFO, and so on. Item details valued using FIFO are displayed as shown below:

Ageing Style

The different ageing styles that are provided in Tally.ERP 9 include the purchase date, expiry date, manufacturing date, and so on.

Press Alt+S to see the Ageing Styles .

By Date of Purchase :

Displays stocks with batches in age-wise break-up on the basis of the Date of Purchase for the given period ( F2 ).

By Expiry Date :

Displays stocks with batches in age-wise break-up for all batches, on the basis of the date of expiry. When you click B : Show Expired Batches , the batches expired for a given period ( F2 ) appear.

By Mfg. Date :

Displays the age-wise break-up, taking into account the Mfg. Date of each batch. This will help you in identifying the batches that have been created recently or that are approaching expiry, on the basis of the ageing period ( F6 ) and the reporting period ( F2 ) set.

To be Expired :

Displays the age-wise break-up for batches that will expire in the future. This will help you in deciding which batches have to be disposed of at the earliest.

The Ageing Analysis report will help you find out which batches have already expired, which batches are going to expire or you can even list them as per Manufacturing or Purchase Date . It is very useful for industries dealing with perishable goods where goods past the expiry date are of no value. The Stock Ageing Analysis Configuration menu appears as shown below:

Appearance of Stock Item Names: The list of options controls the view in which stock item names appear in the Stock Ageing Analysis report.

Sorting Method: The list of options available sorts the stock items in alphabetical (increasing or decreasing) order.

Note: You will get the options Ageing Style and Expired Batches, only if you have activated Batch processing under F11: Features (F2:Inventory) . Set the options Maintain batch-wise details? and Set expiry dates for batches? to Yes .