#2673 Price list conversion

R2.6.3
closed
nobody
Price List (23)
5
2007-12-11
2007-11-16
No

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

Discussion

  • sboda

    sboda - 2007-11-19
    • assigned_to: nobody --> sboda
     
  • sboda

    sboda - 2007-11-19

    Logged In: YES
    user_id=1705860
    Originator: NO

    Reviewing

     
  • sboda

    sboda - 2007-11-20
    • status: open --> pending
     
  • sboda

    sboda - 2007-11-20

    Logged In: YES
    user_id=1705860
    Originator: NO

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

    Thanks!

     
  • Savoir-faire Linux

    • status: pending --> open
     
  • 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

    sboda - 2007-11-21

    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!

     
  • sboda

    sboda - 2007-11-21
    • status: open --> pending
     
  • Savoir-faire Linux

    • status: pending --> open
     
  • 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

     
  • sboda

    sboda - 2007-11-21

    Logged In: YES
    user_id=1705860
    Originator: NO

    Reviewing

     
  • sboda

    sboda - 2007-11-21

    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!

     
  • sboda

    sboda - 2007-11-21
    • status: open --> pending
     
  • Savoir-faire Linux

    • status: pending --> open
     
  • Savoir-faire Linux

    Logged In: YES
    user_id=1805289
    Originator: YES

    We are using EnterpriseDB 8.2.

     
  • sboda

    sboda - 2007-11-26
    • assigned_to: sboda --> nobody
     
  • sboda

    sboda - 2007-11-26
    • labels: --> Price List
     
  • Kathy Pink

    Kathy Pink - 2007-12-11
    • milestone: --> R2.6.3
     
  • Kathy Pink

    Kathy Pink - 2007-12-11

    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

     
  • Kathy Pink

    Kathy Pink - 2007-12-11
    • status: open --> closed
     

Log in to post a comment.