Belgian Intracommunity °n 723 Report

Note: You must complete the company setup for Belgium before generating the EU sales list report for Belgium. See "Setting Up Company Information for VAT Reporting in Belgium" in the JD Edwards EnterpriseOne Applications Localizations for Belgium Implementation Guide.

The Belgian Tax Authorities require periodic reports that include VAT amounts for all customers who are located in EU member countries, except Belgium. Only non-Belgian EU member customers who are invoiced during the fiscal period need to be reported. The Belgian Tax Authorities require that this information be submitted in XML format. You must run the XJDE0002 version of the report to generate the report for Belgium. This report validates the VAT number, or tax identification number, of each customer, according to the validation routines that are appropriate to each EU country.

When you run version XJDE0002 of the Data Extraction ESL program with the Report Processing processing option set to generate the report for Belgium and the Final Mode processing option set to run generate the report in final mode, the system:

  • Reads data from the F740019D and F740018O tables.

    The system populates these tables with client transaction data when you run the Data Extraction for ESL program.

  • Populates the History VAT Listing (F74B250) table with information about the VAT amounts for the current reporting period when you run the Quarterly VAT Report - Belgium Report in final mode.

    The program writes summarized amounts per declaration, customer, and transaction nature (IntraCode) to the F74B250 table. You can modify the records and include them in a future period to report corrections for the current period.

  • Runs the Quarterly VAT Report (R74B300) program if you have set the processing option to do so.

    The R74B300 report includes a column for corrections to previously reported records. The report also includes a total amount of the corrected records. You can customize this report to include additional information.

    You can also run this report manually by selecting a menu option.

  • Generates an XML file in the format required by the Belgian tax authorities.

    The process uses the Oracle BI Publisher for JD Edwards EnterpriseOne function to generate the XML file.

    See Viewing Report Output Generated by BI Publisher for JD Edwards EnterpriseOne.

  • Generates a cover letter that you can send with the XML file.

    Note that the cover letter is printed in English. You must provide your own translation for the letter.

The process validates the VAT number or Tax Identification number of each customer according to the validation routine appropriate to each EU country.

The system validates the reports when they are submitted. If it encounters an incorrect VAT number, the first page of the report output will describe the number and type of errors encountered.

The system stores the VAT number, or Tax Identification number, in the TaxID field (alias TAX) of the Address Book Master table (F0101). This information is extracted to the Data extraction ESL table (F740018D) when you run the Data Extractions for ESL program (R740018A). If invalid VAT numbers are associated with customer records, then you must correct the numbers and rerun the report to avoid a government-assessed penalty.

For some customers, such as recognized health care providers, you might not have a VAT number. If you do not know a VAT number, enter 99_unknown or 99_onbekend in the VAT/Tax ID field.