Once you start using inventory and have a mix of orders interacting with these units, things can get very complicated quickly. You will need to carefully examine the Inventory table before making adjustments.
Include Committed and Unexported units
When updating inventory, remember to include units that are Committed and Unexported. These are units that are still "in the system" and will continue to deduct and affect your resulting Available count.
Subtract Exported from Committed
The value in the Exported column tells you how many of Committed will be taken out of the system. If you have 9 units in Committed and 9 in Exported, you can expect your Committed to turn to 0 on your next update.
In the example below, we are looking to replenish inventory and add 20 units to Starting Inventory.
The first row still has 9 units that are Committed-Unexported which will continue to deduct whereas the second row will see all 9 Committed-Exported units clear and no longer deduct.
Entering 20 units in Replace Inventory would result in the following:
You can see here that the 9 Committed-Unexported units did not clear and are deducting from the 20 to give us 11 Available.
How to edit Replace Inventory to get the right Available value
We recommend carefully setting orders to the right status so that updating inventory is done accurately. Once you've done this, here's an easy way to calculate what to enter into Replace Inventory to get the right Available value:
New Replace Inventory = Desired Available + Committed - Exported