R12: Tax: Total Taxable Amount in Tax Reconciliation by Taxable Account Report Is Not Correct When Only One Invoice With Recoverable Tax Is Selected (Doc ID 3025101.1)

Last updated on MAY 26, 2024

Applies to:

Symptoms

Taxable Amount of Total Account in Tax Reconciliation by Taxable Account Report is not correct when only one invoice with recoverable tax is selected.
We created the invoices as follows:

  26-NOV-2022 Create a invoice with Recoverable tax
  27-NOV-2022 Create a invoice with Recoverable tax
  28-NOV-2022 Create a invoice with Nonrecoverable tax

Taxable Amount of Total Account is not correct when the above invoices are output in Tax Reconciliation by Taxable Account Report.

Specified Accounting Period in parameter:

  Start: 26-NOV-2022 to End: 26-NOV-2022 --> NG. Taxable Amount will be 0.
  Start: 27-NOV-2022 to End: 27-NOV-2022 --> NG. Taxable Amount will be 0.
  Start: 28-NOV-2022 to End: 28-NOV-2022 --> OK.
  Start: 26-NOV-2022 to End: 27-NOV-2022 --> OK.

As described above, when only one invoice is selected for output, and furthermore, if that invoice has Recoverable Tax, the correct taxable amount will not be output and will be zeroed out.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.