You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Financial Tax Register Layout

edited Jul 24, 2021 10:57AM in Tax & Global 2 comments

Summary

Financial Tax Register contains confused information because of layout

Content

Payables tax contains Recoverable Tax and Non-Recoverable Tax.

The relation is: TAX = Recoverable Tax + Non-Recoverable Tax

In Financial Tax Register report, for "ALL" tax selected in parameters,  this information is presented in two different rows instead of using the same row with two different columns. This presentation creates confusion and wrong total at the end of the report.

For example if the line amount = 100,  recoverable tax = 60, non-recoverable tax = 40, now the report shows the information in this way

INVOICE_NO        TAXABLE_AMOUNT                     TAX AMONUT             

12345                            100.00                             60.00                                        

12345                            100.00                              40.00                                        

Trying to summarize at end of report, will result taxable amount = 200 for this invoice, which is incorrect. There is no tax type identifier for the line (recoverable or non-recoverable). Please see attached picture.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!