Feature: Estimated Landed Cost

Goal: Functional

Description:

Support estimated landed cost for Average Costing.

Setup:

Setup Landed Cost Clearing Account. This is the account for estimated landed cost posting and its balance should reflect the timing difference between Material Receipt and Landed Cost Invoice.

Accounting Schema Default:

Product Category Accounting:

Product Accounting:

If you want to set the landed cost clearing account same account as the default you could use this SQL (please be careful):

update m_product_acct set p_landedcostclearing_acct = (select ac.p_landedcostclearing_acct from c_acctschema_default ac where ac.c_acctschema_id=1000000);
update m_product_category_acct set p_landedcostclearing_acct = (select ac.p_landedcostclearing_acct from c_acctschema_default ac where ac.c_acctschema_id=1000000);

NOTE! Change c_acctschema_id to your c_acctschema_id

Workflow:

1. Enter estimated landed cost for purchase order. The allocation is calculated when user complete the purchase order.

2. Material Receipt Posting will calculate the estimated landed cost using the allocation from Purchase Order. The amount will be posted to the landed cost clearing account.

3. Enter landed cost invoice.

4. Distribute the landed cost invoice line to Material Receipt

5. Result of #4.

6. Posting of the Landed Cost Invoice. The posting will clear the landed cost clearing posting in Material Receipt and difference will be transferred to Average Costing Variance or Product Asset Account.

7. The Landed Cost is added to the product cost.

Technical Info: IDEMPIERE-1285

NF2.0 Estimated Landed Cost

Feature: Estimated Landed Cost