Pricing Procedure - Aggregate Discounts Workflow

The Pricing Procedure - Aggregate Discounts workflow, as shown in the following figure, is the subprocedure that evaluates the Aggregate Discount Sequence adjustment. The workflow first aggregates quantities for each product across line items. It then checks whether there are possible aggregate discounts set up by examining the price list on both the header and line item level.

The workflow then compares the aggregate discount with the product quantity aggregation it has evaluated earlier to see whether it qualifies for any discounts.

Workflow Description

This workflow does the following:

1. Groups line items by Product ID and performs a quantity aggregation. The result of this operation is a property set with Product ID and corresponding aggregated quantities.

2. Uses Query Transformation to check if there is an Aggregate Discount Sequence associated with the price list from the header, and whether that Aggregate Discount Sequence is effective. If all conditions are met, then the list of IDs of all the aggregate discounts under that sequence would be stored in a property set.

3. This step is similar to the previous one except that it examines the Price List association of the line item. The IDs of all the possible aggregate discounts would be appended to the previously mentioned property set.

4. Using Rule Set Lookup Transformation and the information from previous steps, it identifies which of the possible aggregate discounts are satisfied along with the corresponding multiplier for each aggregate discount. This information is used as input to the next step.

5. Using Rule Set Lookup Transformation and the information from previous steps, it applies adjustments defined in the applicable aggregate discounts and put that on each of the line item. Line items having the same product would be ordered by their net price. Line items with a higher net price would have priority over items with a lower net price.

   The following table lists the steps in the Pricing Procedure - Aggregate Discounts workflow with the business service and method that is called by each step.

   Name	Type	Business Service	Method	Sub Process	Description
   Sum Product Quantity	Business Service	Row Set Transformation Toolkit	Aggregate Transform	Not applicable	Sums up quantities of line items by Product ID.
   Get Possible Bundles (Price List)	Business Service	Row Set Transformation Toolkit Service	Query Transform	Not applicable	Checks for the Aggregate Discount Sequence associated with the Price List from the Header.
   Get Possible Bundles (Row)	Business Service	Row Set Transformation Toolkit Service	Simple Look-Up Transform	Not applicable	Checks for the Aggregate Discount Sequence associated with the Price Lists from the Line Items.
   Identify Applicable Bundles	Business Service	Row Set Transformation Toolkit Service	Rule Set Look-Up Transform	Not applicable	Identifies applicable Aggregate Discounts and corresponding Multiplier.
   Apply Bundle Adjustments	Business Service	Row Set Transformation Toolkit Service	Rule Set Look-Up Transform	Not applicable	Applies the adjustments defined in aggregate discounts.