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 a date range of when you want to see the report to

Warehouse

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

If you want to search by a specific warehouse, select the warehouse from the menu.

Stock Code From / Stock Code To

If you leave the stock item fields blank, all stock items will be displayed on the report. If you choose specific stock items, the report will sort information by stock item code rather than description. Select a stock Item on the drop-down menu.

Group Type

Select group type on the drop-down arrow

Group Selection

Select a group on the 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

Stock Selection

Choose a stock selection between quantity and value

Sort By

Sort the report by selecting one option from the drop-down menu allows the user to pull a report that will be sorted by either, Code, Description, Warehouse or Bin location.

Show Inactive Items

Put a tick on to show inactive items
Decimal Places

It is advisable to set decimals to two places.

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