EC Sales List 

Use

In the Netherlands, companies can use the generic report EC Sales List in Data Medium Exchange Format (RFASLD20) to create their ICL notifications. According to legal requirements, Dutch companies have to submit their ICL notifications to the tax office electronically. The generic report EC Sales List in Data Medium Exchange Format (RFASLD20) and the report Administration Report Electronic Data Transmission to Authorities (FOT_B2A_ADMIN) contain country-specific features for the Netherlands that enable you to generate an electronic file with the required information, in accordance with tax office regulations.

Prerequisites

In order to report the information necessary to meet legal requirements in the Netherlands, you have to first carry out the following IMG activities in Customizing for Financial Accounting:

       1.      Define your Dutch company code as the reported unit for the EC sales list in data medium exchange format by assigning your Dutch company code as the dominant company code for the taxes on sales/purchases group, by choosing General Ledger Accounting ® Business Transactions ® Closing ® Reporting ® Sales/Purchases Tax Returns ® Define Tax on Sales/Purchases Groups.

       2.      Make the relevant settings for electronic communication with authorities, by choosing General Ledger Accounting ® Business Transactions ® Closing ® Reporting ® Electronic Communication with Authorities ® Make Settings for Electronic Communication with Authorities. Enter the required information for your Dutch company code. In the Settings Electronic data Transmission dialog box, set the technical mode of transfer in the Transf.Type field to Download (no transmission) and choose the required reporting period.

       3.      Define the parameter values for the standard parameters that are delivered for Dutch company codes for electronic communication with authorities, by choosing General Ledger Accounting ® Business Transactions ® Closing ® Reporting ® Electronic Communication with Authorities ® Define Parameters for Electronic Communication with Authorities. Enter the DMEE tree NL_EC_SALES_XML in the VAT Return DMEE Tree field, unless you need to enhance the XML file format for a specific company requirement. In this case, make a copy of the DMEE tree NL_EC_SALES_XML, enhance it, and enter the new format tree name here.

Activities

1.       Run the report EC Sales List in Data Medium Exchange Format (RFASLD20) from the SAP Easy Access screen, by choosing Accounting ® Financial Accounting ® General Ledger ® Reporting ® EC Sales List ® General  ® EC Sales List in Data Medium Exchange Format.

The report selects and groups all relevant tax codes in accordance with the tax office regulations, as defined in your Customizing settings, and stores them on the database.

2.       Run the report Administration Report Electronic Data Transmission to Authorities (FOT_B2A_ADMIN), from the SAP Easy Access screen, by choosing Accounting ® Financial Accounting ® General Ledger ®Reporting ® Electronic Communication with Authorities ®Administration Report Data Transmission.

The report selects the information required for the output file, as defined in your Customizing settings. You can generate an XML file for the VAT return by selecting the line containing the period that you want to declare and choosing the Download icon or Send  ® Download. The system generates the XML file in accordance with the official format specifications from the tax authority, using the delivered DME tree format NL_EC_SALES_XML, unless you have specified a different format in your Customizing Settings. You can then download the file to the presentation server by choosing XML ®Download, and subsequently send it to the tax office.

Finally, you have to set the status of return to indicate that the processing of this period is finished. To do this, select the line containing the period declared and choose Edit ® Status of Return ® Never Send Return. The status then changes to Completed; Not Sent. Note that after you have set this status, it is not possible to generate an XML file.

Note that the generation of correction files is not supported.

 

For more information, see SAP Notes 820684, 899851, and 820687.