Modifying the Pricing Procedure - Calculate Net Price Workflow to Include a Discount Matrix
When you use a discount matrix, you must added an additional step to the workflow Pricing Procedure - Calculate Net Price to apply the discount matrix to the pricing. For more information about this workflow, see Pricing Procedure - Calculate Net Price Workflow.
To modifying the Pricing Procedure - Calculate Net Price workflow to include a discount matrix
In Web Tools, select the Pricing Procedure - Calculate Net Price workflow process. Revise and edit this workflow process.
After the Tiered Volume Discount Upsell step, add a new business service step that queries the appropriate discount matrix business component for any discounts associated with each account type.
Define the step as shown in the following table.
Name Type Business Service Name Business Service Method Account Type Adjustments
Business Service
Row Set Transformation Toolkit
Simple Look-Up Transform
Define the input arguments as shown in the following table.
Input Argument Type Value Property Name Context
Process Property
Context
Row Set
Process Property
Row Set
Business Object
Literal
Adjustment Group
Business Component
Literal
Product-Based Adjustment
Process Condition
Literal
{Row.Product Id} IS NOT NULL AND {Context.Account Type} IS NOT NULL
Search Specification
Literal
[Adjustment Group Name] = 'Account Type Discount' AND [Account Type] = {Context.Account Type}
On First Match 1
Literal
{Row.Net Price} = AdjustPrice({Row.Net Price}, {Row.Currency Code}, LookupName("PRICER_CALCULATION_SIMPLE_TYPE",
{Match.Adjustment Type}), {Match.Adjustment Amount}, {Match.Currency Code}, {Row.Exchange Date})
On First Match 2
Literal
{Row}.{Net Price Waterfall} += New("Waterfall", [Adjustment Amount] = {Match.Adjustment Amount}, [Adjustment Type] = {Match.Adjustment Type}, [Price] = {Row.Net Price}, [Currency Code] = {Row.Currency Code}, [Text] = LookUpMessage ("Pricer - Account Type Discount",[Account Type] = {Match.Account Type} ,[Discount Matrix] = {Match.Adjustment Group Name}))
Define the output arguments as shown in the following table.
Output Argument Property Name Type Context
Context
Output Argument
Row Set
Row Set
Output Argument
Deploy the updated workflow process.