Tax Base Amt not correct

[jamshed_khan2]

Dear Experts,

Need your kind attention as the base amount coming via Pricing procedure is not correct in my tax procedure in PO.

We have a scenarion where we have a discount condition in pricing procedure. so when We are putting the discount in PO via MM pricing procedure system is reducing the base amt as double. having no idea on MM pricing procedure.

For Eg:

132 Quantity *3.79 = 500.28 (before discount)

Here the discount is 35% so correct rate is 2.46 after discount.

132qty *2.46 = 325.18 correct base amount but when we are putting the discount 35%, in my tax procedure, system is showing base amount as 150.08. so my assumption is system is putting double discount thats why it is showing 150.08, the correct amt has to be 325.18.

Now  due to this issue, system is also calculating incorrect tax amt. In tax procedure system should take 325.18 but it is showing 150.08

Please advise as to what approach should be feasible to rectify this issue.

I am attaching few screen shot for your reference

[jamshed_khan2]

Dear Experts,

I have also attached the sceen shot of my tax procedure.

REgards:

Jamshed

[former_member198650]

Hi Jamshed,

Check any discount condition has maintained at header level also. System is behaving correctly, tax always calculates on after discount.

Regards,

Mukthar

[jamshed_khan2]

Dear Sir,

Thanks for the input, As per my knowledge also system is correctly showing the net value. I have attached the discount condition of MM showing the discount condition.

The sequence showing in MM pricing procedure are as follows:

Gross Base amt            xxxx

Less Discount               xx

Net amt                         xxxx

Add packng/Fordng       xx

Add Losding charges     xx

Net value                       xxxxxx

My question is how do I put this sequence in my tax procedure to arrive at the net amount. I am using condition formula for base type in tax type as 362 and 363. When I am taking 362 to 363, system is working fine for packaging and forwarding but not working for discount condition and when we are taking 362 to 363 system is considering the discount but ignoring the packaging and forwarding.

We are maintaining the discount condition at items level and not header level. I have attached the MM pricing condition screen shot for your reference.

Regards:

Jamshed

[former_member198650]

Hi Jamshed,

Check the conditions in M/06. Here you have to check cond.category for all the conditions.

Regards,

Mukthar

[jamshed_khan2]

Dear Sir,

I hae checked M/06, the pricing condtion selected as "B" devlivery cost.

Please advise if there is  any other check box option is available. I ahve attached the screen shot for you.

Regards:

Jamshed

[former_member198650]

Hi Jamshed,

If you want to calculate tax on it, then change the cond.class as prices, then it will calculate.

Regards,

Mukthar

[jamshed_khan2]

Dear Sir,

Thanks for the input, but my issue is that the base amt showing in tax procedure is not correct, if you check the MM pricing procedure and my tax procedure you will see the difference.

AS explained in sequence of mm pricing procedure, I am putting 362 in the base amt column and 363 in the sub total amt column to fetch the base amt from mm pp.

Even though when putting the discount system is calculating double discount as explained above.

Having no idea as how to rectify this issue.

Regards:

Jamshed

[former_member198650]

Hi Jamshed,

Share screen shot of discount condition.

Regards,

Mukthar

[jamshed_khan2]

Dear Sir,

I have attached the discount condition screen shot for you.

Regards:

Jamshed

[former_member198650]

Hi Jamshed,

Share screen shots of PO header conditions.

Regards,

Mukthar

[jamshed_khan2]

Dear Sir,

I have attached the PO header condition. Please let me know if anything needs tto be done either from FI side.

Regards:

Jamshed

[jamshed_khan2]

Dear Sir,

Just to inform you one more points, that packaging and forwarding condition is defined at header level and discount condition is defined at item level.

I am changing the CalType 362 and 363, but when packaging and forwarding is working then discount condition is not working and vice cersa.

Please guide me as to what can be the reason for this?

Regards:

Jamshed

[former_member198650]

Hi Jamshed,

System will calculate tax on the base amount after deduction of discount. It is a standard behavior.

Regards,

Mukthar

[jamshed_khan2]

Dear Sir,

I have attached one screen shot for your reference. My only doubt is that based on the caltype (362 for base amount, 363 for subtotal) in y tax procedure. system is deducting the discount from the base amount

EG: Base amount 10000

Less, Discount     1000

subtotal               9000

Add Freight           500

Net amount           9500

But the problem is system is not adding the freight to the base amount.

What can be the logic to add the freight cost to the base amount after deducting the dsicount.

I have no idea as to how to map this?

Regards:

Jamshed

[former_member198650]

Hi Jamshed,

Change the condition in M/06 as cond.class as discount/surcharge and cond.category as blank, then system will calculate tax on fright also.

Regards,

Mukthar

[jamshed_khan2]

Dear Sir,

Discount condition is working fine however, when adding the freight, system is not adding the same to arrive at the net amount. Freight condition is defined at the header level.

What can be the reason for this?

Regards:

Jamshed

[former_member198650]

Hi Jamshed,

I am not clear, what you expect? Do you want calculate tax on freight amount also? Please explain clearly with SAP screen shots.

Regards,

Mukthar

[jamshed_khan2]

Dear Sir,

Sorry for the confusion. My requirement is that the discount condition is not working to arrive at the net amount. Let says:

Base amount is 10000 (given in PO)

Less discount:   1000

Subtotal:         9000

If you can notice that my tax procedure is not showing the correct amount. Instead of showing 9000 system is  showing 8000.

I have attached screen shot for discount condition and tax procedure after applying discount. In pricing procedure it is showing fine but in tax procedure it is showing double discount.

Regards:

Jamshed

[former_member198650]

Hi Jamshed,

Why the discount condition is showing twice in the pricing conditions tab?

Regards,

Mukthar

[jamshed_khan2]

Dear Sir,

I have attached one more screen shot for discount condition in PO, here I have rectified the discount condition which was showing twice. But still I can see that in my tax procedure. system is deducting twice the discount amount. If PO amount is 10000, and discount is 10%, then in my tax procedure, system is showing 8000 and not  9000 which is correct.

Regards:

Jamshed

[former_member198650]

Hi Jamshed,

Have you checked the tax calculation after you delete the condition?

[jamshed_khan2]

Dear Sir,

I have checked the tax calculation procedure but still the base amount is showing as 8000 however, it should be 9000.

Regards:

Jamshed