Reverse Calculation in Pricing

[Former Member]

Dear All,

I have following scenario to be configured in sd pricing procedure.

MRP : 145 -

---

(this will be entered bu user or condition record)

Trade Disc.(20% on MRP): 29

Promo disc (3% on MRP) : 4.35

Price after Disc. : 111.65----

---

(this price is inclusive of taxes)

VAT (1%) : on X base price

Service tax(1%) : on X base price

Base price: X

Formula is : X + (1%X+ 1%X)= 111.65

Now for Value of X, system need to back calculate this price.

I am trying this scenario with pricing procedure VKP001.

But i need two taxes to be calculated and its not coming in above pricing procedure. its working with only one tax type.

I request u all please suggest some possible soln on the same.

Thanks and Regards,

Rasik

[jpfriends079]

There is recently discussed SDN thread with similar kind of requirement, where they have proposed Calculation Type as H for condition types involved. You can refer following link for details:

-

Regards

JP

[Former Member]

Hello Jyoti,

I have already gone thr this thread.

i have assigned type H to both taxes.

But in pricing procedure its not working for both the taxes at a time.

If i use only one tax then its showing correct result.

Thanks,

Rasik

[jpfriends079]

If i use only one tax then its showing correct result

.

Yes, that is practical, you will either have VAT or service tax for material.

You can't have both in one line item.

Further have Calcutaion type added to discount condition type also.

Regards

JP

[Former Member]

Hi,

The mathematical concept of back calculation is as follows:

Taking yr case The landing price (inclusive of tax)=111.65

Let sat Vat is x % and Service Tax is Y%

Vat = 111.65*X%/(1X%Y%)

Service Tax= 111.65*Y%/(1x%Y%)

You need to creat a routine for back calculation with above mentioned logic.

Revert if you have any doubt.

Rd's

Sanjay

[Former Member]

Dear Sanjay,

Thanks a lot for your reply.

where do i need to assign this routine in pricing procedure i.e. in Cal type or in Base type?

Thanks,

Rasik

[Former Member]

Hi,

Assign this in "Cal ty" filed in Pricing procedure. Moreover pls note whenever a material is taxable no service tax can be imposed on this as material (as it is not a service) however the rules of calculations will remain same if in that state apart from VAT, additional VAT is being imposed on material.

Rd's

Sanjay

[Former Member]

Dear Rasik,

Try to create two conditions types as Vat Adjustment and Service tax adjustment, Put these conditions after the Discount conditions and deduct the value from Price after Discount, Now you will get X, Calculate the Vat and Servide tax on this.

Regards

Suchait