E1: 76P: After Applying ESU JN20598, the R76P4500 - V.A.T. Purchasing Report and R76P4504 - V.A.T Purchasing Report CSV Requires Field Adjustments When Using Processing Option to Generate CSV in Text Format (Doc ID 3025496.1)

Last updated on JULY 30, 2024

Applies to:

Symptoms

After applying changes for V.A.T. Purchasing Report (R76P4500) and V.A.T Purchasing Report CSV (R76P4504), the following fields are not formatted correctly when using the Print processing option for printing the report in CSV and TXT formats:

• Print processing option 6 is set to select Output type of the Report = 3 - Generate CSV with Domicile records as in Text file format.
  • Column 4 (CUO Record Key) is based on TX40 field
  • Column 9 (DUA Series)
  • Column 10 (DUA/DSI Year)
  • Column 11 (Payment Number)
• Print processing option 6 is set to select Output type of the Report = 4 - Generate CSV with Non-Domicile records as in Text file format.
  • Column 4 (CUO Record Key) is based on TX40 field
  • Column 8 (Payment serial number)
  • Column 13 (Payment serial number)
  • Column 14 (DUA/DSI year of serial number)

Steps to duplicate:

1. Create 20 or more Debit Memos in Accounts Payable Voucher Entry - P0411.
2. Post voucher to G/L (R09801).
3. Run R76P4500 to generate the Domicile records by setting the following Print processing option to 3:
   6. Select Output type of the Report
       3 = Generate CSV with Domicile records as in Text file format
4. Review text format and compare with the PDF output.
5. Run R76P4500 to generate the Non-Domicile records by setting the following Print processing option to 4:
   6. Select Output type of the Report
       4 = Generate CSV with Non-Domicile records as in Text file format
6. Review text format and compare with the PDF output.

NOTE: These are similar fields to what has previously been fixed in the Accounts Receivable reports R76P340 and R76P3B42.

Changes

Apply ESU JN20598

Cause

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