Fuel Surcharge pricing conditions

[Former Member]

Hi all,

I have critical requirement to implement Fuel Surcharge during sales processing,

Basically we have Base Fright is fix based on ship to party and we have Fuel Surcharge is fixed based on ship to party and we have one more Fuel Surcharge called additional Fuel Surcharge,

Example:

XXX1 - $10

XXX2 u2013 10% = $1 (10% of $10)

XXX3 u2013 12% = $0.2 (2% of $10)

XXX1 and XXX2 i can maintain condition records based on ship to party but problem with XXX3 condition type

XXX3 u2013 Shall be a Single Fixed % for all the Customers. If the % is more than XXX2, then Addl fuel Surcharge is calculated. If it is Same or less, then not calculated. This shall be periodically maintained by the sales administrator.

XXX1 - $10 - We can maintain condition records base on ship to

XXX2 u2013 10% = $1 (10% of $10) -We can maintain condition records base on ship to

XXX3 u2013 12% = $0.2 (2% of $10) No idea how to do this one

can any one guide how to maintain or compare two conditions % to get the difference conditions % in pricing procedure.

Or can one have any other thought guide me

Regards

Nishad

[Former Member · Accepted solution]

Hi

Although requirement is not very clear from ur explanation, I understand following

1.The additional fuel surcharge is always calculated/ triggered irrespective of ship to party and other components like incoterms.

2.The XXX2 and XXX3 are mutually exclusive ,only one is present/Active at a time.

In above scenario :

create XXX3 Additional Fuel surcharge condition with access sequence based on sales org and If u have this same pricing applicable for exports as well then use destination country.

U can use JDUM access seq in this case. maintain requisite fixed % in condition record for this condition.

In pricing procedure maintain xxx3 based on ur price condition.

Now maintain condition exclusion group for XXX2 and XXX3 ,XXX3 to be active if value is more than XXX2.

This way both conditions can be seen in document yet only one will be active.

I would further suggest to use a separate total condition type for freight total and put that in accounting rather than individual conditions so that any future changes can be easily accomodated w.r.t. pricing.Make individual Freight condition statistical.

Alternatively u can use Condition base value formula in XXX3 where it will check XXX2 condition value and price value and make it active or inactive.

I hope this helps

Regards

Mandar

[Former Member · Accepted solution]

Thanks Mandar,

your inputs really helps us to resolve the issue, i use condition exe process to map the requirement.

Thanks