Site

The site. There will usually be one entry per site in this   list.

Quantity on Hand

The quantity of this item that is available at this site.

Net Quantity on Hand

The total number of products currently on hand. This includes all stock, including allocated, quarantined, etc.

If Stock allocation is turned ON

QuantityAvailable = QuantityOnHand - QuantityOnTransferOut - QuantityOnTransferPick - QuantityOnLayBy - QuantityAllocated;
If Stock allocation is turned OFF

QuantityAvailable = QuantityOnHand - QuantityOnTransferOut - QuantityOnTransferPick - QuantityOnLayBy - QuantityOnSaleOrder;

Sales Value Ex Tax

The sales value of all stock of this product at this site, excluding tax.

Stock Waiting

Stock on a Sale Order\Service Order where the supply type on a Sale Order\Service Order is set to waiting. 
How to set the supply type to waiting on a Sale Order\Service Order you will need to set the ship after date to the future.

Sales Value Inc Tax

The sales value of all stock of this product at this site, including tax. The number of days to use in product sales calculations can be changed using the set date button on products.

Sales Quantity

The quantity of the product sold during the currently specified time period.

Field

Description

Gross Profit % Today

Ratio of the Margin to Value ex Tax as a percentage.
The formula for GP % is = Margin Divided by Value ex Times 100

Gross Profit % Overall

The gross profit searches for all sale order\ Service order lines and sums up all the Value Ex Tax Ordered and Cost Ex Tax Ordered.
The formula is Overall for all Sale for this particular products Sum(Margin\Value ex) times 100

Min Reorder Quantity

When using the min/max reordering method, purchase runs identifies the need to reorder the product using the Minimum Reorder Quantity. Where the net stock on hand for the product is less than or equal to the minimum reorder quantity.

Max Reorder Quantity

When using the min/max reordering method, purchase runs calculates the quantity to reorder by subtracting the net stock on hand from the Maximum reorder quantity. The result is then rounded to a multiple of the product supplier's minimum order quantity.

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.

	Allocate	Back Order	Ship Allowed	Use Case / Notes
Allocate	Any stock that is available	Remaining quantity		Default. Used in the majority of cases.
Ignore	No	Full quantity ordered		Behaves like stock allocation was turned off. This has several implications. No stock allocation. If you create a shipment, for eg by clicking on the ship button or by auto warehousing, the whole on-order quantity will be extracted to the sale shipment.   Whether or not there is sufficient stock to supply the goods.   Sale shipments include everything on order when stock allocation is turned off. This could be used in the case where the customer has their supply type set to Ignore and their order is always drop shipped from the supplier (purchase order raised from sales order). You can set a supply type on all lines of the sales order to Ignore and hit the ship and use the Show In Report to get a Pro Forma Invoice that you can send the customer before you do invoice them.
Priority	Any stock, even if it's been allocated elsewhere	Remaining quantity		Urgent orders.
In Stock	Only allocate if full quantity remaining on order is available	No		The behavior of in stock is only allocate stock if the full quantity remaining on order is available. If full quantity is not available fully back order the item. Allowing users to purchase the whole amount. One shipment per line
Back Order	No	Full quantity ordered		Manually control the order processing however still want to increase the stock quantity on hand via purchase run.
Quarantine	No	No		Location for returned stock or over supply of stock quantity for reviewing and processing at a later time.
Waiting	No	No		Set by the system if the order has a future "Ship After" date or is waiting on stock from drop shipments or allocated purchases.

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.

On Hand

The total number of products on hand inclusive of those allocated for that site.

Net On Hand

The total number of products that is for that site excluding allocated stock.

Service Back Order

The total quantity on back order from service orders for that site

Sale Back Order

The total quantity on back order from sales orders for that site

Transfer In

The total quantity waiting to be transferred in to the site for that site

Transfer Out

The total quantity already transferred out of the site. But not yet receipted by the transfer to site for that site

Transfer Pending

The total quantity in outstanding transfers that have not yet been picked for that site

Transfer Pick

The total quantity in outstanding transfers that is currently being picked for that site

Purchase Order

The total quantity of products that are on a purchase order for that site.

Lay-By

The total quantity of products that are on lay-by not finalised for that site.

Allocated

The number of products that are allocated to any orders for that site.

Available

The number of products that are available to be allocated to an order for that site.

Stock Waiting

Stock on a Sale Order\Service Order where the supply type on a Sale Order\Service Order is set to waiting. 
How to set the supply type to waiting on a Sale Order\Service Order you will need to set the ship after date to the future.

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.