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

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0028389

Openbravo ERP

04. Warehouse management

public

2014-12-11 14:28

2014-12-30 23:28

Reporter

psanjuan

Assigned To

umartirena

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Ubuntu 8.04.1

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

aferraz

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

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

Description

[Costing] Landed Cost Cost posting is not correct in case there is a conversion matching caused by an exchange rate entered at purchase invoice level.

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 USD*0.4)
C: Landed Cost expense account 20.00 € (50 USD*0.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)

Proposed Solution

Correct posting should be:

D: Product Asset 10 € - as product asset total value is 120 + 10
D: Expense Cost 20 € - with no accounting dimensions
C: Expense Cost 20 € - with accounting dimensions
C: Expense Cost 10 € - with accounting dimensions

Additional Information