How to handle Estimated vs. Actual Landed Cost without generating variance adjustment transactions?

Hi ​@nomii ,

Can you try below-

Vendor confirms shipment + final invoice
        ↓
Enter AP Bill (actual amount) → Save (don't post yet)
        ↓
Warehouse receives goods → Receipt auto-links to AP Bill
        ↓
Release AP Bill → Release Receipt (same session)
        ↓
No variance document generated 

Hope above helps!!

@nomii those two lines aren't a separate adjustment document you can switch off. They're part of the AP bill's own GL batch. When the bill amount differs from the landed cost document, release posts a credit to Landed Cost Accrual and a debit to the Landed Cost Variance account on the landed cost code, on top of the normal AP and accrual lines. Same amount on both sides and the extra pair never appears. Different amounts and it always does. The help topic lays out both postings: https://beacon.acumatica.com/access?ft:originId=_0a7b52b2-1116-4c61-bf79-fb0a6c4f9d1e

So the only way to avoid them is to have the actual before the landed cost document is released. Rakshanda's sequence does exactly that: bill in hand first, then the landed cost document carries the real amount. If your carrier invoices before you receive, that's the right fit.

For goods that ship out before the freight bill arrives, the variance is doing its job. Any landed cost posted after units have already been issued goes to the variance account for the issued share no matter which order you do things in, because Acumatica won't load a late cost onto units that are no longer on hand. Laura03 walks through that exact case here: https://community.acumatica.com/distribution-6/landed-cost-variance-12023. If you'd rather see the true-up in cost of sales than in a variance line, point the code's Landed Cost Variance account at your COGS account on Landed Cost Codes (PO202000). That only affects bills released after the change.

Thanks for the explanation!

In our case, we want to enter landed costs immediately upon receiving goods into the warehouse so that we can accurately record the incoming inventory value. Previously, we usually waited until we received all landed cost bills before entering them at once, which resulted in inaccurate inventory valuation reports.

To handle this, we enter estimated landed costs on the Landed Cost document when receiving goods, and then link the actual vendor bills when they arrive later to handle any variance.