Intrastat Extrastat reporting
Requirement
Arrivals and dispatches of goods within the EU, that is, intracommunity imports and exports, must be reported to the national statistical authorities. Reports are sent electronically. The data collection systems are named Intrastat and Extrastat.
These trade statistics must be reported by all businesses in this country over a threshold reporting limit.
This information is required for German Intrastat reporting: trade classification, value, quantity, weight, commodity code, and country of arrival or dispatch.
Monthly Intrastat should be filed at the 10th of the month following the movements.
M3 solution
Transactions are selected according to the requested selection by the trade statistics printout (CRS600). On update of transactions, an electronic file is created using Infor Localization Services GEMS. This electronic file for Intrastat or Extrastat reporting is structured and formatted according to the provided rules.
The electronic file is delivered by M3 with a country-specific message.
We recommend that you correctly configure the M3 basic data for Intrastat. Thus, when the records are created, data can be quickly checked and then reported electronically to the local German authorities.
After the Intrastat data has been checked, manual amendments might be required. In that case, unless the amendments are one-time changes, they must be reflected within the basic data. This way, the same amendments are not required the next time Intrastat records are created.
For this country version, the ‘DE - Intrastat INSTAT’ message has been adapted, as made available in Infor Localization Services GEMS, ‘VAT EU Intrastat - 100072’.
Configuration guidelines
| Program ID | Program name | Description or comment |
|---|---|---|
| TXS330 | INTRASTAT. Process Customer Orders | Create transactions for goods that are received, but not invoiced. |
| TXS340 | INTRASTAT. Process Purchase Orders | Create transactions for goods that are received, but not invoiced. |
| TXS350 | INTRASTAT. Process Distribution Orders | Create transactions for goods that are received and moved using distribution orders. |
| CRS600 | Trade Statistics. Print | Print trade statistics for the applicable report layout and with update transactions selected. |
For this country version, additional configuration should be done as outlined in the following table:
| Program ID | Program name | Description or comment |
|---|---|---|
| MNS100/G | Company. Connect Division |
Define Responsible authoritiy (2 digits), Tax decl no (11 digits, left aligned, missing digits are filled by the mapping with zeros), Reg. no extra (3 digits for separation number). If defined on warehouse level this setting will be overruled. Set flag Trade stat. |
|
Define the Art des Geschäfts needed. A full list of codes can be found on the internet by searching for “Leitfaden zur Intrahandelsstatistik“. The most common code is 11. The recommended settings are: Reason set to 3- Goods received&sent ISO County code set to 1- Mandatory Fiscal value set to 1- Mandatory Statistic value set to 1- Mandatory Net Weight set to 1- Mandatory Delivery term set to 1- Mandatory Delivery Method set to 1- Mandatory Origin country set to 1- Mandatory Buyer VAT reg no set to 1- Mandatory |
||
| MMS001/F | Item. Open | Set the Net weight |
| MMS003/E | Item. Connect Facility | Set Customs statistical number and Country of Origin |
| CRS128 | Customs Statistics Number. Open | Set INTRASTAT gen Optionally, set Supplement U/M and Conversion fact suppl. |
| CRS070 | Delivery Method. Open | Set Transp mtd TST |
| CRS065 | Delivery Term. Open |
Set Dely term INTRA. Set an adjustment value for Adj consignee or Adj consignor if needed. |
| CRS165 | Number Series. Open | Set number series type TX series to 0. |
See the Infor M3 Core Configuration Guide for Infor Localization Services GEMS for the detailed configuration guidelines for the applicable messages.