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 participating transactions) are updated and saved. The Available Balance is calculated as follows: ExampleCommentFor a Lot on hold, if the On Hand balance is >0, this would represent the On Hand balance, otherwise this would be 0.00The ordered / requested balance, that has not yet been allocated, on an open transaction for outgoing product. If Allocated is less than Ordered, then it is calculated as: [Ordered] - [Allocated] otherwise it is 0.00.The ordered or requested balance, that has not yet been allocated, on an open transaction for incoming product. If Allocated is less than Ordered, then it is calculated as [Ordered] - [Allocated] else 0.00.The allocated balance, on an open transaction, for outgoing product.The allocated balance, on an open transaction, for incoming product. 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
|