Adjust Price According to Ship to Location

Adjust the price that Pricing calculates on the order line according to the ship to location you set on the order header.

For this example, assume.

• You must adjust the price for the AS54888 item according to the ship-to site.

• Add a 10% mark up when shipping to 1100 Stout Street, Denver.

• Add a 15% mark up when shipping to 5748 Shoreline Drive, Vancouver.

• ShipToPartySiteId for Denver is 869784657.

• ShipToPartySiteId for Vancouver is 153429673.

• You already added the AS54888 to Price List for Computer Manage Price Lists and Rentals. You set Base Price to 2500. For details about setting up this price list, see Manage Price Lists.

Here's your set up.

1. In the Pricing Administration work area, click Tasks > Manage Service Mappings.

2. On the Manage Service Mappings page, open the Sales service mapping.

3. Map the order header.

   • On the Edit Service Mapping page, click Sources, then click the row that contains OrderHeader in the Source column.

   • In the Details area, on the Entity Mappings tab, click the row that contains Line in the Entity column.

   • On the Attribute Mappings tab, click Actions > Add Row, then set the values.

     Attribute	Value
     Attribute	ShipToPartySiteId
     View Object Attribute	ShipToPartySiteId

4. Map the order line.

   • In the Details area, on the Entity Mappings tab, click the row that contains Line in the Entity column.

   • On the Attribute Mappings tab, click Actions > Add Row, set values, then click Save and Close.

     Attribute	Value
     Attribute	ShipToPartySiteId
     View Object Attribute	ShipToPartySiteId

5. Modify the matrix class.

   • Click Tasks > Manage Matrix Classes.

   • On the Manage Matrix Classes page, open the Price List Charge Adjustment matrix class.

   • Add a new condition column.

     Attribute	Value
     Name	Ship To
     Source Code Name	ShipTo
     Comparison	=
     Compare to Attribute	Line.ShipToPartySiteId
     Allow Null	Contains a check mark
     Null Is Wildcard	Contains a check mark
     Domain	Domain Type is None Data Type is Number

   • Click Save and Close.

6. Modify the price list.

   • Click Tasks > Manage Price Lists.

   • Search for, then open Price List for Computer Service and Rentals.

   • On the Edit Price List page, in the Price List Lines tab, search for AS54888.

   • Click Create Charge > Create Price Adjustment Matrix.

   • In the Create Price Adjustment Matrix dialog, add a check mark to Ship To, then click OK.

   • In the Price Adjustments area, use Actions > Add Row to add these rows.

     Ship To	Adjustment Type	Adjustment Amount	Adjustment Basis
     869784657	Markup Percent	10	List Price
     153429673	Markup Percent	15	List Price

     To get the ship to Id for your environment, use REST API, a web service, or run an SQL query on the Oracle database.

   • Click Save and Close, then sign out of Pricing.

7. Test your set up.

   • Sign into Order Management with the privileges that you need to manage sales orders.

   • In the Order Management work area, create a new sales order.

     Attribute	Value
     Customer	Computer Service and Rentals
     Ship-to Address	1100 Stout Street, Denver

   • Add the AS54888 to an order line, then notice the Your Price attribute displays 2500.

   • Click Save, then verify that Your Price displays 2750, which is the 2500 you set up for the base price plus the 10% mark up.

     Pricing applies the matrix adjustment when you click Save, click Actions > Reprice Order, or click Submit.

   • Change the Ship-to Address to 5748 Shoreline Drive, Vancouver, then click Save.

   • Verify that Your Price displays 2875, which is 2500 base price plus 15% mark up.