What about creating the following tables to store the data:
Table 1: Pricing Discount Header (PromoID, Total Quantity Required, Price Discount, effectivity dates, other promo related fields)
Table 2: Promo Items (PromoID, SeqID, ItemNumber, other detail fields)
Then you might be able to Use CSM User Exits to change the prices based on looking up data in those files.
California Fine Wire
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Marc Rohde
Sent: Wednesday, October 02, 2013 6:29 AM
To: MAPICS ERP System Discussion
Subject: [MAPICS-L] Pricing Question
Is there a good way to handle a quantity specific promo when it is based on mixed quantity?
For example we have product ABC-Black and ABC-White that will get a reduced price when a customer orders 144 in combination of the two. They are distinct part numbers rather than "S" numbers and we have had another promo where the price is based on a larger mix (3+ items).
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l