Def - Allocated (-) Balance

Owned by Tom Williams
Last updated: Apr 12, 2024 by Emma Greenwood

The Allocated (-) balance is the quantity, that has been allocated, on an open transaction containing outgoing product. The Allocated (-) balance reduces the Available balance. Unlike Committed (-) which represents "requested" demand on product, Allocated (-) represents the quantity that has been "assigned" and has/will ship. For example, if a Customer orders 15 cases and only 10 are allocated, the Available balance will be reduced by 15 made up of Allocated (-) of 10 cases and Committed (-) of 5 cases.  The Allocated (-) balance is comprised of:

  • Inventory transactions where the quantity of a Lot Tracked line item where the item has been saved with a Production Batch and/or Warehouse Lot (if the Site is Warehouse Lot tracked). For example, if 10 Cases were entered on a Production Input line item and either the Production Batch or Warehouse Lot was assigned, the Allocated (-) balance for that transaction would be 10.
  • Production Orders where the quantity of an Input line item has been saved without a Production Batch and/or Warehouse Lot (if the Site is Warehouse Lot tracked). For example, if 10 Cases were entered on the transaction and either the Production Batch or Warehouse Lot was unassigned, the Allocated (-) balance for that transaction would be 10.
  • Sales Transactions where a line item has been allocated. 

Note: Each of the Inventory Transactions can be conditionally included/excluded from the Allocated balances based on the "Include open ### transactions in Available balances" Inventory Preference. If the preference are set to "Yes", they will be included in Allocated balances and used to update the Available balances, if they are set to "No", they will not be included in Allocated so they will not update Available balances.

Additionally, for Production Order Inputs, these can be conditionally included/excluded from the Allocated balances based on the "First status to include Production Order Inputs in Available balances" Inventory Preference. If the transaction is set to a status equal to or greater than the Preference value, and is not in a status of Closed and not set to "Do Not Include", it will be included in Allocated balances and used to update the Available balances, otherwise if the status is set to a value less than the Preference value, it will not be included in Allocated so they will not update Available balances.