Multiple customer and item groupings in advanced pricing


Active Member
Hello Forum,
My migration customer has multiple customer and item groupings in their legacy system. They are migrating to JDE 9.2.and will be using Advanced Pricing. Is there a way to map these groupings into JDE?
For example,
customer group A has customers 1, 2 and 3.
Customer group B has customers 1, 2 and 4
Customer group C has customers 2, 4 and 6.
Item group X has items I1, I2, I9
Item group Y has items I1, I9, and I10
Item group Z has items I2, I8, I9
The concept I want to mimic in JDE is this:
First search for a price adjustment using customer group A.
If no match, search using customer group B
If no match search using Customer group C
Then same again using item groups.
My question can be reduced down to: how do I map multiple customer and item price groups into advanced pricing? As far as I can see, the limitation is a single item group and a single customer group.
All help appreciated ...
Regards ... Alastair