Skip to main content

Inventory Age Analysis

Gives movement - In and Out - of Inventory Items based on the Audit date and Time

Inventory age analysis shows how many times the average inventory quantity is used in a given period

Inventory Module> Report> Inventory Age Analysis

image.png

Standard Report Put a tick on if you wish to generate a standard report
View As Age Buckets

When selecting this option, the group code option will only filter the

group code and not group by them
Summary of Movement Put a tick on if you only want to see summary of movement on your report and not a detailed

GRV Age Buckets

 Put a tick on to view GRV age buckets on the report
Date From / Date To

Choose the date range for which you want to view the report

from / Select thea date fromrange of when you want to see up to on the menu drop down selectionreport.
Warehouse

If you select all warehouses the report will fetch data from all warehousewarehouses.

If you want to search by a specific report,warehouse, select the reportwarehouse onfrom the warehouse selectionmenu.

Stock Code From / To

Select a stock item you wish to search from

If you leave the stock item fields blank, all stock items will be displayed on the report

report.

If you choose specific stock items, the report will sort information by stock item code rather than descriptiondescription. Select a stock Item on the drop-down menu.

Group Type

 Select group type on the drop drop-down arrow

Group Selection

 Select a group on the drop drop-down menu selection

FIFO List

 Put a tick on if you wish for a report to show the First In First out summary
FIFO Detailed Put a tick on if you wish for a report to show First In First Out details

Date To

Select end date for this report

Stock Selection

 Choose a stock selection between quantity and value

Stock Code To

Select a stock item where it should stop running

Sort By

Select a sort criteria on the drop down menu selection

Show Inactive Items

 Put a tick on to show inactive items
Decimal Places

It is advisable to set decimals to two placesplaces.

You can view the report with any number of decimal places
Generate Button

Click the "Generate" button to open the report

You will have options to copy, email, or print the report

To view the report in an Excel document, copy the report and paste it into an Excel file

Back to top