0028389: [Costing] Landed Cost Cost posting is not correct in case there is a conversion matching caused by an exchange rate

Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #28389		[ All Revisions ] [ Back to Issue ]
Summary	0028389: [Costing] Landed Cost Cost posting is not correct in case there is a conversion matching caused by an exchange rate

Revision	2014-12-11 14:42 by psanjuan
Steps To Reproduce	In QA testing client create a new product named "Costing 28157B". Select a Purchase price list in EUR and enter a unit/list price = 100 eur. Create another product named "Cost USD". Select a Purchase Price List in USD. Enter a unit/list price = 50 USD. Go to Landed Cost type window and create a new one related to this product for Spain Org. Make sure you have a system conversion rate between USD and EUR, let's say = 0.4, in "Conversion Rate" window. And EUR to USD = 2.5 Go to Goods receipt and create a new one for Spain org dated on 12/11/2014. Enter the product, enter an amount = 1 and select an storage bin. Complete the receipt. Go to process request window and run costing background process. Go back to the receipt and post it. Realize that the value post is 100.00 Go to Product window and realize that the cost of the product and the cost of the transaction is 100 Go to landed cost window and create a new one for Spain org, dated on 15/11/2014 Navigate to Cost tab and enter landed cost type "Cost USD". Enter an amount = 50. Currency = USD. Go to Receipt window and select the receipt just created. Process and post landed cost. Realize that posting is: D: Product asset 20.00 € (50 USD0.4) C: Landed Cost expense account 20.00 € (50 USD0.4) - this entry with no accounting dimensions Go to Product window and realize that the cost of the product and the cost of the transaction is now 120 which is correct. Go to purchase invoice window and create a new one for Spain org, dated on 30/11/2014. Select a USA Vendor. Go to lines and enter the product "Cost USD", enter qty = 1, price should be equal to 50 USD. Go to exchange rate tab an enter a new conversion rate = 0.6 Realize that foreign amount is 30 EUR. Complete and Post the invoice. In the purchase invoice line click on the process button "Match LC Cost". Select the landed cost and enter a matched amount = 50 Select "Is matching adjusted" and "Process matching" check-boxes. Press OK/Done. A new cost adjustment is created for an amount of 25.00 USD that is 10 € (30€-20€) x 2.5 USD/EUR Go to Product window and realize that the cost of the product and the cost of the transaction is now 130 which is correct. Go back to landed cost window, tab "Cost", sub-tab "Matched Amount". There you can see there are two lines: * one set to "Conversion Matching" = NO for an amount of 50 USD * another one set to "Conversion Matching" = YES for an amount of 25 USD Post Landed Cost cost. Realize that the posting shown is: D: Product Asset 20 € D: Expense Cost 10 € C: Expense Cost 20 € C: Expense Cost 10 € Above posting is not correct. C: Expense Cost USD (40 = 100*0.4)

Revision	2014-12-11 14:30 by psanjuan
Steps To Reproduce	In QA testing client create a new product named "LC Test". Select a Purchase price list in EUR and enter a unit/list price = 100 eur. Create another product named "Cost USD". Select a Purchase Price List in USD. Enter a unit/list price = 50 USD. Go to Landed Cost type window and create a new one related to this product for Spain Org. Make sure you have a system conversion rate between USD and EUR, let's say = 0.4, in "Conversion Rate" window. Go to Goods receipt and create a new one for Spain org dated on 12/11/2014. Enter the product, enter an amount = 1 and select an storage bin. Complete the receipt. Go to process request window and run costing background process. Go back to the receipt and post it. Realize that the value post is 555.00 Go to Product window and realize that the cost of the product and the cost of the transaction is 100 Go to landed cost window and create a new one for Spain org, dated on 15/11/2014 Navigate to Cost tab and enter landed cost type "Cost USD". Enter an amount = 50. Currency = USD. Go to Receipt window and select the receipt. Process and post landed cost. Realize that posting is: D: Product asset 20.00 € (50 USD0.4) C: Landed Cost expense account 20.00 € (50 USD0.4) Go to Product window and realize that the cost of the product and the cost of the transaction is 120 Go to purchase invoice window and create a new one for Spain org, dated on 30/11/2014. Select a USA Vendor. Go to lines and enter the product "Cost USD", enter qty = 1, price should be equal to 50 USD. Go to exchange rate tab an enter a new conversion rate = 0.6 Realize that foreign amount is 30 EUR. Complete and Post the invoice. In the purchase invoice line click on the process button "Match LC Cost". Select the landed cost and enter a matched amount = 50 Select "Is matching adjusted" and "Process matching" check-boxes. Press OK/Done. A new cost adjustment is created The cost of the product is now 130 € Go back to landed cost window, tab "Cost", post the line. Realize that the posting shown is: D: Expense Cost USD (40 = 1000.4) C: Expense Cost USD (40 = 1000.4)