Versions Compared

Key

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


Excerpt

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.Sales Transactions where a
  • Production Orders where the quantity of an Input line item has been allocated. 

The following unposted transaction lines can be included in the Allocated (-) balance.

  • Inventory Adjustments with (-) quantities and complete Lot Information. 
  • Inventory Production Inputs (things you consume during production) with (+) quantities and complete Lot Information.
  • Inventory Production Outputs (things you create during production) with (-) quantities and complete Lot Information. This would be an unusual transaction only used to reverse a previous Production Output.
  • Inventory Receipts with (-) quantities and complete Lot Information.  This would be an unusual transaction only used to reverse a previous Receipt. 
  • Inventory Transfers with a complete Lot Information (when viewed from for the sending Site). 
  • Sales Orders with (+) allocated quantities 
  • Sales Returns with (-) allocated quantities - not sure if this even allowed
(lightbulb) Note that each
  • 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.