image_pdfimage_print

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” :

Samooha icon2  View and search for product’s ageing data

Samooha icon2  Print product’s ageing report

Product Ageing Register

 

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

Product Ageing Register1

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

Product Ageing Register2

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

Product Ageing Register4

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

Product Ageing Register5

 

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