In the product register the user able to view and track individual product’s transactions history, quantity, and values. Below are available actions for the user from “Product Register” :
View and search for product’s transactions history
Field Name |
Explanation |
Mandatory Information |
| Product | Select a product to view |
Y |
| Warehouse | Select a warehouse (or all warehouses) to view |
Y |
| Year | Year of transactions history to view |
Y |
| From | Self-Explanatory |
N |
| Till | Self-Explanatory |
N |
| Stock Qty – Op. Stock | Total opening stock |
Y |
| Stock Qty – Qty In | Total incoming stock |
Y |
| Stock Qty – Qty Out | Total outgoing stock |
Y |
| Stock Qty – Cl. Stock | Total closing stock |
Y |
| Stock Value – Op. Value | Total opening stock values |
Y |
| Stock Value – Value In | Total incoming stock values |
Y |
| Stock Value – Value Out | Total outgoing stock values |
Y |
| Stock Value – Cl. Value | Total closing stock values |
Y |
| Date | Date of transaction |
Y |
| Document # | Self-Explanatory |
Y |
| Reference # | Self-Explanatory |
N |
| WH # | Warehouse number |
Y |
| Table – Warehouse | Self-Explanatory |
Y |
| Type | Type of transaction |
Y |
| Batch # | Self-Explanatory |
Y |
| Qty In | Self-Explanatory |
N |
| Qty Out | Self-Explanatory |
N |
| Unit Cost | Self-Explanatory |
Y |
| Table – Value In | Self-Explanatory |
N |
| Table – Value Out | Self-Explanatory |
N |
View and search for product’s transactions history:
1. Select a product from “Product” drop-down list at the top of screen. It will pull up the selected product’s transactions history
2. Select a warehouse from “Warehouse” drop-down list at the top of screen to filter the result. User able to choose “Select All Warehouse” as well
3. Enter year, from date and till date to further filter the product’s transactions history
4. Click on “Stock Qty” tab or “Stock Value” tab on top right of screen to switch the product’s transactions history view between product’s quantity and values
5. Enter search parameter to filter the result, i.e. type in the document number in the search textfield box at the bottom of the screen
6. Select type of transaction to show from “Type” drop-down list at bottom of screen
7. User can choose to show the product’s transactions history with or without internal movements from “Show” drop-down list at the bottom of screen
8. Right-click on a transaction row, an option will pop-up to show details of the selected transaction
