Getting Advanced Pricing to accrue for a modifier based on a Pricing Formula

Hello Advanced Pricing Experts.

We have a requirement to accrue sales credits for sales reps based on the amount sold.

The Requirement that we have is as follows

Order Amt = $100

Sales Credits = SalesRep A = 60% SalesRep B = 40%

Accrue Sales Commission = 10% for both SalesRep A and B

Accrual Calculation

So, accrue = $100 x 10% x 0.60 = > $6 for SalesRep A

&   accrue = $100 x 10% x 0.40 => $4 for SalesRep B

Now, to solve this. we followed this approach mentioned below  - but are getting stuck

1. Created a custom qualifier = SalesRep ID => that returned a PL/SQL API Multi-Record

2. Created 2 modifiers, one for each SalesRep with Qualifier = SalesRep ID (custom qualifier from step 1)