Project:
| View Revisions: Issue #28157 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0028157: [Costing] Landed Cost calculation does not take into account exchange rate at purchase invoice (landed cost invoice) level | ||
| Revision | 2014-12-11 14:29 by psanjuan | ||
| Steps To Reproduce | In QA testing client create a new product named "LC 555". Select a Purchase price list in EUR and enter a unit/list price = 555 eur. Create another product named "Cost USD". Select a Purchase Price List in USD. Enter a unit/list price = 100 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 555 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 = 100. Currency = USD. Go to Receipt window and select the receipt. Process and post landed cost. Realize that posting is: D: Product asset 40.00 (100*0.4) C: Landed Cost expense account 40.00 (100*0.4) 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 100 USD. Go to exchange rate tab an enter a new conversion rate = 0.8 Realize that foreign amount is 80.00 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 = 100. Select "Is matching adjusted" and "Process matching" check-boxes. Press OK/Done. Realize that no cost adjustment is created. Go to product window and search the product. Navigate to Costing tab. Realize that the cost of the product is still 595 (555 + 40) Go to product window and search the product. Navigate to Transactions tab. Realize that the cost of the receipt transaction is still 595 (555 + 40) |
||
| Revision | 2014-11-12 14:41 by psanjuan | ||
| Steps To Reproduce | In QA testing client create a new product named "LC 555". Select a Purchase price list in EUR and enter a unit/list price = 555 eur. Create another product named "Cost USD". Select a Purchase Price List in USD. Enter a unit/list price = 100 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 555 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 = 100. Currency = USD. Go to Receipt window and select the receipt. Process and post landed cost. Realize that posting is: D: Product asset 40.00 (100*0.4) C: Landed Cost expense account 40.00 (100*0.4) 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 100 USD. Go to exchange rate tab an enter a new conversion rate = 0.8 Realize that foreign amount is 80.00 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 = 100. Select "Is matching adjusted" and "Process matching" check-boxes. Press OK/Done. Realize that no cost adjustment is created. Go to product window and search the product. Navigate to Costing tab. Realize that the cost of the product is still 595 (555 + 40) Go to product window and search the product. Navigate to Transactions tab. Realize that the cost of the receipt transaction is still 595 (555 + 40) Go back to landed cost window, tab "Cost", post the line. Realize that the posting shown is: D: Expense Cost USD (40 = 100*0.4) C: Expense Cost USD (40 = 100*0.4) |
||
| Revision | 2014-11-12 14:25 by psanjuan | ||
| Steps To Reproduce | to be defined | ||
| Copyright © 2000 - 2009 MantisBT Group |
 |