Process Intrastat Transactions (tccom7271m000)

Use this session to create an export file of the Intrastat declaration data.

Note: When the Intrastat declaration data is processed, the intrastat file is created with declaration values. When this data is processed, the declaration amounts are expressed in the declaration currency.

You can further process the export file with an external Intrastat application.

You can generate the following types of files:

  • A sequential Import/Export IRIS file.
  • A sequential Import IDEP file.
  • A sequential Export IDEP file.
  • An XML file that you can directly transfer to the Intrastat collection center.

To regenerate the previous export file, you can select the Including Processed Lines check box. In this case you must enter the same selection ranges and dates that you entered previously.

When you export the data, LN recalculates the goods amounts in the local currency using the sales exchange-rate or the internal exchange-rate calculations as applicable. If you wish to first validate the output file, you can select the Simulate check box.

Click the Continue button to generate the export file. If the Simulate check box is cleared, LN marks the records as Processed.

LN generates the file in the $BSE/tmp directory on the LN server. The generated filename starts with 'tmp'.

If you use an Intrastat declaration application which runs on your PC (the client), in addition the Save As dialog is displayed which you can use to store the export file locally on your PC. As a result, the export file is stored both on the server and on your PC.

Field Information

Pathname

The path and name of the export file on the LN server.

Declaration

If you select the range of offices for the export file, this field displays the financial company, the country, and the VAT number for which the export file is generated.

Selection
Company

Indicate whether you want to process Intrastat transactions for a single company or for multiple companies.

Allowed values

One Company
Multiple Companies
Financial Company

The financial company in which the intrastat transactions are processed.

Note: This field is enabled only if the Company field is set to One Company.
Company Set

The financial company set associated with the intrastat transactions.

Note: This field is enabled only if the Company field is set to Multiple Companies.
Own Identification Number

The own identification number associated with the intrastat transaction that must be processed.

Note: 

This field is enabled only if the Extended Registration Management field is other than Active in the Global Registration Parameters (tctax2100m000) session.

This field is enabled only if the Declaration Country is specified.

Flow

Select the goods flows (import or export) for which you export the data.

Note: Separate Intrastat declarations are required for the import flow and the export flow. For the import flow, select (+) Receipt and for the export flow, select (-) Issue.
Use Monthly Period

If this check box is selected, you can set the year and month to create an export file of the Intrastat declaration data in this specified period.

Year

The fiscal year to which the financial transactions are linked.

Month

Select the month.

Allowed values

January
October
Not Applicable
November
December
February
March
April
May
June
July
August
September
Selection Range
Enterprise Unit

The From and To fields define a range of: enterprise units for which you export the data.

Entity Type

The From and To fields define a range of: entities for which you export the data.

Office

The From and To fields define a range of: sales departments or purchase departments for which you export the data.

Select a purchase office or a sales office or a range of offices that all belong to the financial company for which you want to create the Intrastat declaration.

If the offices are linked to multiple financial companies, LN displays an error message.

Declaration Country

The country in which the Intrastat declaration is submitted.

Note: 
  • You can specify a declaration country if Multiple Jurisdictions by Registration check box is selected in the Global Registration Parameters (tctax2100m000) session, for a specific financial company.
  • This field is enabled only if the Registration by Tax Country field is set to Active in the Global Registration Parameters (tctax2100m000) session.
Tax Currency

The currency in which the tax transactions are reported in the specific country.

Order Origin

The From and To fields define a range of: order origins for which you export the data.

To export the data for the full range of order origins, keep the default field values (from Sales Order to Purchase Schedule).

Order

The From and To fields define a range of: orders for which you export the data.

Position

The From and To fields define a range of: line positions in the selected range of orders for which you export the data.

Sequence No.

The From and To fields define a range of: line sequence numbers in the selected range of orders for which you export the data.

Transaction Date

The From and To fields define the period for which you export the data.

The records that you exported for the previous declaration now have the Processed status.

To export the data collected during the period since the previous declaration, you can enter the following data:

  • Leave the Transaction Date From field empty.
  • Clear the Including Processed Lines check box.
  • In the Transaction Date To field, enter the end date of the period for which you want to create the Intrastat declaration.
Processing
Options
Including Processed Lines

If this check box is selected, transactions that were already processed earlier are included in the export file.

For example, you can select this check box to regenerate the previous export file if necessary. You must enter the same selection ranges and dates that you entered previously.

Simulate

If this check box is selected, LN generates the export file in the regular way but does not set the Intrastat transaction lines to Processed.

You can use this feature to generate a trial export file before you generate the final export file.

Recalculate Amounts with Declarant Exchange Rates

If this check box is selected, LN recalculates the amounts bases on the exchange rate type specified in the Declarant Exchange Rate Type field.

Declarant Exchange Rate Type

The exchange rate type based on which the declaration amounts are recalculated.

Note: This field is enabled only if the Recalculate Amounts with Declarant Exchange Rates check box is selected.
Allow exporting in Transaction Currencies

If this check box is selected, and if conversion to the local currency is not possible, for example, because no currency rate is available, LN enters the amounts on the report in the transaction currency.

If the authorities permit you to transfer the Intrastat declaration amounts in the transaction currencies, you can select this check box. Usually, you can still convert the amounts in the IDEP application.

Ignore zero quantities

If this check box is selected, LN ignores zero quantities.

Reference Period

You can use this field to indicate the period in which you made the declaration.

For example, you can enter 2015-3 to indicate March 2015 or 2015 Q1 to indicate the first quarter of 2015.

Use Defaults for Business Partners without Effective VAT Number when

If this check box is selected, the user can define the codes to be used in the Empty, Temporary or Empty (Triangular) fields.

Empty

The default business partner identification number to be used when the business partner identification number is blank for the partner country.

Note: 

This value is defaulted from the Empty field in the Intrastat Parameters (tccom7100s000) session or the Intrastat Parameters by Country (tccom7107m000) session.

This field is enabled only if the Use Defaults for Business Partners without Effective VAT Number when check box is selected.

Temporary

The default business partner identification number to be used when the business partner identification number is a temporary value or used for information, for the partner country.

Note: 

This value is defaulted from the Temporary field in the Intrastat Parameters (tccom7100s000) session or the Intrastat Parameters by Country (tccom7107m000) session.

This field is enabled only if the Use Defaults for Business Partners without Effective VAT Number when check box is selected.

Empty (Triangular)

The ID that must be used as a business partner identification number if the same is not available in the ship-to country and the ship-to country is different from the business partner tax country.

Allowed values

BP ID - Sold-to/Buy-from Country
Fictitious ID - Sold-to/Buy-from Country
Not Applicable
Default for Empty BP ID
Default for Temporary BP ID
Note: 

This value is defaulted from the Empty (Triangular) field in the Intrastat Parameters (tccom7100s000) session or the Intrastat Parameters by Country (tccom7107m000) session.

This field is enabled only if the Use Defaults for Business Partners without Effective VAT Number when check box is selected.

File Data Format
File Data Format

The type of file you want to generate.

  • To generate an XML file that you can directly transfer to the Intrastat collection center, select XML.
  • To generate a sequential IDEP file select CSV.
  • To generate a sequential IRIS file, select CSV and clear the Header and the Squeeze Field check boxes.
CSV output
Header

If this check box is selected, the generated export file contains a header with the column names.

A comma separated (CSV) file can have a header containing the field names. If you generate a sequential IDEP file, you can select this check box.

To create a fixed length export file, for example, to process with IRIS, you must clear this check box.

Squeeze Field

If this check box is selected, leading spaces and leading zeroes are suppressed in the export file.

To create a fixed length (positional) export file, for example, to process with IRIS, you must clear this check box.

If you select this check box, LN stores the quantity and the inventory unit of the item in the Intrastat declaration file.

Separator

The character that separates the columns of the CSV file. It is recommended that you use a semicolon (;) as the delimiter, because the comma (,) can also be part of the data.

XML output
Export in Local Character Set of User

If this check box is selected, the file created in XML output is exported in the identification set by the user.

Note: , This checkbox is enabled, if the File Data Format is set to XML.
Envelope ID

An identification of the document

If the File Data Format is XML, you must supply the data as prescribed by the local tax authorities.

Declaration ID

A kind of sequence number of the declaration.

If the File Data Format is XML, you must supply the data as prescribed by the local tax authorities.

Previous Declaration ID

The declaration ID of the previous declaration.

If the File Data Format is XML, you must supply the data as prescribed by the local tax authorities.

Declaration Type Code

The code for the type of declaration prescribed by the authorities.

For example, the declaration type can be Detailed Return, or Simplified Return.

Note: 
  • You cannot use the Intrastat data logged in LN to submit a Fiscal Return declaration because in LN the sales listing is used for VAT returns.
  • If the File Data Format is XML, you must supply the data as prescribed by the local authorities.
Function Code

The function code of the declaration prescribed by the authorities.

For example, the function code can be Original, or Nil Return if no intracommunity trade took place during the declaration period.

Note: 
  • You cannot use the Intrastat data logged in LN to submit a Correction declaration.
  • If the File Data Format is XML, you must supply the data as prescribed by the local tax authorities.
Related topics