Intrastat Jnl. Batch Table

Specifies how all EU businesses must report their trade with other EU countries/regions for Intrastat reporting.

You can use the Intrastat Journal window for this reporting. You can either enter the entries in the window yourself, or you can have the program import them automatically by clicking Actions, Get Entries in the intrastat journal window. When you do this, the program imports only entries from the Item Ledger Entry table. If you have some G/L entries that should be included in the Intrastat report (for example purchase of office equipment for your own use from another EU country/region), you must enter these entries yourself.

In order for item entries to contain the necessary information when the program imports them to the intrastat journal line, you must have entered that information in the following tables:

Country/Region

Tariff Number

Transport Method

Transaction Type.

You must fill in these tables before you begin to post.

Before you can use the Intrastat Journal window, you must decide which intrastat journal templates and batches you will use. You do this in the Intrastat Jnl. Template and Intrastat Jnl. Batches windows.

In the Intrastat Jnl. Batches window, you can create several names based on each intrastat journal template. Because Intrastat is reported monthly, you must create 12 intrastat names. Use names that identify the month that the report covers, for example:

Jan, Feb, Mar

If you need several different intrastat journal templates, for example for more types of forms, you must set up the templates in the Intrastat Jnl. Template window. The information for Intrastat reporting itself is entered in the Intrastat Journal window.

List of Fields in the Table

Field Location
File Disk No. Field, Intrastat Jnl. Batch Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
EU Service Field, Intrastat Jnl. Batch Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Currency Identifier Field, Intrastat Jnl. Batch Table Germany Local Functionality
Dispatches Reported Field, Intrastat Jnl. Batch Table United Kingdom Local Functionality
Arrivals Reported Field, Intrastat Jnl. Batch Table United Kingdom Local Functionality
Corrective Entry Field, Intrastat Jnl. Batch Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Periodicity Field, Intrastat Jnl. Batch Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
Type Field, Intrastat Jnl. Batch Table Italian Local Functionality Tables, Reports, Batch Jobs, and Windows
System 19 reported Field, Intrastat Jnl. Batch Table Belgium Local Functionality
System 29 reported Field, Intrastat Jnl. Batch Table Belgium Local Functionality
Reported Receipt Field, Intrastat Jnl. Batch Table Finland Local Functionality
Reported Shipment Field, Intrastat Jnl. Batch Table Finland Local Functionality
Export Time Field, Intrastat Jnl. Batch Table Netherlands Local Functionality
Export Date Field, Intrastat Jnl. Batch Table Netherlands Local Functionality
File Disk No. Field, Intrastat Jnl. Batch Table Italy Local Functionality
Name Field, Intrastat Jnl. Batch Table General Ledger
Statistics Period Field, Intrastat Jnl. Batch Table General Ledger
Amounts in Add. Currency Field, Intrastat Jnl. Batch Table General Ledger
Periodicity Field, Intrastat Jnl. Batch Table Italy Local Functionality
Journal Template Name Field, Intrastat Jnl. Batch Table General Ledger
Export Time Field, Intrastat Jnl. Batch Table Netherlands Local Functionality
Export Date Field, Intrastat Jnl. Batch Table Netherlands Local Functionality
Type Field, Intrastat Jnl. Batch Table Italy Local Functionality
Description Field, Intrastat Jnl. Batch Table General Ledger
Currency Identifier Field, Intrastat Jnl. Batch Table General Ledger
Reported Field, Intrastat Jnl. Batch Table General Ledger
Name Field, Intrastat Jnl. Batch Table General Ledger
Statistics Period Field, Intrastat Jnl. Batch Table General Ledger
Amounts in Add. Currency Field, Intrastat Jnl. Batch Table General Ledger
Journal Template Name Field, Intrastat Jnl. Batch Table General Ledger
Description Field, Intrastat Jnl. Batch Table General Ledger
Currency Identifier Field, Intrastat Jnl. Batch Table General Ledger
Reported Field, Intrastat Jnl. Batch Table General Ledger
Name Field, Intrastat Jnl. Batch Table General Ledger
Statistics Period Field, Intrastat Jnl. Batch Table General Ledger
Amounts in Add. Currency Field, Intrastat Jnl. Batch Table General Ledger
Journal Template Name Field, Intrastat Jnl. Batch Table General Ledger
Description Field, Intrastat Jnl. Batch Table General Ledger
Currency Identifier Field, Intrastat Jnl. Batch Table General Ledger
Reported Field, Intrastat Jnl. Batch Table General Ledger
File Disk No. Field, Intrastat Jnl. Batch Table Italy Local Functionality
Export Time Field, Intrastat Jnl. Batch Table Netherlands Local Functionality
Export Date Field, Intrastat Jnl. Batch Table Netherlands Local Functionality
Periodicity Field, Intrastat Jnl. Batch Table Italy Local Functionality
Type Field, Intrastat Jnl. Batch Table Italy Local Functionality
Name Field, Intrastat Jnl. Batch Table General Ledger
Statistics Period Field, Intrastat Jnl. Batch Table General Ledger
Amounts in Add. Currency Field, Intrastat Jnl. Batch Table General Ledger
Journal Template Name Field, Intrastat Jnl. Batch Table General Ledger
Description Field, Intrastat Jnl. Batch Table General Ledger
Currency Identifier Field, Intrastat Jnl. Batch Table General Ledger
Reported Field, Intrastat Jnl. Batch Table General Ledger
File Disk No. Field, Intrastat Jnl. Batch Table Italy Local Functionality
Export Time Field, Intrastat Jnl. Batch Table Netherlands Local Functionality
Export Date Field, Intrastat Jnl. Batch Table Netherlands Local Functionality
Periodicity Field, Intrastat Jnl. Batch Table Italy Local Functionality
Type Field, Intrastat Jnl. Batch Table Italy Local Functionality

See Also

Reference

Intrastat Jnl. Line
Intrastat Jnl. Template
Intrastat Jnl. Batches

Other Resources

Item Ledger Entry
How to: Set Up Intrastat Journal Templates and Batches