Collect Intrastat Transactions
Use the Collect Intrastat Transactions scheduled process to collect the cross-border trade transactions that should be reported to the appropriate Intrastat authority.
- Purchase order receipts
- Return to supplier transactions
- Sales order shipments
- Return material authorizations (RMA)
- Interorganization shipments
- Interorganization receipts
- Transfer order shipments
- Transfer order returns
- Intercompany sales order transactions
The program looks at all base transaction tables for the period for which the program is run and identifies candidates for Intrastat reporting. It collects the relevant data for these transactions according to the Country Characteristics setup and Intrastat Parameter setup for the legal reporting unit. It also retrieves the invoice data from receivables and payables for these transactions. This process also lets you validate the eligible Intrastat transactions, and errors the transactions which are missing the required attributes specified in the Country Characteristics for arrival and dispatch transactions. You can reload the transactions in Open and Verified statuses. This collects the data which wasn’t available in the prior run. As an example, the arrival transaction for a purchase order receipt is already collected while the invoice isn’t generated when this program is first run. In a few days when the payables invoice is generated, you can run the collections with the Reload parameter set to Yes which lets you collect the invoice number for the purchase order transaction.
When to Use
Use the Collect Intrastat Transactions process when you want to collect Intrastat transactions corresponding to a legal entity or legal reporting unit for a specific period or between specific dates.
Privileges Required
- Collect Intrastat Transactions (JMF_COLLECT_INTRASTAT_TRANSACTIONS_PRIV)
Specifications
| 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 |
| From Date | Optional | Date from which the Intrastat transactions need to be collected. | Date | You must provide a value for the From Date if no value is provided for the Period parameter. | N/A |
| To Date | Optional | Date until which the Intrastat transactions need to be collected. | Date | You must provide a value for the To Date if no value is provided for the Period parameter. | N/A |
| Source Transaction | Optional | Specific type of arrival or dispatch transaction. Choose All to run the process to consider all types of transactions. | Transaction | Choose All to run the process for all types of arrival or dispatch transactions. | N/A |
| Validate | Optional | Determines whether to validate the collected transactions. |
Yes No |
When Yes, the validation program is triggered. You can view the output of the validation program to identify the exceptions. | N/A |
| Reload | Optional | Determines whether to reload earlier collected data. |
Yes No |
Only transactions in Open and Verified status are reloaded. | 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 a summary of the input parameters and identifies the number of transactions which were processed and considered eligible for Intrastat reporting.
- When the process is submitted, you can use the Cancel Process button as provided by the Scheduled Processes work area.
- The Collect Intrastat Transactions process launches the Intrastat Collection Validation report when the Collect Intrastat Collections process is launched with the Validate parameter as Yes.