Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

The minimum quantity that can be reordered, or the minimum   quantity that must be in stock before a reorder can take place

Max Reorder Quantity

The converse of “min reorder quantity”, presumably.

...

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. 
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.

...