Generating the XML File for Accounting Books

Use the Accounting Books - POL - 74P program (R74P511) to generate the XML file for accounting books.

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

• Retrieves all posted transactions from the Account Ledger table (F0911) for the company, all ledger types except the CA ledger type, and the reporting period that you specify in the processing options or during data selection

• Prints the retrieved transactions and the document lines of the transactions in separate sections in the XML file

• Prints information about all accounts of the company based on the To Fiscal Year processing option value in the General Ledger Trial Balance section

  The system retrieves account information from the Account Ledger table (F0911), Account Balances table (F0902), and Account Master Additional Information - POL - 74P (F74P511).

Before you print the XML file, you can print the report as a 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 Accounting Books - POL - 74P program (R74P511) on the Available Versions form.

The system uses Oracle's BI Publisher (Business Intelligence Publisher) to generate the required XML files. To generate different XML files that comply with the output information and format required by the fiscal authorities, the system uses specific templates and report definitions. Review the relationships in the following table:

Output	Batch Version Program	Version	Template	BI Publisher Report Definition
Accounting Books XML Report - POL - 74P - XML	R74P511	XJDE0001	TP74P511	RD74P511
Accounting Books Validation PDF/Excel Format	R74P511	XJDE0002	TP74P512	RD74P512
JPK Accounting Register(JPK_KR_PD) - POL - 74P - XML	R74P511	XJDE0003	TP74P515	RD74P515
JPK Accounting Register Validation(JPK_KR_PD) - EXCEL/PDF	R74P511	XJDE0004	TP74P516	RD74P516