Hi all, whats the best way to know the total inventory value based on our different cost layers, we use FIFO and multicurrency, so on the same item we could have different values based on the date it was received.
I need this because some times when we have an audit, thay want to compare the value on the inventory module to the value on the different GL accounts.
If I take "item qtys" * "current cost" won't give the correct value cause of the different cost layers.
So how can I do it by not going manually to every item and checking one by one the cost layer?
Regards.
*This post is locked for comments