Field

Description

LAST COST PRICE

The Last Cost Price is the 'each' price as maintained for the item. The Last Cost Price is determined from the price value entered when the stock is landed using the 'Land Stock' facility.

TOTAL STOCK ON HAND

The 'Total Stock on Hand' figure is the current closing balance for the item for the selected period, which is determined from both the opening balance for the period and the given movement for the period. This quantity is shown on the 'Movement Tab' on the item details window.

S/ORDER

This figure represents the quantity of stock that has been ordered using the Sales Order module the selected period. This quantity is shown on the 'Movement Tab' on the item details window.

S/BORDER

This figure represents the quantity of stock that has been back ordered for the selected period using the Sales Order module. A backorder is the quantity of the Sales Order that has been produced that puts the stock on hand level into a negative position. This quantity is shown on the 'Movement Tab' on the item details window.

DELIVERED

This figure represents the quantity of stock that has been delivered using the Sales Order module the selected period. A delivery of stock is the quantity of the Sales Order that has been delivered by maintaining the Sales Order details TAB window for a particular order. This quantity is shown on the “Movement Tab” on the item details window.

MANUFACT

This figure represents the quantity of the item that has been reserved for manufacture. For example, items that have been used in the 'Build Items' function to create a manufactured item.

P/ORDER

This figure represents the quantity of stock that has been ordered using the Purchase Order module the selected period. This quantity is shown on the Movement Tab on the item details window.

P/BORDER

This figure represents the quantity of stock that has been back ordered using the Purchase Order module the selected period. A backorder is the quantity of the Purchase Order that has been produced therefore putting stock on hand level into a negative position. This quantity is shown on the Movement Tab on the item details window.

NETT STOCK

The Nett Stock Value represents the total quantity on Purchase order (see: P/Order) PLUS the total quantity on Purchase Order Back order (see: P/BOrder)

MIN STOCK

'Minimum Stock Value' as maintained for the inventory item in the Stock Levels section of the 'Items Detail' window.

MAX STOCK

'Maximum Stock Value' as maintained for the inventory item in the Stock Levels section of the Items Detail window.

NORMAL ORDER

Reorder Stock Value as maintained for the inventory item in the Stock Levels section of the Items Detail window. It should represent the normal quantity in which the stock is ordered.

SUGG. REORDER

The suggested reorder is calculated based on the above mentioned stock quantity levels as follows:

If the Nett Stock is less than Min Stock

Then the Suggested Reorder quantity = Normal Order X (Max Stock - Nett Stock) / Normal Order

If the Suggested reorder calculated is less than (Max Stock - Nett Stock)

Then we add the Normal Order to the Suggested reorder already calculated above

If the Nett Stock is equal to or greater than Min Stock.

Then the Suggested re-order is ZERO

IGNORE NON STOCK ITEMS (Check Box)

When checked this will ignore items flagged as 'Non-Stock' items from appearing on this report. The 'Non Stock' items flag is maintained in the item 'Maintenance' window.

IGNORE ITEMS WHERE REORDER LEVEL IS ZERO (Check Box)

When checked this will ignore items where the Normal Order is zero and prevent them from appearing on the report.

IGNORE ITEMS WHERE CALCULATED RE-ORDER LEVEL IS ZERO (Check Box)

When checked this will ignore items where the Suggested Re-Order quantity calculated (above) is zero and prevent them from appearing on the report.