Intrastat Transactions (tccom7171m000)
Use this session to view the transaction data that has been logged for the Intrastat declaration and to make any corrections that are necessary. You can only correct data that is not yet processed.
The department type and code of the department for which the report is generated are displayed in the Declarant section.
All the invoice values are expressed in the transaction currencies. When you export the data, LN converts the amounts to the local currency, using the currency rate that is effective on the transaction date.
- To enter transactions that are not registered in LN, click the button. LN creates a new record and sets the order origin to Manual Transaction.
- To make corrections, select a line and click the LN creates a new record with the copied data and sets the order origin to Manual Correction. To correct the reported data, you can enter a transaction with values that correct the copied transaction. button.
- The Intrastat data must reflect the actual transaction data as it is recorded in Financials. If you want to change the data related to the quantity and the invoice value, such as the Invoice Value Transaction Currency and the Exchange Rate Type, the order origin must be Manual Transaction or Manual Correction. For other order origins, you can only change the fields that are related to logistic data.
- You cannot change the fields values of the extra Intrastat info fields linked to a transaction. If other values are required, you must link a different extra Intrastat info set to the transaction.
Field Information
- General
-
- Declarant
-
- Entity Type
-
The key entity type of the department for which the report is generated.
- Office
-
The department code of the department for which the report is generated.
- Enterprise Unit
- Financial Company
-
The financial company that submits the Intrastat declaration.
The department's enterprise unit is linked to this financial company.
- Local Currency
-
The financial company's local currency, which is used for the Intrastat declaration.
- VAT Number
-
The tax ID of the department that submits the Intrastat declaration.
The department's tax ID is the same as the financial company's tax ID.
This field is not displayed if the Registration by Tax Country parameter is set to Active in the Global Registration Parameters (tctax2100m000) session. Instead, the department's tax ID, which can be different from the financial company's tax ID, is displayed in the Own Identification Number field in the lines section of the current session.
- Country
-
The country of the department in which you submit the Intrastat declaration.
This is the same country as the financial company's country.
This field is not displayed if the Registration by Tax Country parameter is set to Active in the Global Registration Parameters (tctax2100m000) session. Instead, the country in which the Intrastat declaration is submitted, which can be different from the financial company's country, is displayed in the Declaration Country field in the lines section of the current session.
- General
-
- Order Origin
-
The order line type, indicating the order's origin.
If the order origin is Manual Transaction or Manual Correction, you can change the fields that are related to the quantity and the invoice value, such as the Invoice Value Transaction Currency and the Exchange Rate Type. For other order origins, you can only change the fields that are related to logistic data.
If you use Find a record to search for Intrastat declaration data, you can select all the available order types.
- Order
-
The purchase order or sales order that results in the import or export of the item.
- Position
-
the position number of the order line.
- Sequence No.
-
The sequence number of the order line.
- Flow
-
Indicates whether the item was imported or exported.
- Reporting Status
-
- Awaiting Final Shipment
- Not Applicable
- Blocked for Reporting
- Ready for Reporting
- Processed
- Item (PSI)
-
The standard-item code of the order line. LN records import/export data of customized items under the item from which the customized item is derived.
If you selected either the value Always or the value If HS Code Filled in the Method of Logging Cost/Service Items field of the Intrastat Parameters (tccom7100s000) session, the item can also be:
- A cost item.
- A service item.
- A generic item.
- Transaction Date
-
The warehouse order date.
- Harmonized System Code
-
The item's commodity code that you assigned to the item in the Item Base Data module.
- Reference
-
The warehouse order reference.
- Quantity
-
The goods quantity on the order, expressed in the inventory unit.
- Unit
- Supplementary Unit Quantity
-
The goods quantity on the order, expressed in the supplementary unit.
If no supplementary unit is required, this field is zero.
- Unit
- Weight
-
The weight of the goods. LN multiplies the quantity expressed in the inventory unit by the weight defined for the item in the Item Base Data module to calculate the weight.
- Weight Unit
-
The item's base weight unit.
- Declaration Country
-
The country in which the Intrastat declaration is submitted.
This field is not displayed if the Registration by Tax Country parameter is set to Inactive or In Preparation in the Global Registration Parameters (tctax2100m000) session. Instead, the country in which the Intrastat declaration is submitted is displayed in the Country field in the header section of the current session.
- Own Identification Number
-
The own identification number associated with the intrastat transaction.
Note:This field is enabled only if the Extended Registration Management field is other than Active in the Global Registration Parameters (tctax2100m000) session.
This field is enabled only if the Declaration Country is specified.
- Own Identification Number
-
The tax number of the entity for which the tax declaration is submitted.
Note: This field is enabled only if the Extended Registration Management field is other than Active in the Global Registration Parameters (tctax2100m000) session and the Order Origin is other than Manual. - Business Partner
-
The business partner that represents the non-declaring party of the current Intrastat transaction.
For import Intrastat transactions, that is, transactions for which the delivery method is Receipt, the non-declaring party is the buy-from business partner or the internal business partner representing the issuing warehouse, work center, or project.
For export Intrastat transactions, that is, transactions for which the delivery method is Shipment, the non-declaring party is the sold-to business partner or the internal business partner representing the receiving warehouse, work center, or project.
- Vat Number
-
The VAT number of the entity for which the Intrastat declaration is submitted.
This field is not displayed if the Registration by Tax Country parameter is set to Inactive or In Preparation in the Global Registration Parameters (tctax2100m000) session. Instead, the VAT number is displayed in the VAT Number field in the header section of the current session.
- Goods Flow
-
- Goods Flow
-
- Delivery Method
-
Indicates whether the transaction concerns a warehouse delivery or a warehouse receipt.
If no warehouse order exists, select Not Applicable.
- Delivery Order
-
The order number of the warehouse delivery or the warehouse receipt.
- Delivery Order Line
-
The delivery order sequence number.
- Delivery Terms
-
The delivery terms of the order.
- Point of Title Passage
-
The point of title passage defined for the delivery terms.
- Carrier/LSP
-
The carrier who transports the goods.
- Mode of Transport
-
The type of transport used.
Allowed values
- Transport by Sea
- Transport by Sea (Container)
- Transport by Rail
- Transport by Rail (Container)
- Transport by Road
- Transport by Road (Container)
- Transport by Air
- Transport by Air (Charter)
- Consignments by Post
- Fixed Transport Installations
- Transport by Inland Waterway
- Express Air
- Express Truck
- Express Rail
- Own Propulsion
- Not Applicable
Note: LN defaults the value specified in the Pick-up Means of Transport field in the Loads (whinh4140m000) session. If not defined, LN defaults the value specified in the Delivery Means of Transport in the same session. - Ship-from Address
-
The address from which the goods were shipped.
- Ship-to Address
-
The address to which the goods were shipped.
- Partner Country
-
The country of issue (for import) or the destination country (for export).
- Home State/Province
-
The state/province to which the goods are exported or from where the goods are imported.
- Home Area
-
The area to which the goods are exported or from where the goods are imported.
- Country of Origin
-
The item's country of origin, as you have defined it in the Item Base Data module.
- Financial Data Internal
-
- Amounts and Internal Exchange Rates
-
- Business Partner Identification Number
-
The business partner's tax ID.
- Invoice-from Address
-
The address from which the invoice is sent.
This is the address of the invoice-from business partner, or your own company's address.
- Invoice-to Address
-
The address to which the invoice is sent.
This is the address of the invoice-to business partner, or your own company's address.
- Transaction Currency
-
The transaction currency.
- Exchange Rate Type
-
The exchange rate type that applies to the order.
If the value of the Order Origin field is Manual Transaction or Manual Correction, you can enter an exchange rate type. Otherwise LN uses the exchange rate type specified in the Internal field in the Companies (tcemm1170m000) session.
- Exchange Rate
-
LN uses this currency exchange rate to convert the amount in the transaction currency to the reference currency.
If you have not defined an internal exchange rate for the company and you do not enter an exchange rate here, LN sets this field to one (1).
- per
-
The rate factor of the exchange rate.
- Declaration Expres in Base Currency
-
If this check box is selected, LN uses the currency exchange rate to convert the base currency into the foreign currencies.
If this check box is cleared, LN uses the currency exchange rate to convert the foreign currencies into the base currency.
- Invoice Value Transaction Currency
-
The value of the goods, in the transaction currency, at the moment when they cross the border.
This must be the net invoice amount, which includes the transportation cost to the border. As LN cannot calculate the transportation costs to the border, by default this field contains the net goods value on the order, expressed in the transaction currency.
- Invoice Value
-
The invoice value in the local currency of the current company (usually in euros). LN uses the currency rate that is effective on the transaction date.
- Statistical Value Transaction Amount
-
The statistical value of the goods, in the transaction currency, at the moment when they cross the border.
Because LN cannot calculate the statistical value of the goods, by default this field contains the invoice amount.
- Statistical Value
-
The statistical value in the local currency of the current company (usually in euros). LN uses the currency rate that is effective on the transaction date.
- Valuation Price
-
The valuation price entered by LN in case of staggered consignments.
- Currency
-
The currency in which the valuation price is expressed. LN uses the currency rate that is effective on the transaction date.
- Financial Data External
-
- Amounts and Declaration Exchange Rates
-
- Declaration Exchange Rate Type
-
The exchange rate type used for the report.
If you selected the Recalculate Amounts with Declarant Exchange Rates check box in the Process Intrastat Transactions (tccom7271m000) session, LN displays the exchange rate type that you selected in the Process Intrastat Transactions (tccom7271m000) session.
- Declaration Exchange Rate
-
The exchange rate used for the report.
- Declaration Invoice Value
-
The value of the goods, in the transaction currency, at the moment when they cross the border.
This must be the net invoice amount, which includes the transportation cost to the border. Because LN cannot calculate the transportation costs to the border, by default this field contains the net goods value on the order, expressed in the transaction currency.
- Declaration Statistical Value
-
The statistical value of the goods, in the transaction currency, at the moment when they cross the border.
Because LN cannot calculate the statistical value of the goods, by default this field contains the invoice amount.
- Declaration Currency
-
The currency in which intrastat reporting is processed.
Note:- LN follows this search sequence to default the
value:
- The tax currency specified in the Tax Parameters by Country (tctax0101m000) session, or
- The tax currency specified in the Tax Parameters (tctax0100m000) session, or
- The local currency of the financial company.
- If this field is applicable, specifying a value is mandatory.
- This field can be empty for historical data. If empty, the local currency of the financial company must be used during processing / printing of reports.
- LN follows this search sequence to default the
value:
- Declaration Exchange Rate Type
-
The exchange-rate type used for tax declaration reporting.
Note:- When the tax currency is same as the home currency and the delivery is invoiced, this field must be updated with the tax currency rate type used in the invoice. However, only the Exchange Rate Type for which the Used for Tax Reporting check box is cleared in the Exchange Rate Types (tcmcs0140m000) session, are allowed.
- When the tax currency is not same as the home currency and the delivery or receipt is invoiced, this field must be updated with the tax currency rate type used in the invoice. However, only the Exchange Rate Type for which the Used for Tax Reporting check box is selected in the Exchange Rate Types (tcmcs0140m000) session, is allowed.
- When declaration currency is same as home currency,
LN defaults the value in this sequence:
- the External rate type, or
- the internal rate type, or
- The exchange rate type of the transaction.
- When declaration currency is not same as home currency,
LN defaults the value in this sequence:
- The exchange rate type specified in the Tax Parameters by Country (tctax0101m000) session, or
- The exchange rate type specified in the Tax Parameters (tctax0100m000) session, or
- The exchange rate type of the transaction.
- This field is mandatory if the Registration by Tax Country is set to Active in the Global Registration Parameters (tctax2100m000) session.
-
The description or name of the code.
- Declaration Exchange Rate
-
The currency exchange rate determined based on the declaration exchange rate type and transaction date.
Note:- You must specify this value if the Registration by Tax Country field is set to Active in the Global Registration Parameters (tctax2100m000) session.
- When a delivery or a receipt is invoiced this field is updated with the tax currency rate used in the invoice.
- per
-
The rate factor of the declaration exchange rate.
- Declaration Expressed in Base Currency
-
Indicates if the declaration are expressed in the base currency. This is determined based on the declaration exchange rate type and transaction date.
Note:- This field is mandatory if the Registration by Tax Country field is set to Active in the Global Registration Parameters (tctax2100m000) session.
- When a delivery or a receipt is invoiced, this field is updated with the tax currency express in base value, that is used in the invoice.
- Declaration Invoice Value
-
This is the invoice value in the declaration currency which has been converted from the transaction currency, based on the declaration rate.
Note:- This value must be specified if the Registration by Tax Country field is set to Active in the Global Registration Parameters (tctax2100m000) session.
- When a delivery or a receipt is invoiced, this value is recalculated based on the rate specified in the invoice.
-
The code of the local currency.
- Declaration Statistical Value
-
The is the statistical value in the declaration currency which has been converted from the declaration currency, based on the declaration rate.
Note:- This value must be specified if the Registration by Tax Country field is set to Active in the Global Registration Parameters (tctax2100m000) session.
- When a delivery or a receipt is invoiced, this value is recalculated based on the rate specified in the invoice.
-
The description or name of the code.
- Extra Intrastat Info
-
- Operational Company
-
The logistic company in which the order originated.
- Extra Intrastat Info
-
The extra Intrastat info set linked to the order.
- Field Name
-
The field name according to the rules for Intrastat declarations.
- Field Value
-
The value of the field.
A value cannot exceed the length defined for the field in the Extra Intrastat Info Definition (tccom7104m000) session. The actual value and the type of value (numeric or alphanumeric) is determined by the rules for Intrastat declarations and the type of business.
If you generate the import/export statistics for sales orders and purchase orders or projects to which you have linked this extra Intrastat info, the values of these fields are included in the statistical report data.
- Field Value Description
-
The description of the field according to the rules for Intrastat declarations.