cancel
Showing results for 
Search instead for 
Did you mean: 

AR Invoice Tax amount has differences with Total of Line Tax Amount.

0 Kudos

Dear Expert.

SAP Business One 8.81 (8.81.320) PL: 10 HOTFIX1

AR Invoice Tax amount has differences with Total of Line Tax Amount.

In case of create service type of AR Invoice by manually using duplicate,

Document Tax amount has differences with Total of Line Tax Amount.

Example:

<Document Total>

----------------------------------

Total Before Discount : 31,522.50

Tax 7%: 2,235.46

Total :33,757,96

<Document Line>

------------------------------------

Total of Line Tax Amount : 2,206.58


Difference Tax Amount : 28.88

             

Actually, Total of Line Tax Amount is correct. 31,522.50 * 7% = 2,206.58

In addition, Journal Entry was posted by the total of line Tax Amount as well.

Therefore, Revenue Account amount has changed such as below.

Account                        Debit                Credit

------------------------------------------------------------------------------

Account Receivable     33,757.96

Tax (7%)                                         2,206.58

Revenue Account                            31,551.38


I am not sure why it has occurred.

Please for the advice.

Thank you.

Accepted Solutions (1)

Accepted Solutions (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi Shegeru Matsubara,

Due to rounding method caused the difference.

Thanks & Regards,

Nagarajan

Answers (1)

Answers (1)

VamcParimisetti
Contributor
0 Kudos

Hi

0 Kudos

Hi Vamsi ,

Thanks for your advise.

My current settings on the General tab of Documents settings.

Rounding Method is by Document and A/R Invoice of Document settings

Uncheck to the Automatic Rounding for Document.

Therefore, There are no fields for the Rounding settings on the Currencies.

Is it necessary to the change settings ?

I know that if rounding method to be change by Currency , there are   rounding setting fields on the Currencies.

I am not understanding what is difference rounding method and how to avoid in this case.

For you information, Tax Formula is not using and foreign currency is not using also.

Best Regards,

Shigeru

VamcParimisetti
Contributor
0 Kudos

Hi Shigeru,

In  B1,  rounding method i based on Document level or Currency level.So,Select whether the amounts , prices that appear in marketing documents should be rounded by currency or by document.

It is Necessary to Define the Rounding Methods based on your Requirements .

Check Below Links for Ref.

http://scn.sap.com/thread/1729618

https://websmp130.sap-ag.de/sap%28bD1odSZjPTAwMQ==%29/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F...

Regards,

Vamsi