Understanding the History VAT Listing Corrections Program

When you run version XJDE0002 of the VAT European Sales List Report program (R740018D) to generate the Belgium Intracommunity °n 723 report, the system populates the VAT History Listing (F74B250) and Yearly/Quarterly VAT Listing (F74B200) tables with information about the transactions for the current reporting period. It also reads the tables to obtain information about modified or new records from previous reporting periods, and includes the modified or new records as corrections in the current report.

For example, suppose that you run the VAT European Sales List Report program in January and your client transactions indicate that Client A has transactions totaling 1000 euros. The system populates the F74B250 and F74B200 tables with that information when you run the program for January, and generates the XML file that you submit to the tax authorities for January. In your January XML file, the transactions have a transaction nature code of L. Suppose that prior to running the report for February, you discover that transactions totaling 800 euros were correctly coded as L, but transactions totaling 200 euros should have been reported with a transaction nature code of S.

You can use the History VAT Listing Corrections program (P74B250) to modify the incorrect records for January. In this example, when you modify the incorrect records for Client A records, you change the transaction nature code for the appropriate amount and save the modified record. When you save the record, the program writes a value of 1 to the Correcting Period Flag field in the F74B250 table. When you run version XJDE0002 of the R740018D program for February, the system populates the F74B250 table with the transactions for February. It also reads the F74B250 table to identify the records with a value of 1, and includes the corresponding records from the F74B250 table in the February report and XML. The corrected records are also written to the Quarterly VAT Report (R74B300). The R74B300 report includes a column that identifies which records are corrections, and provides a total of the corrected-record amounts.

When you access the History VAT Listing Corrections program, the Work with History VAT Listing form displays the records that the R740018D program wrote to the F74B250 table. You can search for and select the records that you need to correct. You can change only the taxable amount and transaction nature code. When you click OK, the system marks the record in the F74B250 table as changed, and also modifies the record in the R74B200 table if you modified the amount. When you next run the R740018D program for Belgium, the program writes the corrected record to the R74B300 report and to the XML file that you generate for the current period.

Note: Set the Proof/Final Mode processing option on the Belgium tab to update the F74B250 table with records for the current period, and to cause the system to mark corrected records from previous periods as processed.