View source for NF2.0 Estimated Landed Cost

= '''Feature:''' Estimated Landed Cost =

'''Goal:''' Functional

'''Sponsor:''' [http://www.trekglobal.com/ 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:
[[File:EstimatedLandedCost Accounting Schema.png]]


Product Category Accounting:
[[File:EstimatedLandedCost Product Category.png]]


Product Accounting:
[[File: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):

<pre>
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);
</pre>

'''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.

[[File: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.

[[File:EstimatedLandedCost Material Receipt Posting.png]]


3. Enter landed cost invoice.

[[File:EstimatedLandedCost Landed Cost Invoice Line.png]]


4. Distribute the landed cost invoice line to Material Receipt

[[File:EstimatedLandedCost Distribute Landed Costs.png]]


5. Result of #4.

[[File: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.

[[File:EstimatedLandedCost Landed Cost Posting.png]]


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

[[File:EstimatedLandedCost Product Cost 1.png]]

[[File:EstimatedLandedCost Product Cost 2.png]]


'''Technical Info:''' [http://idempiere.atlassian.net/browse/IDEMPIERE-1285 IDEMPIERE-1285]



[[en:NF2.0 Estimated Landed Cost]]
[[de:NF2.0 Geschätzter Einstandspreis]]



[[Category:New Features|F]]
[[Category:New Features v2.0|F]]
[[Category:New Features Functional]]
[[Category:User Manual‏‎]]
[[Category:Financial accounting]]
[[Category:Financial accounting base data]]
[[Category:Account]]
[[Category:Cost accounting]]