Inventory - various costs


Hi all!

I am using the template inventory and sales table.

However, for the same product or SKU number, if I order another purchase order of the same product later, it might have a different cost due to the difference in exchange rate.

I therefore would like it to record the inventory in terms of using up the same product at the first cost price first, then move onto the items on the second purchase order (first in first out). Has anyone managed to do this successfully?

Thank you!