Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Financial Tax Register Layout — Cloud Customer Connect
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

Received Response
13
Views
1
Comments
edited Jul 24, 2021 10:57AM in Tax & Global 1 comment

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!