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

Reporting Tax Point Date for Payment and Accounting

Received Response
edited Mar 24, 2021 12:57PM in Tax & Global 6 comments


Reporting Tax Point Date for Payment and Accounting



We have a custom report where we want to pull the tax point date for Invoices. Our Tax Point date for some countries is Payment and for some countries is Accounting.  Please let us know the logic or the SQL on how we can easily get the details of the tax point date for the invoices.

Oracle documentation says that tax point date for invoices whose tax point basis is payment needs to be picked up from the GL Tables of Invoice Payment distributions but joining subledger tables to GL tables is hampering perforamnce so i would like to check on how other oracle implementations are doing and what is the best practices for this.

Howdy, Stranger!

Log In

To view full details, sign in.


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