Hi all,
We have an issue with inventory for one customer that is as below:
We have items which we hold as third part stock in a Legal entity. This stock arrives at the warehouse at 0 value. If we have an order from our customer, we raise a purchase order to our supplier for the stock. We therefore receipt the PO with a purchase price. We then write off the original third-party stock at zero value. However, because the item has the latest the purchase price and cost price parameter ticked, the write off pulls through the latest cost and therefore shows as a loss rather than 0. In this instance we want to reverse the negative cost, so it shows a nil when writing off.
My observations during investigation in order to reverse the loss:
- I thought I can post the transactions as below:
- Post an Inventory adjustment entry with the same positive quantity at the same price that the original write-off adjustment was posted. This will create null the inventory loss amount but creates an increase in the stock for this item.
- Turn off the Last cost price parameter and then post an inventory adjustment entry with negative quantity at zero price. So that this will write-off the quantity for this item.
But the system still defaulted the latest cost price (which is different from the original write off journal that Customer posted) to the Inventory journal lines which again created another inventory loss.
So please suggest me how this Inventory loss transaction can be written off at zero price so that quantity and inventory cost is zero.