Hello,
I am having an issue with inventory valuation on a specific item and a specific site and I cannot figure out how the system settled on the valuation. Attached is detailed inventory valuation listing from Dec 2022 - March 2023. All of the past period valuation and the transactions seem to be between 5.24-5.94. Yet somehow at the end of Period 12 (March 2023) the ending valuation is $1.19. I cannot figure out in the attached file where the issue is so I am wondering if this could be some kind of DB issue?
I have already ran the Validate Inventory with no change. We are also using the FIFO valuation method.
Let me know if you see anything in the attached which may be causing this issue.