JDEMart maintains the world’s largest Directory of JDE Add-on solutions from vendors all over the world. Basically we have done the first work for you: built relationship with vendors that have a sound software development reputation and fair pricing.


Zuidzijde 124
2411 RX Bodegraven
The Netherlands


Phone: + 31 6 53 899 736
Phone USA: +1 (303) 800 46 45
Phone S. Africa: +27 (021) 813 90 45
Email: eric@jdemart.com

JDEMart, an independent platform for smart JD Edwards Add-Ons
Open panel

Exchange Rate Upload for E1

Return to Previous Page

The Challenge

If you use JD Edwards EnterpriseOne in an international multi-currency environment you are very much in need of currency exchange rates or exchange rate uploads to convert foreign currency transactions to the base currency of your organization. Examples include supplier invoices and payments, customer invoices and receipts, purchase orders and sales orders.

You are likely facing regular manual exchange rate entries through the standard JDE screen sometimes for 20+ currencies and/or from one or more sources. Sometimes there could be even a definite specific requirement for the source of rates for each currency pair.
Maybe currency pairs need to be created via a triangulation calculation from combinations of the various sources, and some even via triangulation from other triangulated rates.

The manual entry through the JD Edwards screen can become time consuming, even if you only need a relatively small number of currencies.
As with any manual process, mistakes occur which can have a major impact on your business:

Sample 1) If rates are not entered on a particular day, then foreign currency transactions cannot be entered for that day.

Sample 2) If a rate in entered incorrectly or “the wrong-way”, the impact on your account balances may not be noticed for weeks but can be significant.

 Ideally, all this needs to be automated, with zero user intervention.


How it works

The Exchange Rate Upload solution is based on a simple, cloud-based configuration and exception notifications.
It pulls market and official FX rates from trusted authentic sources resulting in a 100% automated availability of the latest exchange rates.

The Cloud Service of this E1 add-on allows the flexibility needed to get rates for different currency pairs from different sources. Importantly, the triangulate stages can be set up to calculate cross-rates for specific sets of currencies, from a particular pivot currency.

FX rates can be sourced from OANDA, Xignite, Reuters and over 16 central banks, including the ability to mix and match.
The service is configured according to your preferences for schedule, currencies, cross-rates and rounding and a combination of daily updates and monthly updates can be set-up as well.

The service then downloads the rates from the various source overnight, so the latest rates are available whenever they are needed. Users are notified in the event of any issues, but otherwise the process runs silently in the background.

100% automation is provided.


JD Edwards integration

The solution runs on Oracle Cloud allowing customers to configure the currencies, timing, sources and other options for their FX rates.
Once configured, the solution runs on your chosen schedule to retrieve the rates, process them according to your options and save in JDE format.
A simple UBE on the JDE side then pulls the rates in and passes them through the interface.




Additional information

Apps from release: All
Tools from release: All
Free Trial (Y/N): Y
OVI (Y/N): N


1 - 5
No matching reviews found.

Leave a review

What name should be displayed with your review?
What title should be displayed with your review?
Characters remaining: 500
Please confirm your e-mail to verify your identity. It will not be displayed.
Review of Exchange Rate Upload for E1
  • Avoids mistakes when entering rates manually
  • Rates always up to date from a trusted source
  • Removes the manual effort of entering rates
  • Flexible dates for load
  • No user intervention
  • Bid, Ask or Mid-point available for market rates
  • Runs on your chosen schedule and frequency
  • Flexible rounding options
  • Market and central bank rates
  • Email notifications for exceptions
  • Multiple sources available
  • Optionally triangulate to create cross rates
  • Automated retry in the event of errors
You can add any HTML here (admin -> Theme Options -> E-Commerce -> Promo Popup). We suggest you create a static block and put it here using shortcode
Never miss a Webinar!
Subscribe for our monthly webinar updates
Your Information will never be shared with any third party.
Thank you for registering! After the sign-up and approval process you will receive for each individual webinar your unique join link per mail. For questions contact deena@jdemart.com
Selected Webinar
Subscribe to our newsletter
Request for information:
We tell you which JDE tools you should know about before you live life without or you attempt to create your own
Subscribe me to the newsletter
Subscribe me to the newsletter
Thank you for registering! After the sign-up and approval process you will receive your unique join link per mail. For questions contact deena@jdemart.com
Selected Webinar
Subscribe to our newsletter