Intrastat Export Declaration to Spreadsheet - Summary Program (R74Y031) (Release 9.2 Update)

The Intrastat Export Declaration to Spreadsheet Summary report (R74Y031) runs automatically from the Generate Intrastat Services Declaration-Final Step program if you set the processing option to Y or Blank. In this case, the report runs the versions ZJDE0002, ZJDE0003, ZJDE0004, and ZJDE0005 and generates four .csv files. The report groups all the documents on the basis of VATID, Country of Payment, and Service Explanation Code in the exported spreadsheet. The R74Y031report will not display the document number, document type, method of collection, and method of supply. The ZJDE0002, ZJDE0003 versions of the report are for services vouchers or invoices (received and supplied) and the ZJDE0004, and ZJDE0005 are for adjustments (received and supplied). You can also generate the output file on demand, using the standalone Intrastat Export to Spreadsheet program. You can choose to run version ZJDE0001 that contains all four sections for Intrastat in the same file, or you may run versions ZJDE0002 to ZJDE0005 to generate all sections in separate files. You run the program to manually generate the declaration details in the required Microsoft Excel spreadsheet format. You must import this Microsoft Excel spreadsheet to the Intr@web application because the government accepts only declarations imported through Intr@web. You must change the file extension from .csv to .xls to import the file successfully to Intr@web.