Export Intrastat Collections

Use the Export Intrastat Collections scheduled process to create a file with all the necessary data for you to make legal declarations through electronic means to the Intrastat authority for a particular period.

The report exports all Intrastat transactions in a Reported status and updates the status of the Intrastat transactions to Exported. You can’t modify the data once the transactions are in the Exported status. The scheduled process creates a csv file with all the Intrastat transactions for a specific period.

When to Use

Use the Export Intrastat Collections process when you want to generate the export file with all the necessary data for you to make a legal declaration to the Intrastat authority for a specific period.

Privileges Required

  • Export Intrastat Transactions (JMF_EXPORT_INTRASTAT_TRANSACTIONS_PRIV)

Specifications

Review the following before setting up this scheduled process:
Specification Description
Job Type Ad hoc job

Scheduled

Frequency As required, usually run at the end of the general ledger period when the declaration for the Intrastat transactions is submitted to the regulatory authority.
Time of Day Any time.
Duration The process should complete within a few minutes if there are few transactions. It could take up to an hour if the transaction volume is very large.
Compatibility There can be multiple instances of the process running for different legal reporting units, but it's recommended to schedule the process so that only one instance of the process is running at a time.

Parameters

Parameter Optional or Required Description Parameter Values Special Combinations Required Notes
Legal Entity Required Name of the legal entity for which you want to run the collections. Legal entity None N/A
Legal Reporting Unit Optional Name of the legal reporting unit associated with a legal entity. Legal reporting unit None N/A
Period Optional Period during which the Intrastat transactions need to be collected. Period You must provide a value for the Period if no values are provided for the From Date and To Date parameters. N/A
Flow Type Optional Select an option for the flow type. If you don’t select an option, the program uses all flow types. Select the specific type of transaction to be collected:
  • Arrival
  • Arrival adjustment
  • Dispatch
  • Dispatch adjustment
Leave this field blank to let the program run for all flow types. N/A
Report Reference Optional Reference number for Intrastat report.

Reference number

You don't need to provide a value for this parameter. N/A

Troubleshooting Information

  • You can view the status of the process in the Scheduled Processes work area.
  • Once the process is complete, it will have a log file and an output file.
  • The output file provides details of the Intrastat transactions which have been exported for a legal reporting unit. The output file is blank if all the Intrastat transactions for a period aren't in the Verified status.
  • When the process is submitted, you can use the Cancel Process button as provided by the Scheduled Processes work area.