Show TOC

Object documentationIntrastat Declaration Wizard: Step 6 - Editing Transactional Data Locate this document in the navigation structure

 

A transaction (document row) is collected for Intrastat declaration if it meets the following requirements:

  • The business partner is eligible for Intrastat declaration. For more information, see the business partner section of Configuring Business Partner and Item Intrastat Settings.

  • The item is eligible for Intrastat declaration. For more information, see the item section of Configuring Business Partner and Item Intrastat Settings.

  • The Ship to field on the Logistics tab of the business document meets the following requirements:

    • The field is not blank.

    • The address is in a EU country different from the declaration country.

    • For a sales document, the business partner is of the company type and the address has a federal tax ID with the appropriate country code. For example, if your ship-to address is in the UK, the federal tax ID must start with GB.

In the Transactions window, you can carry out the following activities:

  • For a new declaration or an open saved declaration, you can select/deselect transactions to include/not include them in the declaration; and you can edit many data, for example, net mass and the transactional value.

  • You can reopen an executed declaration to edit transactional data.

Some of the default values of the editable fields are drawn from relevant fields according to the following priority table:

Priority Table

Priority

Document

1 (Highest)

Step 4 (Business Partners) or step 5 (Items) of the declaration wizard

2

Business document

3

Business partner Intrastat setting

4

Item Intrastat setting

General Area Fields
Group Documents By

Select one of the following ways to group transactions (document rows):

  • Business partner

  • Commodity code

  • Service code

    Only available for Italy.

Expand

Displays all the detail rows of the declaration.

Collapse

Hides all the detail rows of the declaration.

Reopen

Reopens an executed declaration. The declaration status is changed from Closed to Open.

Declaration Fields
BP Code

Business partner code.

Deselect the Include checkbox of a business partner to exclude all the business partner's transactions from the declaration.

Document No.

Combination of the transaction type abbreviation and the number of the document, for example, PU-1. For information about transaction type abbreviations, see Transaction Type Abbreviations Legend.

Deselect the Include checkbox of a document to exclude all its transactions (document rows) from the declaration.

Include

The Include checkbox is selected for each line by default.

  • If you deselect the Include checkbox of a transaction, the transaction is excluded from the declaration file.

  • If you deselect the Include checkbox of a document, all the transactions in the document are excluded from the declaration file.

  • If you deselect the Include checkbox of a business partner, all the business partner's transactions (document rows) are excluded from the declaration file.

  • If you group the documents by the commodity code or the service code, and deselect the Include checkbox of a commodity code or a service code, all transactions of the item with the commodity code or the service code are excluded from the declaration file.

Declaration Row No.

Line number of each transaction in the respective section of the declaration file.

Document Row No.

The row number of the transaction in the business document.

Posting Date

Posting date of the business document.

Business Partner Country

Default value:

  • Purchasing – A/P transactions: From the default ship-to address of the business partner

  • Sales – A/R transactions: From the ship-to address of the business document

Destination Country for Import

Default value: drawn according to the priority table above.

Destination Region for Import

Default value: drawn according to the priority table above.

Country of Origin for Export

Default value: drawn according to the priority table above.

Region of Origin for Export

Default value: drawn according to the priority table above.

Incoterms

Default value: drawn according to the priority table above.

Nature of Transactions

Default value: drawn according to the priority table above.

Statistical Procedure

Default value: drawn according to the priority table above.

Customs Procedure

Default value: drawn according to the priority table above.

Transport Mode

Default value: drawn according to the priority table above

Port of Entry or Exit

Default value: drawn according to the priority table above.

Commodity Code

Default value: drawn according to the priority table above.

Statistical Code

Relevant to the Czech Republic only.

Default value: drawn according to the priority table above.

Service Code

Relevant to Italy only.

Default value: drawn according to the priority table.

Country of Origin

Default value: drawn according to the priority table above.

Tax Code Extension

Relevant to France only.

Default value: drawn from step 3 of the wizard.

Net Mass Sign

Specify whether the value in the Net Mass field is negative or positive. By default, if a transaction is in the same direction as the declaration, the sign is positive; if a transaction is in the opposite direction of the declaration, for example, a goods return in an import declaration, the sign is negative.

Net Mass

Value calculated according to the calculation rules of data collection. For more information, see Data Collection Rules: Calculations.

Note Note

In this step, the item weight is automatically converted to kilograms when calculating the item's net mass and mass in supplementary unit. The conversion does not affect the original values of the Weight fields in the relevant business documents or item master data.

End of the note.
Net Mass Unit

Specify the unit of measurement of the net mass.

Default value: kg

Sign for Mass in Supplementary Unit

Specify whether the value in the Mass in Supplementary Unit field is negative or positive. By default, if a transaction is in the same direction as the declaration, the sign is positive; if a transaction is in the opposite direction of the declaration, for example, a goods return in an import declaration, the sign is negative.

Mass in Supplementary Unit

Value calculated according to the calculation rules of data collection. For more information, see Data Collection Rules: Calculations.

Note Note

In this step, the item weight is automatically converted to kilograms when calculating the item's net mass and mass in supplementary unit. The conversion does not affect the original values of the Weight fields in the relevant business documents or item master data.

End of the note.
Supplementary Unit

Default value: drawn according to the priority table above.

Value Sign

Specify whether the value in the Value field is negative or positive. By default, if a transaction is in the same direction as the declaration, the sign is positive; if a transaction is in the opposite direction of the declaration, for example, a goods return in an import declaration, the sign is negative.

Value

Transaction value that is to be declared. For information about its calculation rules, see Data Collection Rules: Calculations.

Value in Foreign Currency

If the transaction is recorded in a foreign currency, the value in foreign currency is drawn from the Total (Doc) field of the business document row. Otherwise, it is zero.

Foreign Currency

If the transaction is recorded in a foreign currency, the field displays by default the foreign currency; otherwise, it displays the local currency.

Statistical Value Sign

Specify whether the value in Statistical Value is negative or positive. By default, if a transaction is in the same direction as the declaration, the sign is positive; if a transaction is in the opposite direction of the declaration, for example, a goods return in an import declaration, the sign is negative.

Statistical Value

Value calculated according to the calculation rules of data collection. For more information, see Data Collection Rules: Calculations.

Domestic/Foreign Identifier

Specify the appropriate identifier.

Return Identifier

Specify the return identifier.

Referenced Month, Referenced Year, Referenced Document No., Referenced Item No.

Displays the information of the base transactions.

Relevant to the following documents:

  • A/R credit memo based on A/R invoices

  • A/P credit memo based on A/P invoices

Ref. Year of Summary to Correct

Relevant to Italy only. Used in the correction section.

Displays the declaration year of the document's base transactions if the document is used to rectify other documents.

Business Partner Federal Tax ID

If the federal tax ID in the business document is different from that in the business partner master data, which is drawn to step 4 of the wizard, the default value of the Business Partner Federal Tax ID field is the federal tax ID in the business document.

Manual Change Indicator

If you manually change the value in one of the following fields in this step, the manual change indicator changes from N to Y:

  • Net Mass Sign

  • Net Mass

  • Sign for Mass in Supplementary Unit

  • Mass in Supplementary Unit

  • Value Sign

  • Value

  • Value in Foreign Currency

  • Foreign Currency

  • Statistical Value Sign

  • Statistical Value

Changed Data Record ID

Specify a record ID for the data change.

Changed By

Default value: the SAP Business One user who makes the data change.

Time Stamp for Change

Specify the date on which the data was changed.

Delete Indicator

Indicates whether this transaction is included or not in the declaration file.

Service Supply Method

Default value: drawn from step 5.

Service Payment Method

Default value: drawn from step 5.

Code of the State Where the Payment is Made

Specify the code of the state where the payment is made.

Default value: drawn from the Pay to/Bill to address of the relevant document.

No. of Declaration to Correct

Displays the number of the declaration (executed) that includes the corrected document.

Row No. Inside Section 3 to Correct

Default value: drawn from the original document.