NetSuite物料在手量、可用量、在途量、拖欠量说明和计算公式

NetSuite物料在手量、可用量、在途量、拖欠量说明和计算公式

Quantity On Hand – Enter the quantity currently stocked that has not been used to fulfill orders. Thiscount includes the quantity committed.
If you use Multiple Units of Measure, the quantity on hand is calculated using stock units.

Note: In NetSuite accounts that are not enabled for OneWorld, you can enter initial quantities on hand in each location when you create an item record. However, in a NetSuite OneWorld account, you cannot enter initial quantities on hand when you create an item record. You must first create the item record, and then afterwards, you must enter an inventory adjustment to specify the initial quantities in each location.Read the help topic Adjusting Inventory or OneWorld Overview for more details.

Quantity on Hand (Base Unit) – This field displays the quantity on hand in base units of measure.

Value – The calculated value of the item shows in this field.

Quantity Committed – The quantity of this item that are already committed to orders shows in this field.
Quantity Committed to an open Sales Order, Transfer Order or Work Order. Includeing Sales Order related Item Fulfillment that has status of Picked or Packed.

Quantity Available – The quantity of this item that are on hand and available to be committed to orders shows in this field.

Quantity Available (Base Unit) – This field displays the quantity available to be committed in base units of measure.

Available Quantity （可用量） =  {quantityonhand}-NVL({quantitycommitted},0)

Quantity on Order – The quantity of this item that have been ordered but not yet received shows in this field.

Pending Receipt Quantity（采购在途量）= {quantity}-NVL({quantityshiprecv},0)

Quantity in Transit – This field shows the quantity of the item that is currently being transferred from one location to another. For any quantity of items that is in transit, that quantity is reduced from the On Hand count for the item at the source location. The quantity is not added to the receiving location until the transfer order is marked received.

In Transit Quantity (转移在途量）

Quantity Back Ordered – This field shows the quantity of the item that has had orders entered but no stock is available to be committed to the order.

Back Ordered Quantity（拖欠量）=  {quantity}-nvl({quantitycommitted},0)-nvl({quantityshiprecv},0)