Auto Load Exchange Rate JDE XE

[mdakhb]

We would like to Automatically load exchange rates from CAD to USD to the F0015 table. Has anyone had to automatically get an exchange rate file from somewhere? If I could get a file of exchange rates automatically, i could load it up into JDE XE.

 

[VISLICOM]

Insert data in F0015 Table. Must take backup before you do this.

 

[78aspide78]

I'm just working on this.

In my case I use Web Service to do this; if you are on XE you can achive this by building your software the get the exanche rates from some web sites and create a txt file, then build your report to import this text file into JDE.

Hope this can be useful.

Regards

Bruno Condemi

 

[sarienti]

As Bruno says, you could create a BSFN to save a stream from an web site that provide exchange rate.

I did this using "InternetReadFile" function (wininet.dll).

Stefano

 

[Chan Rana]

There are many ways to do it. Depends on what infrastructure and E1 installation your company has. Also the skills capability would drive the software/platform which you will utilise to di it. As above you can either do it thru simple FTP or uplaoding text file and processing it thru UBE or make it robust using Busines services or latest technologies.

Chan