Skip to Content
0
Former Member
Sep 07, 2010 at 01:03 AM

limiting the value of surcharge

20 Views

Hi all,

I have a requirement to limit the value of certain surcharges per line item .(to 75$/ton)

material1

(variant)

VA00 surcharge1 60$/ton

VA00 surcharge2 80$/ton

VA00 surcharge3 90$/ton

VA00 surcharge1 and VA00 surcharge2 belongs to ZTable entries (VA00 surcharge3 does not belong to Ztable)and are subjected to surcharge limit.I am planning to put a discount type to negate the surcharge.The total value of VA00 surcharge1 and VA00 surcharge2 is 140 $/ton.It should be limited to 75$/ton

VA00 surcharge1 60$/ton

VA00 surcharge2 80$/ton

VA00 surcharge3 90$/ton

xyz(surcharge limiting discount condition type) --65$/ton (140-65 =75$/ton)

( so that a total of 75$/ton applies to material for surcharges VA00 surcharge1 and VA00 surcharge2 since it belongs to Ztable)

What is the best way to have negative value for XYZ discount type to negate surcharge value? ( alternate calculation type?alternate condition base value?) Pls advise

regards

jill