The Intrastat system is used to collect statistics on the physical trade in goods (i.e. the actual movement of goods) between the various member countries of the European Union (EU). If your business is situated in an EU country and its trade with companies in other EU countries is greater than the threshold value, it will be necessary to send an Intrastat report periodically to the relevant authorities.
You should design the Form Template to conform to official requirements. The available fields are listed at the end of this section.
The Purchase Ledger also contains an Intrastat Export function that you can use to export this information to text files. The precise name of this function and the format of the files that it creates will depend on the VAT Law in the Company Info setting. For example, if the VAT Law is "Default", the function will be named 'Intrastat Purchase Invoices (UK)' (described here).
When you design the Form Template to be used by the Intrastat P/L form, the fields that you can use fall into two broad categories:
Listed below are the fields you can use when design the Form Template to be used by the Intrastat P/L form. If you do not want to print the decimal places in numeric fields, choose the
Field in Form Template | Prints |
| |
Header Fields (these print once per form i.e. once in each print-out) |
| |
Address 1 | First line of the Address from the Company Info setting |
Address 2 | Second line of the Address from the Company Info setting |
Address 3 | Third line of the Address from the Company Info setting |
Address 5 | Fourth line of the Address from the Company Info setting |
Address 6 | Fifth line of the Address from the Company Info setting |
Date with Month In Words | Start Date of the Period from the specification window, with the month as a word. For example, 2/1/2013 will be printed as "02 January 2013". The Date Order (e.g. day, month, year) will be taken from the Company Date and Numeric Format setting |
Day | The day from the Start Date of the Period from the specification window. For example, the day from 2/1/2013 will be printed as "2" |
End Date | End Date of the Period from the specification window |
From Contact | Person from the specification window |
Month | The month from the Start Date of the Period from the specification window. For example, the month from 2/1/2013 will be printed as "1" |
Month in words | The name of the month in the Start Date of the Period from the specification window, taken from the record in the Days and Months setting in the System module for the Language in the current user's Person record |
Number of Boxes | Number of lines printed in the form (i.e. number of Item/Currency/Country/Country of Origin/Delivery Mode/Delivery Terms/Invoice Type combinations in the form) |
Production Date | The date when the form was printed |
Subtotal in Base Currency 1 | Sum of the values in the "Total in Base Currency 1, row" row field |
Total FOB Value, Local | Sum of the values in the "FOB Value, Local" row field |
Total Quantity In | Number of lines printed in the form (i.e. number of Item/Currency/Country/Country of Origin/Delivery Mode/Delivery Terms/Invoice Type combinations in the form) |
Transaction Date | Start Date of the Period from the specification window |
Year | The year from the Start Date of the Period from the specification window. For example, the year from 2/1/2013 will be printed as "2013" |
| |
Row Fields (these print once for each Item/Currency/Country/Country of Origin/Delivery Mode/Delivery Terms/Invoice Type combination, so remember to specify a Line Height and to set the Format to "Matrix") |
| |
Comment | Comment from the Delivery Terms specified in the Purchase Orders connected to each Purchase Invoice or from the Contact records for each Supplier |
Country Code | Country from the Contact records for each Supplier |
Country of Origin | Country of O. from the Goods Receipt rows connected to each Purchase Invoice row (if you are using the Country of Origin from Goods Receipts option in the Intrastat Purchase setting) or the third line of the Address in the Default Source specified in each Item record (otherwise) |
Currency | Currency from each Purchase Invoice or, if blank, Base Currency 1 |
Delivery Mode | Delivery Mode from the Purchase Orders connected to each Purchase Invoice or Purchase Del. Mode from the Contact records for each Supplier |
Delivery Term | Delivery Terms from the Purchase Orders connected to each Purchase Invoice or Purchase Del. Terms from the Contact records for each Supplier |
EKN code | EKN Code from each Item record |
FOB Value, Local | Sum of (Amount from each Purchase Invoice row / (TOTAL - Calculated VAT) * Statistical Value) i.e. total value for each Item/Currency/Country/Country of Origin/Delivery Mode/Delivery Terms/Invoice Type combination, excluding VAT, in Base Currency 1 (converted using the exchange rate in the Purchase Invoice), expressed as a proportion of the sum of the Statistical Values from each Purchase Invoice |
FOB Value, foreign Currency | Sum of (Amount from each Purchase Invoice row / (TOTAL - Calculated VAT) * Statistical Value) i.e. total value for each Item/Currency/Country/Country of Origin/Delivery Mode/Delivery Terms/Invoice Type combination, excluding VAT, in the Purchase Invoice Currency, expressed as a proportion of the sum of the Statistical Values from each Purchase Invoice |
Invoice Type | Prints "16" for Credit Notes and "10" otherwise (i.e. for Invoices and Cash Notes) |
Item Code | No. from each Item record |
Item Code 2 | Commodity Code from each Item record |
Item Type | Description from each Item record |
Quantity | Sum of (Qty from each Purchase Invoice row * Unit Coefficient from each Item record) (if an Item has both a Unit 2 and a Unit Coefficient) or sum of (Qty from each Purchase Invoice row) (otherwise) i.e. total quantity for each Item/Currency/Country/Country of Origin/Delivery Mode/Delivery Terms/Invoice Type combination. If you use the Don't Show Qty for Weighted Items option in the specification window, this figure will only be printed if the "Weight, Item" row field prints blank. Rounding will depend on the option chosen in the specification window |
Quantity In | Line number in the form |
Row Sum | Sum of the Amounts from each Purchase Invoice row i.e. total value for each Item/Currency/Country/Country of Origin/Delivery Mode/Delivery Terms/Invoice Type combination, excluding VAT and in the Purchase Invoice Currency. Rounding will depend on the option chosen in the specification window |
Total in Base Currency 1, row | Sum of the Amounts from each Purchase Invoice row i.e. total value for each Item/Currency/Country/Country of Origin/Delivery Mode/Delivery Terms/Invoice Type combination, excluding VAT and in Base Currency 1 (converted using the exchange rate in the Purchase Invoice) |
Transaction Number | Number of Purchase Invoice rows in which the Item/Currency/Country of Origin/Delivery Mode/Delivery Terms/Invoice Type combination has been used |
Unit | Unit 2 (if an Item has both a Unit 2 and a Unit Coefficient) or Unit from each Item record |
Weight, Item | Sum of (Weight from each Item record * Qty from each Purchase Invoice row) i.e. total weight for each Item/Currency/Country/Country of Origin/Delivery Mode/Delivery Terms/Invoice Type combination. Rounding will depend on the option chosen in the specification window |
for details of the standard fields that you can also include in the Form Template.