Reporting Tax Point Date for Payment and Accounting

Summary

Reporting Tax Point Date for Payment and Accounting

Content

Hi

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.