#2673 Price list conversion

[Savoir-faire Linux]

Hello,

We have our base price list in canadian dollars (CAD) and we would like to create a price list for a customer in Europe (Euro).

In the discount schema, our sequence works as follows :
- apply a 0% discount to all the product and ressources
- apply a 100% discount for specific ressources
- apply a fixed price for specific product (15)

As a result of creating our Euro price list from the discount schema and base price list in CAD, we have :
- our ressources at 0 : GOOD
- our specific product set at the fixed price of 15 euros : GOOD
- all other price are the CAD price negative (45 $CAD -> -45 Euros): BAD

Our currency rate "CAD to EUR" has been set and is valid.

Note that might be useful : In an order in Euro, the status bar on the bottom of the window gives us the price in the 2 currencies, the price in CAD is 0.00.

Thank you very much for your help!

Maxime Chambreuil, for Enzyme/Savoir-faire Linux

[sboda]

Logged In: YES
user_id=1705860
Originator: NO

Reviewing

[sboda]

Logged In: YES
user_id=1705860
Originator: NO

Did you set up the conversion rate properly in Currency Rate window?

Thanks!

[Savoir-faire Linux]

Logged In: YES
user_id=1805289
Originator: YES

In Currency Rate window, we have defined :
- CAD -> EUR (Spot, 01/01/2007,01/29/2056, "0.6956", "1.4375")
- CAD -> USD (Spot, 01/01/2007,01/29/2056, "0.951", "1,0515")

[sboda]

Logged In: YES
user_id=1705860
Originator: NO

You should create the reverse conversion rate, then create the price list.
Ex: EUR-> CAD (Spot, 01/01/2007, 01/29/2056, "1.4375", "0.6956".

Please let me know if you have any questions.

Thanks!

[Savoir-faire Linux]

Logged In: YES
user_id=1805289
Originator: YES

Please see the attachment, it contains the export of my Currency Rate data.
File Added: CurrencyRate.csv

[Savoir-faire Linux]

Currency Rate

[sboda]

Logged In: YES
user_id=1705860
Originator: NO

Reviewing

[sboda]

Logged In: YES
user_id=1705860
Originator: NO

HI,

Are you using Oracle or EDB?

I cannot able to reproduce this issue in Oracle, but I can able to reproduce in EDB.

The status bar issue is a known issue in EDB,and we are looking in to it.

THanks!

[Savoir-faire Linux]

Logged In: YES
user_id=1805289
Originator: YES

We are using EnterpriseDB 8.2.

[Kathy Pink]

Logged In: YES
user_id=329831
Originator: NO

We are moving all Open Support Requests, Bugs and Feature Requests to Compiere Case Management. Please refer to the following link for information on creating new Support Requests.
http://www.compiere.com/support/community.php

Thank you