A1.20 : Stock: Balance Qty vs On Hand Qty vs Available Qty vs Forecast Qty

A1.20 : Stock: Balance Qty vs On Hand Qty vs Available Qty vs Forecast Qty

Question : What is Balance Qty, On Hand Qty, Available Qty, Forecast Qty, in Available Stock Status?


Answer :

Balance Qty : quantity of stock according to book records

On Hand Qty : Balance Qty + Outstanding Consignment Qty

Available Qty : On Hand Qty – Reserved Qty

Forecast Qty : Available Qty + Outstanding P/O Qty + Outstanding A/O Qty (Finished Goods)

A/O stands for Assembly Order


** Outstanding Consignment Qty : quantity of stock consigned out / in (but not yet sold)

Negative quantity indicates CSGN out.

Positive quantity indicates CSGN in.


** Reserved Qty : Outstanding S/O Qty + Outstanding A/O Qty (Raw Material) + Outstanding POS Qty

S/O stands for Sales Order


Stock definition.png


--Source from AutoCount Wiki --

    • Related Articles

    • A2.122 : How to reset stock balance to 0?

      Question : How to make all stock QTY become 0? Solution : Adjust your stock quantity by using stock adjustment. For Accounting 2.0/POS 5.0: Go to AutoCount 2.0 Management studio/ AutoCount 5.0 Management studio Tools > Reset Stock Balance Quantity ...

    • A5.93 : Stock - Reports : Stock Balance

      This function allows you to generate Stock Balance report. Stock Balance is used to view each stock balance quantity as at specific date by location, by stock. If you are running Periodic Inventory System, it can also be used to obtain the total ...

    • A5.89 : Stock - Transactions : Stock Adjustment

      This function allows you to manage your Stock Adjustments. Stock Adjustment is usually used to adjust the quantity of your stock due to specific reason such as stock damage, loss etc. *Stock Adjustment will add or deduct your stock quantity depending ...

    • A5.90 : Stock - Transactions : Stock Transfer

      This function allows you to manage your Stock Transfers. Stock Transfer is usually used to transfer stock from one location to another location. *Stock Transfer will deduct your stock from the source location (From Location) and add into the target ...

    • A2.130 : How to view stock balance from outlet to outlet

      Question : Currently my POS outlet able to check their own respective stock balance in the Check Stock Level function. They would like to check on outlet as well. Is this possible? Answer : Yes it is possible to do so. Solution : For POS3 To do so, ...