My Oracle Support Banner

E1: 74F: the Reprint of the French VAT for Receipts/Payments report (R74F100) in the Same Period sets Incorrect Taxable & Tax Already Declared values (Doc ID 2619277.1)

Last updated on DECEMBER 11, 2019

Applies to:

JD Edwards EnterpriseOne General Ledger - Version 9.1 and later
JD Edwards EnterpriseOne Accounts Receivable - Version 9.1 and later
JD Edwards EnterpriseOne Accounts Payable - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

When reprinting the French VAT for Receipts/Payments report (R74F100) for the same period, any existing transactions printed again have incorrect "Taxable already decl" and "Tax already decl" values on the report. 

For example:

STEPS TO REPRODUCE

  1. P0092: set Localization Country Code = FR
  2. P0010 & P01012: set up a company with base currency EUR
  3. P0901: define separate VAT accounts for VAT on receipts and payments:
    1. ENC VAT collected on receipts
    2. DEC VAT deductible on payments
  4. P4008: define the tax rate codes applicable to VAT on receipts and payments
    1. C206E AR VAT on Receipts, GL Offset = ENC
    2. D206E AP VAT on Payments, GL Offset = DEC
  5. UDC 74/TX: set up the tax rate codes used only for VAT on receipts and payments
  6. P0012: set up AAIs for the receivables and payables tax accounts using the GL offsets defined for tax rates
  7. P01012 and P03013: set up a customer and assign a French TAX ID to it
  8. P03B11: enter 2 invoices with VAT taxes for the company and customer for July, then post them
  9. P03B102: enter 2 receipts for the previously entered invoices in July, partially paying one of the invoices and fully paying the other one, then post them
  10. Run R74F100 UBE in Proof and Detail mode for AR and AP, for July
  11. Run R74F100 UBE in Proof and Summary mode for AR and AP, for July
  12. Run R74F100 UBE first time in Final mode for AR and AP for July, and note the "Taxable already decl" and "Tax already decl" values and the column headings
  13. P03B11/P03B102: create a new invoice and partial receipt for July, and post them
  14. Run R74F100 second time in Final for AR and AP on July, with the same POs and Data Selection as Step 12 (when running first time in Final) and note the "Taxable already decl" and "Tax already decl" values and the column headings.

 

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


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