Hi everyone,
I am facing an issue with Landed Cost allocation in Acumatica and would like to seek your advice on whether this is a standard system behavior or a configuration/process issue.
Here is my scenario:
-
Valuation Method: The stock item uses Average cost valuation.
-
Receipt: I received 100 units into Warehouse A (Location: INV).
-
Transfer: Immediately after the receipt, I transferred all 100 units from Warehouse A to Warehouse B. So, the quantity in the original receipt cost layer at Warehouse A is now 0.
-
Landed Cost: Afterwards, I created and released a Landed Cost document allocated to this receipt.
-
Result: When the Landed Cost document was released, the system generated an Inventory Adjustment. However, the entire Landed Cost amount was posted to the Landed Cost Variance Account (which is mapped to my COGS account). Nothing was added to the Inventory Account.
I want the system to follow this logic:
-
If the goods are still in stock (not sold), even if they have been transferred to another warehouse, the Landed Cost should be capitalized into the Inventory Account.
-
If the goods have been sold, the Landed Cost should be posted to the Landed Cost Variance Account (COGS).
---
Since the goods were only transferred between warehouses and not yet sold, how can I configure the system so that the Landed Cost is capitalized into the Inventory Account instead of being posted entirely to the Landed Cost Variance Account?
I appreciate any insights or experiences you can share!
Thank you!