...
Field | Description |
Location | The name of the location. |
Supply Type | The way in which stock is allocated to sales from that location. For example, you may have a specific location for quarantined stock. |
Quantity On Hand | The amount of stock on hand at this location. |
Old Quantity On Hand | The previous quantity on hand before the last stocktake. |
Minimum Replenishment Quantity | Used to replenish stock between bulk and pick locations. Such as when automatically replacing parts used on a truck. |
Initial Quantity On Hand | Initial quantity on hand at the start of the stocktake. |
Maximum Replenishment Quantity | Used to replenish stock between bulk and pick locations. Such as when automatically replacing parts used on a truck. |
Counted | Checked if the stock has been counted. |
Is Primary | Checked if this is the primary location for this product. The system sets the primary location to be the location with the most stock in the site for that product. |
...
Field | Description |
On Hand | The number of products on hand that are available to be allocated to an order. |
Net On Hand | The total number of products currently on hand. This includes all stock, including allocated, quarantined, etc. |
Service Back Order | The quantity on back order from service orders |
Sale Back Order | The quantity on back order from sales orders |
Transfer In | The quantity waiting to be transferred in to the site |
Transfer Out | The quantity already transferred out of the site. But not yet receipted by the transfer to site |
Transfer Pending | The quantity in outstanding transfers that have not yet been picked |
Transfer Pick | The quantity in outstanding transfers that is currently being picked |
Purchase Order | The number of products that are at the location, but have been assigned to a purchase order. |
Lay-By | The number of products that are at the location, but have been assigned to a lay-by. |
Allocated | The number of products that are at the location, but have been allocated to an order. |
Available | The number of products that are available to be allocated to an order. |
Stock Waiting | Stock on a Sale Order\Service Order where the supply type on a Sale Order\Service Order is set to waiting. |
...
Field | Description |
Date | The date that the movement took place. Depending on your filter settings, this will be either creation date or transaction date. |
Period | The financial period when the transaction took place. |
Type | The transaction type. |
Transaction Number | The number for the transaction. |
Card | The name of the card associated with this transaction. |
Quantity | The quantity of products moved. Not sure whether a negative quantity means a sale or a purchase, or whether it’s a data issue. |
Quantity on Hand | The quantity of products on hand after the transaction? |
Location | The location of the product. |