Below are some of the common queries that can arise when using Clever Landed Costs in specific regard to financial transactions.
Why did the Inventory cost not get adjusted when the actual landed cost was invoiced at a different cost to what was expected?
The most obvious reason for this is that the Landed Cost Type is set up to use the Default Cost Treatment method. Using the Default method, any difference will be posted to the Variance Account set up against the Landed Cost Type rather than updating the Item Inventory valuation.
Why has a Variance been posted?
A variance will be created when the actual landed cost invoice value is different to the expected cost that was accrued at receipt, an example of which is shown below.
| Expected Landed Cost: | 10.00 |
| Actual Landed Cost: | 15.00 |
| Variance: | 5.00 |
Where the variance posts to is dependent on the type of transaction, the Cost Treatment and the Item's Costing Method.
| Scenario | Variance Location |
| Purchase + Default | Landed Cost Variance Account |
| Purchase + FIFO + Charge Item | No separate Variance Account, actual cost updates inventory |
| Purchase + Standard + Charge Item | Purchase Variance Account |
| Transfer + Default | Landed Cost Transfer Variance Account |
| Transfer + FIFO + Charge Item | No separate Variance Account, actual cost updates inventory |
| Transfer + Standard + Charge Item | Purchase Variance Account |
Why are Transfer Landed Costs treated differently to Purchase Landed Costs?
Business Central supports "Expected Cost Posting" for receipt transactions, but transfer costs for inventory are always posted using the Actual Cost within the Item Ledger and Value Entries. Clever Landed Costs therefore follows this principle, but will move accruals within the General Ledger to allow a clear breakdown of costs.
Why have no landed costs been posted on my Transfer Receipt?
Landed costs on Transfer Orders are part of the Incoterm Allocation feature. Check that Incoterm Allocation Enabled is selected on the "Landed Cost Setup" screen. If the Landed Cost Ledger Entries were created but no G/L Entries were posted, check that Expected Cost Posting to G/L is enabled on the "Inventory Setup" screen.
Why was my Transfer Receipt stopped with a dimension or posting setup error?
From version 5.3.5, Charge Item landed costs on a Transfer Order are checked before the Transfer Receipt is posted. If the Item, Charge Item or Location has a mandatory or blocked dimension that the receipt does not meet, a dimension combination is blocked, or there is no "Inventory Posting Setup" with an Inventory Account for the destination Location and the Item's Inventory Posting Group, the receipt is stopped. Correct the setup or the dimensions on the Transfer Order and post the receipt again.
How do I find landed costs that have not yet been invoiced?
Run the Landed Cost Reconciliation report. It lists the expected landed costs that have been received but not yet invoiced, written off or reversed, and can be used to reconcile your accrual accounts. If a cost will never be invoiced, it can be written off using the Landed Cost Journal.
Why can I not change the Cost Treatment of a Landed Cost Type?
The Cost Treatment cannot be changed once Landed Cost Rules, Document Landed Costs or open Landed Cost Ledger Entries exist for the Landed Cost Type, because the existing entries were posted using the original treatment. Complete or write off the open landed costs first, or create a new Landed Cost Type with the Cost Treatment you need.
We're experiencing issues understanding the cost postings, what should be checked?
Depending on the Cost Treatment that's in use the following setup should be checked to identify any obvious issues. If unsure you should review the Financial Posting walkthroughs in the preceding help articles.
| Cost Treatment | Setup to Review |
| Default | "Landed Cost Type": Accrual Account, Variance Account, Transfer Variance Account "General Posting Setup": Overhead Applied Account, Invt. Accrual Acc. (Interim) |
| Charge Item | "Landed Cost Type": Charge Item No., Gen. Bus. Posting Group Charge Item: Gen. Prod. Posting Group "General Posting Setup": Purch. Account, Direct Cost Applied Account, Invt. Accrual Acc. (Interim), and Purchase Variance Account for Standard Cost Items "Inventory Posting Setup": Inventory Account |
| All Scenarios | "Inventory Setup": Automatic Cost Posting, Expected Cost Posting to G/L "Landed Cost Setup": Incoterm Allocation Enabled (Transfer Orders only) |