Introduced in Version 5.0.0 of Clever Landed Costs, we have added capabilities to use Charge Items to post both the expected and actual costs associated with "Landed Cost Types". This provides powerful functionality that ensures that the costs associated with importing goods can be held directly against inventory and most importantly will flow through to use or sale of goods with accurate costing.
For expected costs you must ensure that the Gen. Bus. Posting Group is setup against the "Landed Cost Type", the Inventory Account (Interim) for the relevant "Inventory Posting Setup" and the Invt. Accrual Acc. (Interim) is correctly specified through the "General Posting Setup".
For actual costs, as per standard inventory costing principles you will need to setup the Direct Cost Applied account in "General Posting Setup" and the Inventory Account for the relevant "Inventory Posting Setup" for the relevant "Landed Cost Types" and Item records.
Purchase Scenario
Purchase Order is placed for an Item with the following expected costs.
- Item Cost of 150.00
- Expected Landed Cost of 25.00
The Purchase Order is received into Inventory at which point Inventory and Accruals are posted for the above costs.
Subsequently a Purchase Invoice for the Landed Costs is received with a value of 30.00, which is 5.00 more than originally expected.
Purchase Receipt
When the goods are received within Business Central the following postings will be made, incorporating the Item and Expected Landed Costs into the Inventory account and posting accruals for both the Item and Landed Costs.
| Account Type | Account | Amount |
| Balance Sheet | Inventory Interim | 175.00 |
| Inventory Accrual | -150.00 | |
| Landed Cost Accrual | -25.00 |
Landed Cost Invoice Posting
When the Landed Cost Invoice is assigned to the Inventory and posted, the following financial transactions are made, posting the Invoice value to the Creditors account and then handling the Landed Costs by reversing the accrual and posting any variance for the Landed Cost.
| Account Type | Account | Amount |
| Balance Sheet | Creditors | -30.00 |
| Landed Cost Accrual | 25.00 | |
| Inventory (Interim) | -25.00 | |
| Inventory | 30.00 | |
| Income Statement | Direct Cost Applied | -30.00 |
Transfer Scenario
FOB Incoterms are in place, therefore additional costs are incurred at the point of moving goods from a Vessel into Port.
- Expected Landed Cost of 10.00
The Transfer is received into the new Location and the accruals are posted.
Subsequently a Purchase Invoice for the Landed Costs is received with a value of 11.00, which is 1.00 more than originally expected.
Transfer Receipt
When the goods are received within Business Central the following postings will be made, treating expected landed costs as an actual cost variance on the Transfer Receipt and posting the accrual for the landed cost.
| Account Type | Account | Amount |
| Balance Sheet | Inventory Account | 10.00 |
| Income Statement | Direct Cost Applied | -10.00 |
Landed Cost Invoice Posting
When the Landed Cost Invoice is assigned to the Inventory and posted, the following financial transactions are made, posting the Invoice value to the Creditors account and then handling the landed costs by simply posting any variance to Inventory and Direct Cost Applied accounts.
| Account Type | Account | Amount |
| Balance Sheet | Creditors | -11.00 |
| Inventory Account | 1.00 | |
| Income Statement | Direct Cost Applied | -1.00 |