Available Stock Quantities
How do I see what I have in stock now ?
To check your stock quantites you need to access the feature labelled ‘Available Quantites’. First click on ‘Administration’ and then ‘Available Qtys’. See screenshot below :
This feature has a control that enables you to select a specific date that occurs now or in the past. The time is always set to 23:59 which signifies the close of day. If, for example you need to know the quantities of your products as at the 28th of February, you would set the control as shown in the screenshot below :
Once you have selected the date, all you need to do is to click on ‘Execute’. The system will calculate the exact quantites according to your selection. The feature contains multiple fields amongst which are the following important ones :
| Field Name | Description |
|---|---|
| Code | Product Code |
| Product Description | Description of Product |
| LocationName | Store Location (handles multiple locations) |
| UnitQty | Quantity of Product as at the selected date and time |
| BrandName | Brand Name linked to product |
| Supplier | Default supplier name of product |
| UnitRetail | Selling price excluding Vat |
| UnitWholesale | Selling wholesale price excluding Vat |
| AvgUnitCost | Average weighted cost of product |
| LastUnitCost | The price of the product the last time it was purchased |