Why Does the Quantity Not Available Message Appear Even Though There Is a Balance in the Warehouse?

When you save an outbound requisition (or a sales invoice or any transaction that takes a quantity out of the warehouse), the system checks the product’s balance in the warehouse on the transaction date, and that the transactions after it won’t become negative. So the system may refuse to save even though the quantity appears in the warehouse now. These are the causes of the message and the solution for each:

Cause	Message Shown	Solution
The current balance in the selected warehouse is less than the required quantity.	The quantity isn’t available for… The available quantity is …	Reduce the quantity, choose the warehouse that has the balance, or add the quantity first.
The quantity was added to the warehouse after the requisition date, so it wasn’t available on that date.	The transaction can’t be completed. The quantity isn’t enough for the item: … on the specified date	Change the requisition date to a date after the quantity was added, or record the addition with a date earlier than the requisition.
The quantity is available on the requisition date, but there is a later outbound or sale transaction whose balance will become negative if the requisition is saved.	The transaction can’t be completed. This will lead to a negative balance for the item: … in a later transaction (example: …)	Open the transaction mentioned in the message and review it, change the requisition date, or add a quantity with an earlier date.

Example of the Later Transaction

• The product’s balance in the warehouse on March 1 = 10 pieces.
• On March 10, 8 pieces were issued (an invoice or an outbound requisition), so the balance became 2.
• Now you are trying to add an outbound requisition dated March 5 with a quantity of 5.
• On March 5 the balance was 10, which is enough, but after the requisition the balance of the March 10 transaction becomes 10 − 5 − 8 = −3; so the system refuses to save and mentions the March 10 transaction in the message.

Other Causes to Check

• Warehouse: make sure the warehouse selected in the requisition is the same warehouse that has the balance; the balance is calculated for each warehouse separately.
• Unit: make sure you entered the quantity in the correct unit; issuing 5 cartons isn’t the same as issuing 5 pieces.

How do I check the balance on a specific date?

1. Open the product from Products & Services.
2. Open the tab Stock Transactions, and choose the warehouse.
3. Review the balance after each transaction around the requisition date, and the transactions after it.