Intrastat
The standard Intrastat feature does not transfer all and only valid transactions into Intrastat journal. This results into a lot of manual work necessary to exclude/include the excess/missing transactions, often rendering a lot of errors. According to the requirements of the Czech Republic, the following improvements are needed for the Intrastat feature:
- Particular options in the Intrastat engine need to be parameterized
- Handling of supplementary measure units needs to be improved
- Calculation of Intrastat amount and statistical amounts must be improved
- The Get Intrastat Entries batch needs to be improved
- Exporting of Intrastat reports to .csv files according to local requirements
This feature adds improvement of data transferred into Intrastat journal and prepares the environment for correct Intrastat reporting.
Intrastat Engine Setup
Additional Intrastat engine general parameters setup allows to:
- Set mandatory fields of Intrastat transactions in sales, purchase, and transfer transaction
- Set where the particular parts on Intrastat data related to items should be taken from (item or posted entry) and which item attributes will be mandatory in sales, purchase, and transfer transaction
- Set if any item charges related to sales, purchase, and transfer transaction will be ignored by the system (i.e. not including them in Intrastat or statistical amounts)
- Define if the statistical amount is calculated and calculation method for it
- Select Intrastat rounding type to set how Intrastat and statistical amounts will be rounded
- Set foreign currency exchange rate for Intrastat reporting
- Set object for Intrastat report export
New Setup Tables Added for:
- Statistic Indications
- Specific Movements
- Intrastat Delivery Groups
Additional Setup for Intrastat Enables:
- Set a country/region code for Entry/Exit Point
- Set Tariff Number Supplementary Units of Measure if Tariff numbers have to be reported in Supplementary Units of Measure
- Set if particular item charges have to be included in either Intrastat Amount or Intrastat Statistical Value or both
- Set Intrastat behavior for Shipment Methods – select if item charges should be included/excluded for particular Shipment Methods and Intrastat Delivery Group for reporting
- Set Area value in Location Card
- Set default values and enforce company policies following additional Intrastat data available on Customer and Vendor Cards
- Define on the Item Card additional Intrastat data – Statistic indication and Specific movement
- Make special foreign Currency Exchange Rate setup and object for export setup for each Registration Country
Posting Sales, Purchase or Transfer Transaction
To identify and enter attributes of sales transaction that will be used in Intrastat reporting user, follows these steps:
- User verifies Intrastat data (Transaction Type, Specification and Transport Method, etc.) on the Foreign Trade tab. These were transferred to the document header from the relevant Customer or Vendor card and can be manually edited.
- Intrastat Transaction field (non-editable) informs the user whether the particular transaction is qualified as Intrastat transaction.
- Identification of the Physical Movement in the correction (Credit-Memo) documents using the Physical Transfer field.
- User can manually exclude an Intrastat Transaction from Intrastat reporting using the Intrastat Exclude field.
- User verifies Intrastat Data (Tariff No., Statistic Indication, Country/Region of Origin and Net Weight) in the document lines. These were transferred to the line from the relevant Item card and can be manually edited.
- User assigns Item Charge to the sales line and includes/excludes its value to Intrastat Amount and Statistical Amount.
- During the posting, system transfers all Intrastat relevant information to Item Ledger Entry.
- During the posting, system displays an error if any Intrastat field set as mandatory in Stat. Reporting Setup form is not filled in. This will prevent the user from posting the transaction.
Preparing Intrastat Journal
The Intrastat Journal contains the following new fields and functionalities:
- Shipment Method Code
- Statistic Indication
- Specific Movement
- Supplementary Units of Measure Calculation
- Declaration Numbering
- Declaration types for Statement Classification – Primary, Null, Replacing, Deleting
- Registration Country entries filtering
The fastest way to prepare the Intrastat journal and make sure all the rules set in the previous steps are followed is by using the Get Entries batch job. During the execution of the Get Entries batch job, the system will take care of the following:
- System considers Item and Job Ledger Entries created by transaction identified as Intrastat transactions
- System ignores sales and purchase Intrastat transactions with the EU-3 Party Trade flag
- System makes sure to include Intrastat transactions with Entry/Exit Points in EU Country
- System makes sure to include sales and purchase documents (i.e. Credit Memos) posted with the Correction check box as inserted in the Intrastat journal with the same type as documents they are correcting, but with opposite sign for Non-physical Transfer documents and with the opposite type for documents marked as Physical Transfer
- System makes sure the reversed Intrastat transactions (i.e. using Undo Receipt/Shipment) are excluded from reporting (both revered and reversing Intrastat transactions)
- System makes sure the Item Charges are (not) included, adjusted and calculated in Intrastat Amount and Statistical Amount according to the user’s setup in Stat. Reporting Setup, Item Charges, Shipment Methods and Item Charge Assignments
- System makes sure the Supplementary Units of Measure are used while preparing Intrastat Journal lines
- System makes sure the correct data source is used for Tariff No., Net Weight and Country/Region of Origin according to Stat. Reporting Setup
Intrastat Report Export to CSV Format
Export of Intrastat reports to .csv files according to local requirements (for INSTATDESK and INSTATONLINE applications) was added to Intrastat Journal. Export use object for export based on setup in Stat. Reporting Setup or Registration Country.