The Product Ageing Register allows the user to view the stock inventory of a particular product in a three dimensional view, from the number of days in stock, stock value, and stock ageing. Below are available actions for the user from “Product Ageing Register” :
View and search for product’s ageing data
Print product’s ageing report
Field Name |
Description |
Mandatory Information |
| Product | Select a product to view |
Y |
| As On | Specific Date |
Y |
| Show Quantity / Value | Show quantity or value information |
Y |
| Date | Self-Explanatory |
Y |
| Document# | Self-Explanatory |
Y |
| Reference# | Self-Explanatory |
Y |
| Batch # | Self-Explanatory |
Y |
| Exp. Date | Expiry date, if any |
N |
| WH# | Warehouse number |
Y |
| WH Name | Warehouse name |
Y |
| UOM | Unit Of Measure |
Y |
| Qty In | Self-Explanatory |
Y |
| Qty Out | Self-Explanatory |
N |
| Balance Qty | Self-Explanatory. |
Y |
| Unit Cost | Self-Explanatory |
Y |
| Value In | Self-Explanatory |
Y |
| Value Out | Self-Explanatory |
N |
| Balance Value | Self-Explanatory. |
Y |
| Days In Stock | Based on the date of receiving as on (selected) date |
Y |
View and Search for Product’s Ageing Data:
1. Select a product from “Product” drop-down list at the top of screen. It will pull up the selected product’s ageing data and inventory movements for each warehouse
2. Select a date in “As On” drop-down list to further filter the product’s ageing data
3. Select an option from “Show Quantity / Value” drop-down list on top right of screen to switch the product’s ageing data view between product’s quantity and values
4. Enter search parameter to filter the result, i.e. type in the product batch number in the search textfield box at the bottom of the screen.
5. Select ageing period from “Days In Stock” drop-down list at bottom of screen
6. Right-click on a product’s document row, a small pop-up pane will appear showing option to open source document of the product’s transaction
Print Product’s Ageing Report:
1. Select a product from “Product” drop-down list at the top of screen. It will pull up the selected product’s ageing data and inventory movements for each warehouse
2. Click on “Generate Report” button at bottom of screen, a window will come up showing print report options.
3. User can print report, export the report as pdf or excel, or preview the report