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> Reports> Reports List
| 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 |
Choose the date range for which you want to view the report Select the date from on the menu drop down selection |
| Warehouse |
If you select all warehouses the report will fetch data from all warehouse If you want to search by a specific report, select the report on the warehouse selection |
|
Stock Code From |
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 If you choose specific stock items, the report will sort information by stock item code rather than description |
|
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 |
|
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 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 |