Hello,
Is there a way to account for inventory in transit in the inventory valuation (ie. should be in the balance sheet).
For example, let's say I'm invoiced for €1000 on January 1st (invoice is sent when order is created and we pay upfront, before shipping).
If I receive the goods in February, currently, the inventory value on January 31st will be 0, but the purchases will be €1000.
This causes the balance sheet to have 0 inventory COGS to be -1000€ (as there is no change in inventory, which is incorrect).
I should have value of inventory on hand of 0€, but stock in transit should be 1000€ as this was already invoiced. And the COGS should be 0, not -1000€.
Thank you