NF2.0 Estimated Landed Cost

From iDempiere en
Jump to navigation Jump to search

Feature: Estimated Landed Cost

Goal: Functional

Sponsor: TrekGlobal

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: EstimatedLandedCost Accounting Schema.png


Product Category Accounting: EstimatedLandedCost Product Category.png


Product Accounting: EstimatedLandedCost Product.png

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.

EstimatedLandedCost Purchase Order.png


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.

EstimatedLandedCost Material Receipt Posting.png


3. Enter landed cost invoice.

EstimatedLandedCost Landed Cost Invoice Line.png


4. Distribute the landed cost invoice line to Material Receipt

EstimatedLandedCost Distribute Landed Costs.png


5. Result of #4.

EstimatedLandedCost Landed Cost Allocation.png


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.

EstimatedLandedCost Landed Cost Posting.png


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

EstimatedLandedCost Product Cost 1.png

EstimatedLandedCost Product Cost 2.png


Technical Info: IDEMPIERE-1285