cancel
Showing results for 
Search instead for 
Did you mean: 

ROUNDING TAX AMOUNT

Former Member
0 Kudos

Hi

We are using SAP 8.81 PL5 South African Localization. Currently we have set currencies to round to Ten. On the marketing documents, AR Invoice, rounding to Ten on invoice value is working fine but unfortunately the rounding is not affecting the tax amount computed. As such, the effective tax rate is wrong, lower or higher depending on whether rounding is + or _ respectively. Please help me on how i can have both tax and invoice value rounded simultaneously.

Regards

Accepted Solutions (0)

Answers (8)

Answers (8)

Former Member
0 Kudos

Hi George......

I would suggest you to manage Tax Rounding in Tax Formula.....

This will give you better result.

But this will be as per Row wise......

Regards,

Rahul

Former Member
0 Kudos

Gordon,

What should have been the correct settings for this to work?

Regards

George

Former Member
0 Kudos

Hey George ,

If your decimal setting is not allowing to get the desired result then only one way out is there to meet your needs.

Edit your Formula and set the output Value in Rounding with .00

try query like this :

VAT_BaseAmt=Total
VAT_TaxAmt=Round (VAT_BaseAmt*VAT_Rate, 0)

Hope it helps

Thanks

--

Ashish

Former Member
0 Kudos

Ashish

Thanks but i want to round currency as well. Doing as you propose does not round the currency.

Regards

George

Former Member
0 Kudos

Rahul

The decimal setting for percent is 2

Regards

George

Former Member
0 Kudos

Gordon

The decimal settings for rate is 4 and amount is 2.

Thanks

George

Former Member
0 Kudos

George,

Since your rate setting is 4, your tax calculation will be by 4 decimals. However, you can't reduce it if you version is not below 2007.

Gordon

Former Member
0 Kudos

Hi George ,

Try this ,

Goto Administration --> System Initialization --> Document Setting

Tick the Check Box of Round Tax Amount in Rows

Try this , Hope it helps

Thanks

--

Ashish

Former Member
0 Kudos

Hi George.......

What is the decimal setting for Percent?

Please check....

Regards,

Rahul

Former Member
0 Kudos

Hi,

What are the decimal settings for Rate and Amount in your system?

Thanks,

Gordon