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 / 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 / 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. If you choose specific stock items, the report will sort information by stock item code rather than description. Select the start stock code and the end stock code for the report. |
|
Group Type |
Select group type on the drop-down arrow |
|
Group Selection |
Double click on the code from the list to move the group codes you wish to filter your report by to the selected window. |
|
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 |
Choose from the drop-down menu how you would like your report sorted, your options are by Stock Code or Stock Description. |
|
Show Inactive Items |
Put a tick on to show inactive items in your report |
| 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 |
No Comments