Intrastat export

The purpose of this procedure is to be able to create a report for IntrastatClosed Intrastat is the system which gathers statistics relating to trade in products within the European Union. Gathering of Intrastat statistics is handled in the same way by all EU member states. export. Data can be exported according to a fixed format that can be sent to the affected authority. In the procedure you can make additions/adjustments in the report. Additions and adjustments are saved in a separate table in the database.

Intrastat export is based on statistics loaded from the invoicing log (invoices), delivery log (stock orders), manufacturing order log (shipment records for subcontract), and adjustment log for Intrastat. This procedure considers warehouses.

In order to include values in the report, the following is required:

  • The part must have a CN code that is configured to be reported in the Intrastat report.
  • The country in the delivery address must be within EU. Your own country will not be taken into consideration. Please remember that your country is loaded from the delivery address for the selected warehouse. That is, if you are logged in to a warehouse in Denmark (DK), then data will be loaded from all EU countries except for Denmark (DK).

Read more under Using Monitor about Intrastat and the related settings.

In systems with the Customer order transfer option installed, the customer's VAT registration number from the sales company's order is copied to the order in the production company, if delivery should take place from there directly to the end customer.

The VAT registration number on the customer order is then used in the Intrastat report to provide a correct result.

  1. Make a selection by date
  2. Load the list
  3. Check the outcome
  4. Adjust/add records
  5. Save
  6. Print or export the list via the Export button
If it is not possible to load the list, it might be because settings are missing. If that is the case, you will see a text under Settings letting you know which settings are missing and in which procedure you can adjust them.

In a list procedure there is always a tab called Selection where you can select data records in different intervals from the database. The data records are then loaded by using the Load button in the toolbar of the procedure.

Under Selection rows in the backstage of the procedure, you can choose which selection rows that each list type should have, under the Selection tab in the procedure. In the List type field you select for which list type you want to customize the selection rows.

One table shows selection rows possible to select and one one table shows the selected selection rows. You can add, delete, or move selection rows by dragging and dropping the selection rows with your mouse pointer.

Using the Save button you save the selected selection rows.

Read more about this in the Selection topic.