...
a) Case 1- When the Quantity and cost amount in the reservation document are negative. The stock report shows a higher value of available quantity due to a negative reserve value.
for the below example, the actual quantity available is 100 but due to an incorrect sequence of posting, the negative reserved value increases to 110.
This happens when users create an Inventory reserve cancellation document from a Customer order and then an Invoice is created from the same Customer order, but later the user manually changes the date of the Invoice, bringing it before the inventory cancellation document date. Making the sequence look like this-
...
To solve this, you should delete the Inventory reserve cancellation document since the reserve will be offset with the Invoice document.
This will be the actual stock report after the deletion of the Inventory reverse document
Case 2- An Inventory item was not included in CO but appears in the Inventory reservation document and cancellation document. It can happen that the user might have added in CO but later it was deleted but unfortunately, it remained in the Inventory reserve document.
The reports in the Warehouses module provide detailed information on reservations made in the company warehouses. To view reservations, you can use the following reports:
...