| 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 box. All the invoice values are expressed in the transaction currencies. When you export the data, ERP 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 ERP LN, click the New button. ERP LN creates a new record and sets the order origin to Manual Transaction. To make corrections, select a line and click the Copy button. ERP 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. Related topics EU Intrastat reporting To export the Intrastat data
Fields | Description
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 | 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 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.
Reporting Status | Intrastat Reporting Status Related topics To export the Intrastat data
Item (PSI) | The standard-item code of the order line. ERP 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: A cost item. A service item. A generic item.
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. Related topics EU transaction reporting
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. ERP 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 terms of delivery of the order.
Point of Title Passage | The point of title passage defined for the terms of delivery.
Carrier/LSP | The carrier who transports the goods.
Mode of Transport | The type of transport used.
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 ERP LN uses the exchange rate type specified in the Internal field in the Companies (tcemm1170m000) session. Related topics To use the External exchange rate type
Exchange Rate | ERP 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, ERP LN sets this field to one (1). Related topics To use the External exchange rate type
per | The rate factor of the exchange rate.
Declaration Expres in Base Currency | If this check box is selected, ERP LN uses the currency exchange rate to convert the base currency into the foreign currencies. If this check box is cleared, ERP 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 ERP 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). ERP LN uses the currency rate that is effective on the transaction date.
Local Currency | The local currency.
Statistical Value Transaction Amount | The statistical value of the goods, in the transaction currency, at the moment when they cross the border. Because ERP 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). ERP LN uses the currency rate that is effective on the transaction date.
Valuation Price | The valuation price entered by ERP LN in case of staggered consignments. Related topics Valuation price and invoice amounts for staggered consignments
Currency | The currency in which the valuation price is expressed. ERP 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, ERP LN displays the exchange rate type that you selected in the Process Intrastat Transactions (tccom7271m000) session. Related topics To use the External exchange rate type
Declaration Exchange Rate | The exchange rate used for the report. Related topics To use the External exchange rate type
Rate Factor | The rate factor of 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 ERP 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 ERP 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.
Extra Intrastat Info | The extra Intrastat info fields that you have linked to the warehouse order type. ERP LN includes this data in the Intrastat export file.
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.