In this module we will see how to Upload US JD Rate File.
To upload US JD Rate File, Click on Routing → Rate Table
Below displayed window will appear.
Screenshot: Rate Table
Rate Table window will appear, Just click on any of the Rate Table's Name to edit the Rate Table.
Editing Rate Table window will appear.
Screenshot: Editing Rates
On Editing Rates Window, Click on Import Section, Import window will appear.
Screenshot: Import File
Rate Upload Template
You can select the predefined templates to upload the Rates.
Same Record exists in Rate Table
If the records with same codes exists in rate table, you can choose to
Same Records exists in File
If the records with same codes exists in File, you can choose to
Effective Date Format
Rate Effective Date Format in File.
i.e dd-mm-yyyy, yyyy-mm-dd etc.
Choose the code deck which will be applicable on the imported rates.
Get Code Name From
You can choose from where you wants the destination code names i.e.
Enable Auto end Date for Previous Rates
Check this box if you want to Auto end effective date for Previous Rates and input the End Date.
Auto Populate IJ Rate
Check this box if you want to Automatically Populate the IJ Rates. (US JD Rates)
File with Header
Check this box if you want to upload file with Header.
Download the Example file which shows format of the file to upload.
To Import the US JD Rate File, Click on Import File and select the Fields with the help of above displayed data. After selecting all the Fields, click on Upload button,
The File upload will get started. You can view the Upload status in Import Log window.
You can download the sample file by clicking on Show Example.
US JD Rate File contains 3 different rates i.e. INTER RATE, INTRA RATE & IJ RATE.
Here is the Sample of the US JD Rate File.
Screenshot: US JD Rate File Sample
The File contains CODES with following rates as shown in the rate table.