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 Sales 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 Invoices (UK)’ (described here).
When you design the Form Template to be used by the Intrastat S/L form, the fields that you can use fall into two broad categories—
You can use the fields listed below when you design the Form Template to be used by the Intrastat S/L form. If you do not want to print the decimal places in numeric fields, choose the Cut Decimals option in the record in the
setting.
| Field in Form | 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, 22/12/2014 will be printed as “22 December 2014”. 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 22/12/2014 will be printed as “22” |
| 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 22/12/2014 will be printed as “12” |
| 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 22/12/2014 will be printed as “2014” |
| |
| 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 each Invoice |
| Country Code | Country from the Contact records for each Customer |
| Country of Origin | The third line of the Address in the Default Source specified in each Item record |
| Currency | Currency from each Invoice |
| Delivery Mode | Delivery Mode from each Invoice |
| Delivery Term | Delivery Term from each Invoice |
| EKN code | EKN Code from each Item record |
| FOB Value, Local | Sum of (Sum from each Invoice row / Subtotal * Statistical Value) i.e. total value for each Item/Currency/Country/Country of Origin/Delivery Mode/Delivery Terms/Invoice Type combination, in Base Currency 1 (converted using the exchange rate in the Invoice), expressed as a proportion of the sum of the Statistical Values from each Invoice |
| FOB Value, foreign Currency | Sum of (Sum from each Invoice row / Subtotal * Statistical Value) i.e. total value for each Item/Currency/Country/Country of Origin/Delivery Mode/Delivery Terms/Invoice Type combination, in the Invoice Currency, expressed as a proportion of the sum of the Statistical Values from each Invoice |
| Invoice Type | Prints “16” for Credit Notes, “111” for POS Invoices (these will only be included if you select the Include POS Invoices option in the specification window) 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 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 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 Sums from each Invoice row i.e. total value for each Item/Currency/Country/Country of Origin/Delivery Mode/Delivery Terms/Invoice Type combination, in the Invoice Currency. Rounding will depend on the option chosen in the specification window |
| Total in Base Currency 1, row | Sum of the Sums from each Invoice row i.e. total value for each Item/Currency/Country/Country of Origin/Delivery Mode/Delivery Terms/Invoice Type combination, in Base Currency 1 (converted using the exchange rate in the Invoice) |
| Transaction Number | Number of 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 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.
Introduction to Forms in the Sales Ledger
