1. Home
  2. /
  3. User Guides
  4. /
  5. Distribution
  6. /
  7. EU Reporting
  8. /
  9. EU order handling
  10. /
  11. Selling goods to EU...
  12. /
  13. Print the Intrastat detail...

Print the Intrastat detail list for delivered goods

Related topics

This printout displays all detailed transactions in the EU statistics file. This printout is not mandatory, but it could be useful if you want to check the final Intrastat declaration. Note: The Intrastat detail list is an internal printout, i.e. the list is not sent to the local Customs and Excise Department.

To exemplify, assume the following applies:

  • Goods were delivered from Sweden.
  • Goods were received in Germany.
  1. Select the Print Intrastat details menu item.
  2. You access EU INTRASTAT detail list printout.
    3. Sequence
    Define the sequence in which the system should print the detail list. For example, 1 for Commodity code and 2 for Invoice number.

    Click OK.

  3. You access the second EU INTRASTAT detail list printout panel.
    4. Selection
    In the fields below you can make selections, if you only want to print certain transactions. For example, if you want the system to select transactions for goods delivered from Sweden with commodity code 123456789, do as follows:

    In the Country field, enter 1 in the first input field and SE in the second. In the Commodity code field, enter 1 in the first input field and the mentioned commodity code in the second.

    Click OK.

  4. You access the third EU INTRASTAT detail list printout panel.
    5. System currency
    Indicate if you want to print the list in system currency.
    VAT reporting curr
    Indicate if you want to print the list in VAT reporting currency, i.e. the currency defined for VAT reporting for the country of trader (in this example country SE).
    Transaction currency
    Indicate if you want to print the list in transaction currency, i.e. the currency defined on the sales order.

    Note: You can only select one currency.

    Subtotals
    Indicate if you want the system to print sub-totals for each selected sequence.
    Transl to EU codes
    Set to YES if you want the system to translate different codes to EU format, for example Terms of delivery codes, Manner of transport codes etc,.
    Set to NO if you want the system to print the codes in “normal” system format.

    Click OK.

    Explanation of printout

    The following column headings are printed:

    Tc
    Trader country. In this example SE.
    Stprc
    Statistical procedure.
    Cust/suppl
    Debtor number.
    Vt
    The voucher type.
    Dt
    Document type. Normally this is DMI for invoices from Distribution and DMC for Credit notes.
    Invoice
    Invoice number
    Order
    Sales order number.
    Invdt
    Invoice date.
    Ctry
    Country of destination. For this example the goods were delivered to a customer in Germany.
    Dp
    Department of the delivering warehouse.
    Port
    Port of dispatch. Not used in this example since you do not have to declare port of dispatch in the INTRASTAT for Sweden.
    Orig
    Country of origin.
    MOT
    Manner of transport code. If you set the Transl to EU codes field to YES (step 4), this field will display the code in EU format. If you set that field to NO, this field will display the code in normal system format.
    NOT
    Nature of transaction code.
    TOD
    Terms of delivery code. If you set the Transl to EU codes field to YES (step 4), this field will display the code in EU format. If you set that field to NO, this field will display the code in normal system format.
    Commodity code
    Commodity code.
    Quantity
    Total quantity on the invoice.
    Report quantity
    The total quantity on the invoice, recalculated in reporting units.
    Assume the reporting unit for commodity code 123456789 is LITRE.
    The reporting quantity is calculated as:
    Quantity * conversion factor in Commodity code table
    Unit
    The reporting unit. In this example LITRE.
    Ancillary cost
    Any ancillary cost, displayed in the currency you selected in step 4. A total sum of the ancillary cost is displayed at the bottom of the printout. See Border value table for more information about these costs.
    Total invoice value. The invoice value is displayed in the currency you selected in step 4.
    The value is calculated as:
    Amount in Transaction currency: Sales price on order line * Quantity
    Amount in Base currency: Amount in transaction currency * Exchange rate for transaction currency
    Amount in System currency: Amount in Base currency / Exchange rate for System currency
    Note: A total sum of the value is displayed on the bottom of the printout.
    Curr
    Displays the currency you selected in step 4. Both the Ancillary cost and Value are displayed in this currency.

Related topics