JD Edwards: Get Sales Order Freight Cost

This bot allows a user to enter a sales order and run the attended bot. The bot will then capture all necessary data and display shipping rates.

Top Benefits

  • Eliminates task of capturing shipping rates for sales orders
  • Saves time and allows employees to perform more meaningful tasks
  • Improves accuracy for shipping requirements

Tasks

  • Logs into JD Edwards and captures sales order data
  • Manipulate sales order data captured from JD Edwards
  • Captures ship rates from external websites based on JD Edwards data captured
  • Manipulates data in an Excel file
  • Displays shipping rates on your desktop

The JD Edwards: Get Sales Order Freight Cost bot can be used to calculate shipping costs given a sales order number. The bot will display shipping rates for UPS, USPS, and FedEx.

1. Log into JD Edwards
2. Navigate to “Customer Service Inquiry” (Fast path to p4210)
3. Search Sales Order Number
4. Select Sales Order Record
5. Get Item Quantity
6. Enter into Sales Order Record
7. Get “From Business Unit “and “To Address Code”
8. Navigate to “Work with Shipments” (Fast path to P4915)
9. Search Sales Order Number
10. Get Item weight
11. Navigate to “Work with Business Units” (Fast path to p0006)
12. Search From Business Unit
13. Enter into Business Unit Record
14. Get From Address Code
15. Navigate to “Work with Addresses”
16. Search To Address Code
17. Enter To Address Code Record
18. Click on the Mailing tab
19. Get To Address, To State, To Zip Code, and To City
20. Exit Record
21. Search From Address Code
22. Click on the Mailing tab
23. Get From Address, From State, From Zip Code, and From City
24. Calculate Total Weight by Multiplying Item Quantity and Item Weight
25. Launch FedEx Shipping Calculator
26. Search To and From Zip Codes and Total Weight
27. Loop through the table to find Shipping Service containing “FedEx 2day AM”
28. Break Loop if Service is Found and Save the Shipping Rate to FedEx Rate
29. Close FedEx Shipping Calculator
30. Launch USPS Shipping Calculator
31. Search To and From Zip Codes and Select View Flat Rate Boxes
32. Get the Shipping cost for Large Flat Rate Box and Save it to USPS Rate
33. Close USPS Shipping Calculator
34. Launch UPS Shipping Calculator
35. Search To and From Zip Codes, To and From Cities, Total Weight, Standard Box Dimensions (12x12x6)
36. Check Each Row in Table to Find Service Containing “2nd Day Air A.M.”
37. Save “2nd Day Air A.M.” Shipping Rate to UPS Shipping Rate
38. Display Rates to User

Appendix:
a. From Business Unit – Ship from address
b. To Address Code – Ship to address

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 22, 2020
Enterprise Version
11.3.3
ReadMe
ReadMe
Support

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 sales order number
  • JD Edwards environment link