Results 1 to 2 of 2

Thread: Freight rates

  1. #1

    Freight rates

    Iam currently working on the Transportation module in jD. I want to know if it is possible to have a 3 -dimensional lookup for calculating freight rates. The freight rates should be calculated on three parameters
    1. weight / destination matrix for rate
    2. no. of pieces.
    In other words, the system must first check the weight of individual items of the shipment and find the correct rate after matching the same with teh weight/destination matrix. The resultant rate must then be multiplied with the number of pieces of that items.
    All the calculated item freight values must be summed to arrive at the shipment value
    for example :
    there are three items A / B/ C each of weight 10/20/30 . These items of numbers 2 / 3/ 2 form a shipment mooving to destination x / y / z.
    I made a weight table as
    label from to
    w1 1 10
    w2 11 20
    w3 21 30
    I create a destination table using Postal code as
    Label from to
    x 400001 400010
    y 400011 400020
    z 400021 400030
    The above two table is then used to create a weight/destination matrix as
    w1 w2 w3
    x 1 5 6
    y 2 6 10
    z 5 8 10

    Using the above , the system should calculate as follows
    Item A of weight 10 moving to x
    rate = 1
    value = 2(pieces) * 1 = 2
    Item B of weight 20 moving to y
    rate = 6
    value = 3(pieces) * 6 = 18
    Item C of weight 30 moving to z
    rate = 10
    value = 2(pieces) * 10 = 20

    The total shipment value 2 + 18 20 = 40

    Can the above be done in JD ???????????????


  2. #2
    It can be done in JD, but it won't be easy. I usually contact Cargolution for freight costs.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company, Oracle or Peoplesoft.