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 updated as transaction statuses of Sales and Inventory transactions are updatedThe calculated in real-time as quantities (on participating transactions) are updated and saved. The Available Balance is calculated as follows:

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

    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