Generating the XML File for Bank Statements

Use the Bank Statement - POL - 74P program (R74P507) to generate the XML file for bank statements. The system uses the values that you have set up in the processing options or during data selection to identify the records to include in the report.

When you run the R74P507 program to print the XML file, the system:

  1. Retrieves all accounts for the selected reporting period that has the record type G (GL Bank Account) from the Bank Statement Header table (F0916)

  2. Retrieves the IBAN (International Bank Account Number) for the eligible accounts if the IBAN is available in the Bank Transit Master table (F0030)

  3. Retrieves and prints the bank statements for the eligible accounts from the Bank Statement Header (F0916) and Bank Statement Detail (F0917) tables

Before you print the XML file, you can print the report in PDF and Microsoft Excel document to verify the selected records in a format that is easy to review. To print the report in these formats, you use the XJDE0002 version of the Bank Statement - POL - 74P program (R74P507) on the Available Versions form.