The application allows you to prepare the information to be declared.
The process is as follows:
The extraction function is used to complete the first step of the process: it is used to extract the data of the customer and supplier flows.
Refer to documentation Implementation
Presentation
Enter the value of the Regeneration field.
Close
Fields
The following fields are present on this tab :
Selection criteria
| Use this indicator to specify if the lines that have been processed must be regenerated in the Intrastat table.
|
| This number is assigned automatically during the launching of a new generation of the DEB table. |
| Enter the company for the report. |
| Date at which the entries are not taken into account anymore. |
| This field can not be entered by the user: this must be the introduction and shipment flows. |
Block number 2
| If the box is checked, a purging of records in the Intrastat table, for the selected company and flow, will be processed before the execution of the Intrastat declaration process. |
| This box, when checked, is used to display documents which value is null and that have not been extracted. |
| This box, when checked, is used to display documents which nature and rule are not entered and have not been extracted. |
|   |
| Select this check box to display, in the generated detailed log file, the entries whose flows have not been extracted because of the EU country withdrawal date. |
Close
Click OK to start the extraction. A log file detailing the extracted movements is displayed.
In the database, the EECNUMDEB field displayed on entries is populated with:
The declaration relates to all undeclared movements that are prior to the declaration date. If you start processing the Intrastat declaration from a given date, make sure to first perform a 'blank' declaration so that the movements prior to this date, which must not be included, are correctly identified.
Managing the withdrawal of an EU member state:
The declaration takes into account the withdrawal date from the European Union of this state, entered at the Country function level: an intrastat flow between this state and the other member states is only extracted if the flow date is less than the release date.
You can still display the list of entries whose flows have not been extracted because of the entered withdrawal date. To display this list is the log file generated when the processing is complete, select the option Display document if country left the EU.
The valuation information from the invoices linked to documents included in the flows is considered, even if the invoice date is later than the document extraction date.
The processed documents are described below. The other documents will have to be processed manually. Because of the many specificities that may exist, the general rules used by the extraction can be amended using an entry point, or manual corrections can be applied if only few exceptions are involved (which is usually true).
Upon arrival (receipt), the following documents are processed:
Upon dispatch (shipment), the following documents are processed:
The following conditions must be met so that the information linked to the flows can be extracted:
Management of flows coming from deliveries:
Declaration level
The declaration levels on import and on shipment are defined by the following Common Data parameters: NIVINT - Import declaration level and NIVEXP - Shipment declaration level.
Currency rate
According to the texts, the determination of the currency exchange rates (for currencies that are out of the Euro, that is to say the Swedish Krona, British pound sterling at the time of producing this document) is subject to numerous interpretations (it is possible to use a fixed exchange rate defined monthly or the rate on a date ). Use the EECTYPCUR - EU currency rate type parameter to take into account manually defined exchange rates easily. This type of exchange is used for the DEB conversion, each document being converted for the date of the document. You can get all the required setup types by defining a single exchange rate (at the start of the month) or several exchange rates (up to one by day and exchange rate type).
Reminder: Exchange rate types can be defined from the local menu number 202.
The information necessary for Intrastat is extracted from the documents identified above.
The information linked to the flow itself is stored in the document header. The default values are defined using tables that must be defined beforehand. The detail is given below:
Information | Default value | Table used for the control |
Storage site | Journal site | |
Storage site country | Journal site country | |
Customs reference | Recovered from the corresponding field in the Product record. | EU commodity code table |
Country code | Determined by using the EU country code found in the country associated with the delivery address of the line. | |
EU rule | This rule is based on the setup of the Movement rules and natures table. | Miscellaneous table no. 15 for Intrastat rules |
Transaction Nature | The transaction nature (type) is based on the setup of the Movement rules and natures table. | Miscellaneous table no. 6 for Intrastat transaction natures |
EEC transport method | Defined from the information given in table Delivery modes | Local menu 237 |
EEC transport location | Defined from the information given in the ship-to customer record or supplier record. This information is provided by default at the time of creation of the record from the Delivery methods table. | Local menu 236 |
INCOTERM | Defined from the information given in the ship-to customer record or supplier record. This information is provided by default at the time of creation of the record from the Delivery methods table. | Miscellaneous table no. 5 for Incoterms |
Department | Assigned by taking the first two characters of the postcode linked to the default address for the shipment or the receipt site of the line. | |
Federal state Region | Entered using the Region/State code specified in the Product-site record, otherwise the Product record. | Miscellaneous table 80 for Regions/Sates. |
Quantity in EU unit | The EU unit defined in the product record - if it exists - is used; the quantity is then converted into this unit. | |
Net mass | Produced by looking for a weight unit named KG that has a conversion rule available with the product unit. The conversion is then carried out. If this is not possible, the weight is left blank. | |
Financial value | This value is calculated based on the line tax-excluding net value, to which the invoicing elements are added so they can be included in the calculation of the fiscal value. These elements are distributed according to the setup of their distribution on the lines. The elements that are not distributed on the lines are distributed pro rata to the amounts of the line with respect to the document total (if the document is not equal to 0). | |
Statistical value | This value is calculated by applying to the fiscal value (except invoicing elements) the EU increase coefficient defined in the ship-to customer record or supplier record and then adding the invoicing elements (distributed or not in proportion to the line amount). |
Notes:
This function can be run in batch mode. The standard task FUNDEB is provided for that purpose.
In addition to the generic error messages, the following messages can appear during the entry :
An Intrastat matching these parameters has already been performed
You have attempted to relaunch an Intrastat that has already been performed for the same flow, same company and the same date.