Skip to Content
0
Jun 14, 2016 at 03:36 AM

Can we have one Header Group Condition value for items with different pricing dates (essentially driven off differently dated condition records)?

28 Views

Hi All,

Need your expert opinion on an issue:

We have a scale based group surcharge condition type, ZSUR, that is based on the order volume. ZSUR is Access Sequence driven with manually changes prevented. Currently there is one condition record (say # 00958713) with three scales (valid from 1/1/2016 thru 12/31/9999):

From 1 gallon = 5.00

From 100 gallons = 100.00

From 500 gallons = 250.00

Now the Business wants to a new tier <From 1000 gallons = 320.00>, so the new tier would look like:

From 1 gallon = 5.00

From 100 gallons = 100.00

From 500 gallons = 250.00

From 1000 gallons = 320.00

The catch is that the Business wants the new tier to be effective for existing open orders ONLY if quantity or line items are added.

A couple of ways I think that this can be achieved are (limitations are below each):

1. Add the new scale <From 1000 gallons = 320.00> to the existing condition record # 00958713 (keeping the start date of 1/1/2016 and end date of 12/31/2016 intact)

Limitation: The pricing is called explicitly in change mode (in case of existing orders); meaning if there is an order created before the existing condition record was appended, and the order was for 600 gallons, then in display ZSUR = 250.00 but in change mode ZSUR = 320.00 per the appended condition record.


2. Invalidate condition record # 00958713, to end on 06/13/2016 and have a new condition record # 00999719 as given below:

From 1 gallon = 5.00

From 100 gallons = 100.00

From 500 gallons = 250.00

From 1000 gallons = 320.00

Limitation: In case of an existing order, when items are added, the system adds another ZSUR at the header. Let's take the example # 1, wherein the order was for 600 gallons. We get one ZSUR at the header for 250.00, and let's say that now we add items so that the volume becomes 800 gallons. This generates another ZSUR for 320.00 in the order. So we have two ZSURs, we need just one (the second one) for 320.00 when items are added alone.

Has anyone faced this? Any suggestions, recommendations would be greatly appreciated. Thank you!

Regards,

Yet Another SAPAddict!