E1: 74S: VAT Report by Tax Rate/Areas (R74S450) Report Shows Incorrect Results when Running over A/P Transactions Having Tax Rate/Area with Intra-Community Checkbox Selected (Doc ID 2981318.1)

Last updated on OCTOBER 17, 2023

Applies to:

Symptoms

When running VAT Report by Tax Rate/Areas (R74S450) Report over A/P posted transactions with tax rate/area that has the Intra-community checkbox selected, then the PV lines displayed on the R74S450 pdf are doubled, showing incorrect values for the totals on Taxable Amount and Extended Price.

Steps:

On P0092 User Profile Revisions setup the Localization Country Code = ES under the user profile.

1. On P4008 Tax Rate/ Areas set a tax rate/area with tax rate 1 = 0, tax rate 2 = 10%, tax rate 3 = - 10%, and the Intra-Community VAT checkbox as Not Selected.
2. On P0411 Supplier Ledger do enter some vouchers with that tax for a specific supplier, then post those vouchers.
3. Go to BV to set the POs and Data Selection for R74S450 for the A/P version, then run that version and double-check on the R74S450 pdf that there are displayed only the lines having lines with tax rate 2 (10%) for the A/P vouchers.
4. On P4008, for the tax rate/area set at step 2 do select the checkbox for the Intra-Community VAT, then save the modification.
5. Go to BV to run the R74S450 version and notice on the resulting R74S450 pdf that the lines are showing doubled, being shown both tax rate 1 (0%) and tax rate 2 (10%) lines for the A/P vouchers. Due to that, the values for the totals on Taxable Amount and Extended Price are incorrect.

Changes

Cause

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