E1: 74B: The Yearly VAT Report (R74B150) for Belgium only Produces an XML File with an Initial Total Line but Not with the Corresponding Details. (Doc ID 2860989.1)

Last updated on APRIL 08, 2022

Applies to:

Symptoms

When the Belgian Yearly VAT Report (R74B150) is run in final mode, the associated report definition no longer produces a complete XML file. Instead, the file only shows the initial total line and does not include the corresponding details of the invoices that make up the total.

STEPS TO REPRODUCE

1. Setup:
   1. P0092: set the localization country code to BE for Belgium, log off and back in.
   2. UDCs: make sure the following UDC tables are set up:
      1. VAT Report Code (74B/TA)
      2. File Type (74B/FT)
      3. Version (74B/VE)
      4. Test (74B/TE)
      5. European Community Members (74/EC)
   3. P4008: set up a Belgian tax rate/area (TRA).
   4. TAX Rate Area / Document Type program (P74B500): link the TRA to invoice doc type.
   5. Set up a Belgian Company:
      1. P01012
      2. Belgium Company Additional Information program (P74B010)
   6. Batch Versions:
      1. Set up a version of Yearly VAT Listing (R74B200)
      2. Set up two versions of Yearly VAT Report (R74B150), one for the proof mode (e.g. XJDE002) and one for the final mode (e.g. XJDE0001):
         • Proof mode version: Specify the R74B200 version in the R74B150 processing options
         • Final mode version: make sure it has the Report Definition default for the Yearly VAT report
   7. BIP setup:
      1. BIP Report Definitions (P95620): verify that the RD74B150 report definition is set up and that BIP template TP74B150XS is attached to it.
      2. BIP Templates (P95600): verify the setup of TP74B150XS
   8. Create 2 Belgian customers for the Belgian company:
      1. P01012
      2. P03013: set TRA from step 1c as the default.
         
         
2.  Processing:
   1. P03B11: Create some invoices with tax for the 2 Belgian customers.
   2. R09801: post the invoices.
   3. Run the Yearly VAT Report (R74B150):
      1. Proof mode
      2. Final mode

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.