I've got an unusual issue that's affecting a number of our invoices. Some of our import cost are being expensed/apportioned twice.
Example highlighted in yellow in the attached image (summary of journals generated from shipment). Also attached are the inventory classification-GL mappings for the imported goods.
In this shipment I suspect a lot of the received goods were used in builds and/or sold shortly after receipt (likely before all import costs were entered/invoiced/apportioned).
We have three invoice costs:
i) Customs Disbursement Charge $201.00. This appears to be apportioned correctly, presumably while most of the inventory is still on hand (e.g. most of the costs are apportioned to the inventory accounts and only $8.50 is expensed to COGS as a variance). That said, only $200.74 is cleared out of our shipment costs clearing account, and a small amount is written off to stock adjustments.
ii) Freight cost - main issue here. $10,854.76 is invoiced. This amount is mostly expensed to COGS as a variance with $1,313 apportioned to inventory. At the same time, almost the exact amount is written off to stock adjustments, putting the shipment cost clearance account into credit by this amount.
iii) Destination Port Charges appears to apportion correctly.
Has anyone encountered this before? Any ideas? Bug or 1D10T user error?