Country origin for Intrastat reports

The Intrastat report requires that the source country in the Product transaction table is updated.

Products with the same source country

For products that always have the same source country, you can update the Source country field for each product in the Product table.

This will make it possible to extract records from the Product transaction table grouped by Source country.

Products with different source countries

For products that have different source countries, you can extract Product transaction per Source country and per Shipment,under the following conditions:

  • The Delivery alternative table is updated concerning all possible combinations of Product no., Sup. no. and Source country
  • The Keep shipments option in the Order processing 2 dialog in the Company information table is selected
  • Each supplier provides goods from the same source country

This is possible since the Shipment no. exists in the Product transaction table, and the Sup. no. exists in the Shipment table, and the combination of Sup. no., Product no.. and Source country is given in the Delivery alternative table.