How to club

[Former Member]

Dear All,

I have a customer requirement, where in the discounts need to be calculated on a price that is not having the excise duty,

environmental fee  and National health product tax(NETA).

Within the invoice, the NETA is getting reflected at the end of the document.

Within the invoice, the excise duty is getting reflected just above the NETA tax.

Within the invoice, the environmental fee is getting reflected at middle of the document.

All the above fees – (minus) list price would be the base for the discounts and rebates.

Is there a standard way to club all the above three fees at various steps and subtract from the list price.

And make the resultant value as the base for Discounts and rebates. Or is it possible only through enhancement.

Kind Regards

Chakradhar

[Former Member]

Hi Chakradhar,

You can achieve this using Standard pricing using condition base value routine and sub total column.  Please see the below example, this will help you in resolving your issue:

Base price 100

Freight - 2

Environmental fee - 5

Discount 10% on (BP - (EF +ED + NT)

Excise Amount 10

Rebate 10% on (BP - (EF +ED + NT)

NETA tax - 5

To achive the above requriement, you need to

Pass Base Price into subtotal (let us say subtotal 4)

Pass Env Fee, Exice duty & NETA tax amount values into Subtotal (let us say subtotal 5)

Write a condition base value routine in pricing procedure in which give the base value as

Subtotal 4 - 5, so as the system will do the calcuation and it will take that amount as base value for your discount calculation.  you can attach the same routine for Rebate also.

Hope this helps.

Regards

Raju

[former_member216765]

Hi

I suggest you should check your pricing procedure, If your requirement is that all the said Taxes should include in the calculation of Gross Value, and adjusted value then be used for further discounts or rebates etc. I suggest that you should re position the TAX condition types above the 'Gross Value' field in the pricing procedure and assign step no., now for Gross Value mention the range of Step no. in 'To' and 'From'  column, which you want to included in the calculation.

Position discount and rebate conditions below the gross value and include the same in calculating the Net value.