Hi,
I have a setup that temporarily requires negative physical and financial inventory. I use, Site, Warehouse, Location and Batch. The quantity of the goods can vary while it transports between the locations.
My Storage dimension is setup to follow physical inventory on SWL and Financial value on SW (location not possible to check).
The item model group allows negative financial and physical inventory. I have one with FIFO and one with Weighted average.
Now to my problem. While the goods flow between the locations, I always adjust the former location, should there be anything left, negative or positive. A fincancial value is first added during the process, not from start.
I use inventory adjustment journals and transfer journals. It all ends with a sales order invoice. When all transactions are done, the inventory has 0 quantity, but some negative financial amount left.
After the inventory close, I receive several rows of negative financial value. Since all transaction for that specific batch are closed, I don't know how to get rid of the negative amount. I appreciate any help here.
Inventory on hand
Inventory transactions
