1. Transportation Management Implementation Guide
  2. Setting Processing Options for Batch Routing Rate Update (R4950)

Setting Processing Options for Batch Routing Rate Update (R4950)

The processing options for Batch Routing Rate Update specify how the system updates routings.

1. Enter '1' to perform updates to the Routing Entries table. If this field is left blank, new records for the selected criteria are added.

Specify whether you want to update the Routing Entries table.

2. Enter the outbound rate adjustment type: '$' - adjust rate by amount '%' - adjust rate by percentage '*' - adjust rate to an override rate

Indicate whether the factor value is an increased/decreased percentage or an increased/decreased cash amount when applied to an order's outbound price.

3. Enter the inbound rate adjustment type: '$' - adjust rate by amount '%' - adjust rate by percentage '*' - adjust rate to an override rate.

Indicate whether the factor value is a percentage or an additional/deductible cash amount when applied to an order's inbound price.

4. Enter the outbound amount used to adjust the rate. For '$' (amount) adjustment: Enter 10 to increase the rate by 10 Enter -10 to decrease the rate by 10 For '%' (percentage) adjustment: Enter 10 to increase the rate by 10% Enter -10 to decrease the rate by 10% For '*' (rate override) adjustment. Enter 10 to change the rate to 10

Indicate how the system adjusts an order line. The value in this field works with the Basis field (BSCD). How you define the Basis field determines whether you enter a number or a code in this field.

  • If the Basis Code is 1–5, enter a positive number for markups such as 10. Enter a negative number for discounts.

  • If the Basis Code is 6, you want to base the adjustment on a variable table. Enter the code that identifies the variable table in the Formula Name column.

  • If the Basis Code is 7, you want to use a formula to calculate the price. Enter the code that identifies the formula in the Formula Name column.

  • If the Basis Code is 8, you want to calculate the adjustment using a custom program. Enter the program ID in the Formula Name column.

5. Enter the inbound amount used to adjust the rate. For '$' (amount) adjustment: Enter 10 to increase the rate by 10 Enter -10 to decrease the rate by 10 For '%' (percentage) adjustment: Enter 10 to increase the rate by 10% Enter -10 to decrease the rate by 10% For '*' (rate override) adjustment. Enter 10 to change the rate to 10

Indicate how the system adjusts an order line. The value in this field works with the Basis field (BSCD). How you define the Basis field determines whether you enter a number or a code in this field.

  • If the Basis Code is 1–5, enter a positive number for markups such as 10. Enter a negative number for discounts.

  • If the Basis Code is 6, you want to base the adjustment on a variable table. Enter the code that identifies the variable table in the Formula Name column.

  • If the Basis Code is 7, you want to use a formula to calculate the price. Enter the code that identifies the formula in the Formula Name column.

  • If the Basis Code is 8, you want to calculate the adjustment using a custom program. Enter the program ID in the Formula Name column.

6. Enter the Effective Date for the creation of new Routing Entries records. This date minus one day, replace the 'Expiration Date' for the existing records.

Specify the date when created Routing Entries records become effective.

7. Enter the Expiration Date for the creation of new Routing Entries records.

Specify the date when created Routing Entries records expire.