was wondering if anyone would know how to resolve our issue.

We have pricing specific to Customers. We have a Standard Price each Customer can have a different price schedule say it either 2, 4 or 6% discount, some may even have a price increase from the standard price.

Here is an example

Customer XX item AAAA has a standard price of 58.16, Customer XX gets 4% off of this price so their price would be 55.83, in addition to this 4% they have a promotion this week that gives an additional 15% off for this week so the price for item AAAA would be 47.46, starting next week any orders for item AAAA would be back at the 4% off of 55.83.    (some items under this customer get the 4% and other items 6% of standard price)

any thoughts would be helpful