My Rate is not working as expected, planning is fine, but the rate calculation is
not correct. Below details my configuration and what is expected:
My required rate is based on "per client, per stop" and it can be based on weight or volume
or ship units. I have used ORRefnum to store the client name. Example:
Order 1: ORrefnum Value= IBM; Volume = 2 CBM; going from Location A to B; Charge is 2
USD/CBM
Order 2: ORRefnum Value = HP; Volume = 4 CBM; going from Location A to B; Charge is 5 USD/CBM
The 2 orders belongs to different clients, IBM and HP, but they can be consolidated into one shipment. Thus the end results should
be:
(2 x 2) + (4 x 5) = 24 USD. However what I am getting in OTM is:
(6 x 2) + (6 x 5) = 42 USD
My Rate Records Configuration
Basis:
a) Stop Activity = D
b) ORRefnum Qual = Rating Group
c) ORRefnum Value = IBM
Charge 2 USD /CBM based on Stop Volume
Basis:
a) Stop Activity = D
b) ORRefnum Qual = Rating Group
c) ORRefnum Value = HP
Charge 5 USD /CBM based on Stop Volume
a) Stop Activity = P
b) ORRefnum Qual = Rating Group
c) ORRefnum Value = IBM
Charge 0 USD /CBM based on Stop Volume
Basis:
a) Stop Activity = P
b) ORRefnum Qual = Rating Group
c) ORRefnum Value = HP
Charge 0 USD /CBM based on Stop Volume
When calculating the rates, OTM is using the total stop volume instead of just the total stop volume of those orders with matching ORRefnum. This
seems like a bug to me. Appreciate your help on this setup or alternative setup that can achieve the end result.
not correct. Below details my configuration and what is expected:
My required rate is based on "per client, per stop" and it can be based on weight or volume
or ship units. I have used ORRefnum to store the client name. Example:
Order 1: ORrefnum Value= IBM; Volume = 2 CBM; going from Location A to B; Charge is 2
USD/CBM
Order 2: ORRefnum Value = HP; Volume = 4 CBM; going from Location A to B; Charge is 5 USD/CBM
The 2 orders belongs to different clients, IBM and HP, but they can be consolidated into one shipment. Thus the end results should
be:
(2 x 2) + (4 x 5) = 24 USD. However what I am getting in OTM is:
(6 x 2) + (6 x 5) = 42 USD
My Rate Records Configuration
Basis:
a) Stop Activity = D
b) ORRefnum Qual = Rating Group
c) ORRefnum Value = IBM
Charge 2 USD /CBM based on Stop Volume
Basis:
a) Stop Activity = D
b) ORRefnum Qual = Rating Group
c) ORRefnum Value = HP
Charge 5 USD /CBM based on Stop Volume
a) Stop Activity = P
b) ORRefnum Qual = Rating Group
c) ORRefnum Value = IBM
Charge 0 USD /CBM based on Stop Volume
Basis:
a) Stop Activity = P
b) ORRefnum Qual = Rating Group
c) ORRefnum Value = HP
Charge 0 USD /CBM based on Stop Volume
When calculating the rates, OTM is using the total stop volume instead of just the total stop volume of those orders with matching ORRefnum. This
seems like a bug to me. Appreciate your help on this setup or alternative setup that can achieve the end result.
Comment