My Oracle Support Banner

R12: JGZZAPVR: Functional amount not equal to taxable amount plus tax amount for invoices which have a tax code is linked to an offset tax code, but there are no offset tax lines on the invoice (Doc ID 2077684.1)

Last updated on MARCH 25, 2019

Applies to:

Oracle Financials Common Country - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, ECE Payable VAT Register (JGZZAPVR)

ECE Payable VAT Register report is incorrectly displaying functional amount as equal to taxable amount in case tax code has an associated offset tax, but no offset tax lines are generated on the invoice ( offset lines are not generated on the invoice because flag Allow offset tax is not enabled at Third Party header/site in Tax Managers ->Parties). Functional amount should be equal to taxable amount plus tax amount for these cases. Only if the invoice has offset tax lines, then the functional amount should be equal to taxable amount.

ECE Payable VAT Register should display correct functional amounts no matter offset tax lines are present on the invoice or not.

The issue can be reproduced at will with the following steps:

1. Book invoices with  offset tax lines and without offset tax lines.
1. Run EMEA VAT Selection
2. Run ECE Payable VAT Register Report


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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