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 NOVEMBER 03, 2016

Applies to:

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

Symptoms

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

ACTUAL BEHAVIOR
-------------------------------
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.

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

STEPS
-----------------------
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


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms