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 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.

 

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 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.

Transaction Type

Indicates whether the item was imported or exported.

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 Commodity Code Filled in the Method of Logging Cost/Service Items field of the Intrastat Parameters (tccom7100s000) session, the item can also be:

Transaction 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.

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 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.

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.

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.

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.