World Math Numeric to OneWorld Math Numeric

[Christian Audet]

Hi List,

We are doing a conversion from World(A73.7) to OneWorld (B733.2). Most of the work is done thru Table conversion. The Link betweenn World and OneWorld is a ODBC "Client Access ODBC Driver (32-bit)". One of the issue we have is that the Math Numeric from World to OneWorld without recognition of the Display Decimal in the Data Dictionnary.

Example : value 100$ store with display decimal 2 will give in database 10000 (that's normal). The problem is oneWorld read this value it recognize it as 10000$ and the new value store in One World database is now 1000000.

Ok a simple solution is to divide the Input value by 100, but is there any other way that somebody know to have the transfert with the right value WITHOUT THE DIVIDE, like a setting in ODBC or in OneWorld.

Thank

Implementing B7333 (Xe) SP14.1, SQL
(Support B732, B7331 and B7332)

 

[Zoltan_Gyimesi]

Hi Christian,

Currencies are an other animal.
Currency Triggers are running when you retrive the value or place it.
Have you tried to switch on the "Run Currency Triggers" on the Table Options of the Table Conversion. Maybe it will resolve your problem.
Please, let us know that does it work or not. Thanks.

Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)

 

[Christian Audet]

Thank Zoltan,

I tried it (Run Currency trigger) and it`s not working better. In the help they say not to use "Run Currency trigger" when reading World database.

In the meantime i'm using the DIVIDE by 100.

Christian Audet

Implementing B7333 (Xe) SP14.1, SQL
(Support B732, B7331 and B7332)

 

[Zoltan_Gyimesi]

Hi Christian,

(... it seems to me that we are chatting here on the Forum in "multi-threaded" mode ))

Do you handle Multi Currency? If yes then maybe you should take care to the currency code too when you handle amounts.
I did it once in an interface application:
* I FetchSingle the F0013 Currency Code table with the CRCD Currency Code as key to retrieve CDEC Display Decimals.
* I convert the Character value to Numeric value (it's a bit funny that this value is stored as character)
* I calculate the correct power of 10 to divede or to multiply
* I divide or multiply the value with the calculated power of 10

Have a good time to convert,

Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)

 

[Christian Audet]

Zoltan,

I did the same in F9201 from world (10 POW CDEC) and it's working fine.

It's still realy strange that this calculation have to take place since we are from a JDE product to a JDE Product. Oups I forget that sometime JDEdwards do not support JDEdwards product.

Christian Audet


Implementing B7333 (Xe) SP14.1, SQL
(Support B732, B7331 and B7332)

 

[Zoltan_Gyimesi]

Hi Chhristian,

You reaised a laugh when I read your observation about JDE vs JDE ;-)
On the other hand, was you able to make (10 POW CDEC) in OneWorld ER without converting CDEC Character Value to Numeric?

Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)

 

[Christian Audet]

Zoltan,

With the (10 POW CDEC) I did it with a numeric variable instead of directly CDEC, just because I was scared to have a wrong result.

Christian


Implementing B7333 (Xe) SP14.1, SQL
(Support B732, B7331 and B7332)