[Dave Lee]

Hi,

I would like to seek your view on how to model this in OTM. I have the following Orders:

Order 1 Supplier A WT (3kg)
Order 2 Supplier B WT (1kg)
Order 3 Supplier A WT (2kg)
Order 4 Supplier A WT (2kg)

The Sell Rate is LTL Weight Break. I have a requirement to consolidate the orders and bill it based same supplier on the same day meaning Order 1, 3 & 4 are one bill and Order 2 is another bill. The WT for Order 1, 3 & 4 are sum up and applied on the weight break table.
How do you model it in OTM?

i am creating 1 Order = 1 Sell Shipment. Using a scheduler Recurring Process to invoke an agent. The agent will call a stored procedure to consolidate the sell shipment based on the same supplier on the same day and group them together using a shipment group. The Stored Procedure will read onto the rate cost to derive the final cost.

Is there other better solution using OTM instead of Stored Procedure? Thanks.

[josephliang]

You can use Tiered Rating. (Search on-line help topic: Configuring Tiered Rating)

[Dave Lee]

Configuring Tiered Rating

This process details configuring tiered rating.
Select a rate offering with a rate offering type that allows tiered rating.
Define the time period on the rate record or rate offering.
Define the rate using a cost with a basis that uses tiers.
Optionally, set the RATING ENGINE ALWAYS CALCULATES TIERED RATES parameter to TRUE. When you set the parameter to TRUE, this instructs the rating engine to simulate tiered rating for the shipment if it hasn't been recorded to its time slot already.
If you want shipments to automatically record the shipment within it's tiering historical time period, create an automation agent that uses the Record Shipment for Tiered Rating agent action.
If you want to manually record this shipment in the historical time period, run the Record Shipment for Tiered Rating action on selected shipments.

I tried search online and saw this website. I can't understand much from it. Have you use it before?

[josephliang]

1. Select a rate offering with a rate offering type that allows tiered rating.

Choose LTL-TIERED or TL-TIERED

2. Define the time period on the rate record or rate offering.

Define a Time Period via Contract and Rate Management > Power Data > General > Rate Offering Time Period Definitions
For your case, choose Cycle Type=Day and Cycle Duration=1

3. Define the rate using a cost with a basis that uses tiers.

There are four basis available in Rate Cost:
- Tiered Rating Shipment Count
- Tiered Rating Total Shipment Weight
- Tiered Rating Total Shipment Net Weight
- Tiered Rating Total Shipment Volume

Choose Tiered Rating Total Shipment Weight or Tiered Rating Total Shipment Net Weight for your case.

4. Optionally, set the RATING ENGINE ALWAYS CALCULATES TIERED RATES parameter to TRUE. When you set the parameter to TRUE, this instructs the rating engine to simulate tiered rating for the shipment if it hasn't been recorded to its time slot already.

Set the RATING ENGINE ALWAYS CALCULATES TIERED RATES=TRUE in Plannng Parameter Set.

5. If you want shipments to automatically record the shipment within it's tiering historical time period, create an automation agent that uses the Record Shipment for Tiered Rating agent action.

Case 1: automated process
Create an Agent with RECORD SHIPMENT FOR TIERED RATING action upon Shipment Creation.

6. If you want to manually record this shipment in the historical time period, run the Record Shipment for Tiered Rating action on selected shipments.

Case 2: manual process
Users manually select Shipments and perform Actions > Record Shipment for Tiered Rating

Regardless case 1 or 2, it is better to define a Data Query Recurring Process to re-calculate Shipment Cost periodically.