Case- Brief idea of how to analyze warehouse stock and what is reserved. This manual will help identify any incorrect reservations made to ensure stock is not blocked unnecessarily.
Solution-
When stock is limited but needs to be sold to the customer on priority and mandatorily, a reservation document helps to put aside the stock item for a particular customer order and will not be available for any other orders.
There are cases when stock reservation documents are recorded incorrectly due to incorrect entries made by users, or when the process is not followed accurately and due to the date of the posted documents. This manual will explain how various cases appear and ways to resolve them to ensure stock is accurate.
a) Case 1- When the Quantity and cost amount in the reservation document are negative
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-
But in actuality, the Inventory reserves EIRSRV24-000003 were created before the Invoice document, you may check the change history from more actions of the document to understand their posting time.
To solve this, you should delete the Inventory reserve cancellation document since the reserve will be offset with the Invoice 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:
- Inventory Reserves
- Stock Balances by Item
- Stock Balances by Warehouse
- Stock Balances with Locations