base amount for tax calculation in sap billing

[Former Member]

Dear Experts,

We have a situation where out sap invoice final amount is not matching customer PO, because of rounding in SAP.

EG:

Selling Price: 74,766.36

Tax: 5,233.65

Final Amount: 80,000.01

Whereas the final amount should have been 80,000

So initially we added DIFF condition to adjust Tax amount, but it was affecting Output VAT report showing all these DIFF values

Business does not want that, so we are adding DIFF condition to net value. Now the net value and tax are as below

Net                 74,766.35

Tax                  5,233.65

When it comes to accounting entries are as below

01                           8000485                customer             80,000.00             THB

50                           2100100                Revenue Gds - Dom       74,766.36-           THB

50                           2623600                Output Tax         5,233.65-              THB

40                           2100100                Revenue Gds - Dom       0.01        THB

And the base amount considered for tax calculation is as below

G/L        Tax amount         Base amnt           Tx   Tax ra

262XXXX    5,233.65-          74,766.36-           O7    7.000

Is it possible to adjust the base amount for tax calculation to 74,766.35 instead of 74,766.36?

How can I achieve it? Does it help me if I put tax condition at header level?

Please advise.

Regards

Pradeep

[Former Member]

Hi,

check

Regards,

JM

[ajitsingh6]

Hi,

You need to do tax calculation base as mention below,

STEP  Counetr                   From To

01                           8000485                        customer             80,000.00             THB

50               1          2100100                        Revenue Gds - Dom       74,766.36-           THB

50               2          2100100                        Revenue Gds - Dom       0.01        THB

60                           2623600        50            Output Tax         5,233.65-              THB

Now your calculation base is total of STEP 50 and that is 74,766.35-.

Regards,

Ajit K Singh

[Former Member]

Dear Ajit,

Thanks for your reply. If you are telling that i need to move the DIFF condition above the MWST condition in the pricing procedure, i have already tried that and in that case it is affecting both net value and tax. which is not correct.

Net                 74,766.35

Tax                  5,233.64

Final amount 79,999.00

please tell me if my understanding is wrong.

Regards

Pradeep