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 New button. LN creates a new record and sets the order origin to Manual Transaction.
  • To make corrections, select a line and click the Duplicate button. 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.
Note
  • 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 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.

 

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 financial company that submits the Intrastat declaration.
Country
The country in which you submit the Intrastat declaration.
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 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.
Transaction Type
Indicates whether the item was imported or exported.
Item
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 Commodity Code Filled in the Method of Logging Cost/Service Items field of the EU Intrastat Parameters (tccom7100s000) session, the item can also be:

Transact.Date
The warehouse order date.
Commodity Code (CN8)
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
The unit of measure in which the inventory of an item is recorded, such as piece, kilogram, box of 12, or meter.

The inventory unit is also used as the base unit in measure conversions, especially for conversions that concern the order unit and the price unit on a purchase order or a sales order. These conversions always use the inventory unit as the base unit. An inventory unit therefore applies to all item types, also to item types that cannot be kept in stock.

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
An extra unit in which the quantity of goods must be reported for the EU Intrastat declaration. The main reporting unit is kilogram in all cases. For some goods, a reporting unit must be used such as pairs (of shoes and so on), liters, head or pieces (for cattle), or square meters. Quantities of goods to which kilograms do not apply are only reported in the supplementary 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.
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
The delivery order sequence number.
Terms of Delivery
The delivery terms of the order.
Point of Title Passage
The point of title passage defined for the delivery terms.
Carrier
The carrier who transports the goods.
Mode of Transport
The type of transport used.

Allowed values

Transport Category

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 wich the goods are imported.
Home Area
The area to which the goods are exported or from wich 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
Partner VAT 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.
Express 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
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
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.
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
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 Export Intrastat Transactions (tccom7271m000) session, LN displays the exchange rate type that you selected in the Export Intrastat Transactions (tccom7271m000) session.

Exchange Rate
The exchange rate used for the report.
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.

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.

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.