E1: 74L: R74L3001 Does Not Create XML Section GeneralLedgerEntries if the Accounting System C is Used And there are More Than 999 Unique Documents in the General Ledger (F0911) (Doc ID 2846539.1)

Last updated on NOVEMBER 07, 2023

Applies to:

Symptoms

The Standard Audit File for Tax Purposes - Portuguese version (SAFT-PT) is a standardized XML file used for exporting the accounting information of a company to the tax authorities.

The system generates the SAFT-PT XML using the following steps:

• The SAFT -PT Extractor program (R74L3001) extracts the required information and produces the intermediate XML.
• The Business Intelligence Publisher (BIP) XSL transformation and report definition converts the intermediate XML to the legal SAFT-PT XML.

However, R74L3001 does not create the XML section called ‘GeneralLedgerEntries’ if the Accounting System C is used and there are more than 999 unique documents in the General Ledger (F0911) for the period specified in the R74L3001 processing options.

This is incorrect as there may be more than 999 unique (source) documents in the F0911 for the specified period.

STEPS TO REPRODUCE

1. Setup
   1. P0092: set Localization Country Profile to PT for Portugal.
   2. P74L920: set up the referential chart of accounts.
   3. P74L921: associate the legal accounts in P74L920 to the regular JDE1 chart of accounts.
   4. P4008: set up a tax rate/area for Portugal.
      1. P74L4008: set up the tax types, tax country region, and tax code for the tax rate/area.
   5. P01012: verify that the taxpayer ID is assigned for a Portuguese supplier.
      1. P74L101: set up the self-billing indicator. Select 1 from the Billing Indicator (74L/BI) UDC value if the self-billing agreement exists or else select 0.
   6. P04012:
      1. assign one of the tax rate/areas to the supplier
   7. BV: set up 2 versions of R74L3001:
      1. Monthly version for January 2022
      2. Yearly version for the entire year of 2022
      3. Both versions should have a C in processing option 1 on the Process tab.
         
         
2. Data
1. P041017: create a number of vouchers for the supplier and the Portuguese company using the grid import functionality, so that there are close to but less than 999 vouchers for January 2022 and another 200 for February 2022.
2. R09801: post the vouchers.
3. Databrowser: verify the F0911 records for the Portuguese company for 2022.
   
   
3. 1. Processing
   2. Run the monthly version of R74L3001. See how XML section GeneralLedgerEntries is printed.
   3. Run the yearly version of R74L3001. See how XML section GeneralLedgerEntries is not printed.

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.