Item Landed Costs

Upon posting a receipt (Purchase or Transfer) for items with an associated Landed Costs, the Expected Landed Costs are posted to the Landed Cost Ledger and the relevant Inventory Accounts, depending on the Cost Treatment setup against each "Landed Cost Type".

Costs will be posted into as detailed in the Financial Postings section of the user guide and will post to the relevant accrual account for the Landed Cost Type, which will remain as expected until an invoice for the Landed Cost is posted.

For each financial posting made by the Clever Landed Cost solution, the cost will be tracked through the "Landed Cost Ledger Entries" screen. Each entry in the ledger is linked to an associated Item Ledger Entry for the stock receipt. Furthermore if you are using a Landed Cost Type that is setup to use Charge Item Cost Treatment then the "Value Entry" table will also be flagged with the Landed Cost attribute being set. 

You are able to view the "Landed Cost Ledger Entries" from the following places

  • Tell me search
  • Find entries from either the "Posted Purchase Receipt" or "Posted Transfer Receipt"
  • Item Ledger Entries LC Cost Amount (Expected) & LC Cost Amount (Actual) field drilldowns

Document Fixed Costs

Fixed Costs that are assigned to either the Purchase Order, Transfer Order or Landed Cost Container will be posted automatically at the point that the source document is considered 'Completely Received'. This is because the fixed cost will be shared across all Items that are received for the document and therefore the share calculations cannot be performed until the final receipted quantities are confirmed.

For both Purchase Orders and Transfer Orders this will be at the point that the Quantity Received matches the Quantity for all Items on the document and for a Landed Cost Container this will be when the Status is set to Closed as this happens automatically when the Landed Cost Container is fully received. As with Item level costs, the system will also post the relevant financial and landed cost ledgers into Business Central.

If for some reason the document will not be fully received (in relation to what was originally expected) then it is possible to post the Fixed Costs manually, based on the current receipted quantities. To do so you can use the Post Fixed Costs action that is available from the Landed Costs menu the Purchase/Transfer Order screens and directly from the Home menu of the Landed Cost Container Detail screen, as shown below. 

The system will use the Calculation Type assigned to the "Landed Cost Type" when calculating how the fixed cost amount should be shared across the receipted Items and when calculating weights etc. then Base Unit of Measure will be used.

Example 1 - Quantity Calculation Type

Purchase Order has a Fixed Cost of 100.

Two Items are received.

  • Quantity = 75
  • Quantity = 25

The system will assign the following.

  • 75 (100 x (75/100))
  • 25 (100 x (25/100))

Example 2 - Weight Calculation Type

Purchase Order has a Fixed Cost of 100.

Two Items are received.

  • Quantity = 75, Gross Weight = 100
  • Quantity = 25, Gross Weight = 400

The system will assign.

  • 20 (100 x (100/500))
  • 80 (100 x (400/500))

When Fixed Costs have been posted against the Purchase Order and Transfer Order receipted quantities the Fixed Cost Accrued attribute will be set on the document and you cannot post additional fixed costs. Any adjustments will therefore have to be dealt with manually.