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

Tasks

  • 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 Currency Exchange page
3. Create Excel file
4. Format Excel header
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 Excel spreadsheet and close Excel document and JD Edwards. 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
Applications
Business Process
Category
Vendor
Automation Type
Bot
Last Updated
July 24, 2020
First Published
July 16, 2020
Enterprise Version
11.3.3
ReadMe
ReadMe
Support

See the Bot in Action

Business Impact
Process Map
Technical Workflow Diagram
PREV NEXT
Business Impact
Process Map
Technical Workflow Diagram

Setup Process

Install

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

Configure

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

Run

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