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. 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-
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.
This will be the actual stock report after the deletion of the Inventory reverse document
Case 2- An Inventory item is not included in the Customer order but appears in the Inventory reservation document and Inventory reserve report.
It's possible that the item was first added to the Customer Order (CO), then an Inventory reserve document was generated from the CO, and subsequently, the user deleted the item from the CO. The Customer Order (CO) is closed because the added item has already been sold, yet the reserved item remains stuck.
For example, the stock balance indicates there are 100 units available, but in reality, there are 200 units. The almond oil was initially added to the Customer Order (CO) and later removed because the customer no longer needed it, but it remains reserved in the inventory.
To solve this, create an Inventory reserve cancellation document from the CO document using the Generate option. This will help to remove the reservation
Case 3- Only value in cost amount, negative amount, or positive
This happens for reasons when cost price during the Inventory reserve
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