Tax being calculated based on each item on the invoice rather than total?

[Former Member]

Dear all

I need your expertise on this.

I'm having a problem with the invoice in SD which appears to calculate tax based on each item and added them up to print total tax, which is different from if you calculate tax based on the total amount.

E.g. ) You have 10 lines on the invoice (in JPY):

No. 1 127260

No. 2 127260

No. 3 157660

No. 4 81580

No. 5 157660

No. 6 81580

No. 7 88640

No. 8 40060

No. 9 40060

No. 10 63460

No. 11 63460

and total amount is : 1028680. If tax ratio is 17.5% then total VAT amount would be 180019. But because of the way SAP (out SAP is 4.6c by the way) calculates VAT is at the moment based on each item, so VAT for each item would be:

No.1 22271

No.2 22271

No.3 27591

No.4 14277

No.5 27591

No.6 14277

No.7 15512

No.8 7011

No.9 7011

No.10 11106

No.11 11106

and the total of above is 180024. Please note SAP rounds JPY amount at the 1st decimal point.

The invoice shows 180024 rather than 180019. I think most of the case VAT should be calculated based on the total amount not per item and adding them up.

It would be great if there's any way to just 'configre' sap to achieve this. Thank you very much in advance.

[Former Member · Accepted solution]

Hi

Then maintain the tax condition type as a header condition and mark ti`ck as group condition in the condition type configuration t code V/06

Regards

Damu

[Former Member · Accepted solution]

Hi Damodhar,

Thank you for your quick reply!

When you say " as a header condition", "Item condition" should be unticked - is that correct? I was looking at ATX1 and although it has "Group cond." as an Group condition option, I found "Changes which can be made" option has both "Header condit." and "Item condition" ticked. (Sorry not sure if ATX1 is the one I should look at!)