In a scenario where Cash sale is created and and billed without creating Item fulfillment
Item fulfillment is not creating and the there is a Fully cash refund, it will increment the total quantity of the item.
In a scenario where Available Quantity is 100
Created a SO/Cash sale with Quantity 10
Quantity available – 90
On hand – 100
Committed – 10
Inventory Status after SO created
Cash Refund (Fully refund)
Create cash refund for the SO with Quantity 10, it will result a increment to the Item Quantity available and Quantity on hand
Inorder to resolve the increment in Quantity, create a Dummy Item fulfillment for the SO with same Quantity – In the memo field, give description Dummy Item Fulfillment
Tabular Explanation of the Process
| Sales Order(Qty) | Cash sale | Cash Refund | Dummy IF | Quantity Available | Quantity on Hand | Quantity Committed |
|---|---|---|---|---|---|---|
| – | – | – | – | 100 | 100 | – |
| 6 | – | – | – | 94 | 100 | 6 |
| – | 6 | – | – | 94 | 100 | 6 |
| – | – | 6 | – | 100 | 106 | 6 |
| – | – | – | 6 | 100 | 100 | – |
In this method, Sales report shows Quantity available and Quantity on Hand as 100 each.