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:
JD Edwards EnterpriseOne Environmental Accounting and Reporting - Version 9.2 and laterInformation in this document applies to any platform.
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.
- 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.
- On P0411 Supplier Ledger do enter some vouchers with that tax for a specific supplier, then post those vouchers.
- 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.
- On P4008, for the tax rate/area set at step 2 do select the checkbox for the Intra-Community VAT, then save the modification.
- 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
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
Symptoms |
Changes |
Cause |
Solution |
References |