Versions Compared

Key

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


Excerpt

The Available balance reflects the quantity of inventory that is available to be allocated to a Sales or Inventory transaction. Available balances are calculated in real-time as quantities (on Sales and Inventory participating transactions) are updated and saved.The  The Available Balance is calculated as follows:

  • (+) On Hand Balance
  • (-) On Hold Balance
  • (-) Committed: Positive quantity 
  • (+) Committed: Negative quantity 
  • (-) Allocated: Positive quantity 
  • (+) Allocated: Negative quantity 

    OperatorBalance TypeBalance QtyRunning Calculation
    Start withOn Hand1,0001,000
    SubtractOn Hold01,000
    SubtractCommitted (-)700300
    AddCommitted (+)200500
    SubtractAllocated (-)400100
    AddAllocated (+)100200
    Available Balance200

    The Available balance calculation is dynamic based on how the the following Inventory Preferences are configured:

    • Include Sales Quote Transactions in Available Balances
    • Include Shipped & Approved Sales Orders in On Hand balances
    • Include open Adjustment Production transactions in Available balances
    • Include open Production Adjustment transactions in Available balances
    • Include open Receipts Transfer transactions in Available balances
    • Include open Transfer transactions non-PO Receipt lines in Available balances
    • First Status to include unreceived Purchase Order Quantities in Available 
    • First Status to include Production Order Inputs in Available Balances
    • First Status to include Production Order Outputs in Available Balances