JD Edwards Daily Currency Conversion Rate Update

The JD Edwards Currency Conversion bot updates the currency rates as an unattended bot. You can run it on a schedule or on-demand.

Top Benefits

  • Daily updates to conversion rates to ensure accuracy to all international business transactions
  • 100% Accurate
  • Eliminate the timely task of manual updates
  • Sends you a report of records updated


  • Validates and creates currency conversion rate records in JD Edwards
  • Creates and stores records updated in an excel file
  • Delivers updates to users upon bot completion

The JD Edwards Currency Exchange Bot updates currency records in the JD Edwards ERP platform. The bot will ensure that each record in the currency exchange table is updated to the current exchange rates.

Bot Procedure:
1. Log into JD Edwards
2. Navigate to the currency exchange page
3. Create Excel file
4. Format Excel headers
5. Loop through currency records
6. Check if record has proper requirements to be updated
7. Get previous conversion rate
8. Launch conversion website and get new conversion rate
9. Close conversion website
10. Create new currency conversion rate record and enter new conversion rate

Enter changes into excel file including all
1. To - Currency Code
2. From - Currency Code
3. Previous Conversion Rate
4. New Conversion Rate

Save the Excel spreadsheet and close the Excel document as well as JD Edward. Finally, send the document to a specified email address of your choice.

JD Edward Validations:
1. Conv Meth = Z
2. Calc Meth = 1
3. Effective date not equal to today
4. Currency codes do not contain MXP (expired currency code)

Start 30-Day Free Trial

$2000 USD per bot
Annual Subscription

Request quote for more purchase options

Bot Security Program
Level 1
Business Process
Automation Type
Last Updated
December 4, 2020
First Published
July 16, 2020

See the Bot in Action

Business Impact
Process Map
Technical Workflow Diagram
Business Impact
Process Map
Technical Workflow Diagram

Setup Process


Download the Bot and follow the instructions to install it in your AAE Control Room.


Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)


That's it - now the Bot is ready to get going!

Requirements and Inputs

  • JD Edwards - Version 9.1 and higher
  • Internet Explorer - Version 10 or later
  • Microsoft Office Products - Excel
  • Mail Server - Example: Outlook