Maintaining Intrastat Transactions

The system compiles eligible transactions automatically for Intrastat reporting. This process populates the nature of transaction code, based on the defaults that are specified on the Nature of Transaction Code pages. The values that you select on the Fiscal Regime/Stat Procedure (fiscal regime/statistical procedure) page also appear by default where they apply. You can change the default values, alter information, or delete a transaction with the Intrastat Transaction Entry pages. You can also enter a transaction that isn't included in those that are automatically compiled.

Note: You must run the Intrastat Transaction Loader process before you can change automatically compiled Intrastat transactions.

This section discusses how to maintain Intrastat transactions.

Page Name

Definition Name

Usage

Header Detail Page

IST_TXN_TBL1

Change and add an Intrastat transaction. If you are changing an existing entry, enter an Intrastat Document ID.

Line Detail Pagel

IST_TXN_TBL2

Change or add Intrastat transaction details.

Intrastat Txn Exchange Rate (Intrastat Transaction Exchange Rate) Page

IST_TXN_SEC

View additional currency information after running the Report Extract process.

Use the Header Detail page (IST_TXN_TBL1) to change and add an Intrastat transaction.

If you are changing an existing entry, enter an Intrastat Document ID.

Navigation:

VAT and Intrastat > Intrastat > Transaction Entry > Header Detail

You must run the Intrastat Transaction Loader process before you can view transactions that are compiled automatically.

Note: Designated country and flow selections on Intrastat Characteristics pages determine which fields are available for entry on this page. Field labels change, based on the flow.

Flow

Field Name

Intrastat Characteristics Page

Field That Is Checked on the Intrastat Characteristics Page

Arrivals or Dispatches

VAT Reg Country

Option a

Trading Partner Registration group box - Registration Required

Arrivals

Consignment Country

Option b

Country of Consignment

Dispatches

Destination Country

Option b

Country of Destination

Dispatches

Region of Origin

Option a

Region of Origin

Arrivals

Region of Destination

Option a

Region of Destination

Arrivals or Dispatches

Transport Mode

Option a

Transport Mode

Arrivals

Port of Unloading

Option a

Port/Airport of Unloading

Dispatches

Port of Loading

Option a

Port/Airport of Loading

Field or Control

Description

Intrastat Transaction Source

Displays one of the following values when you update an existing transaction:

Billing Adjustment: Financial adjustment (against dispatches) from PeopleSoft Billing.

Shipment Return: Return-to-vendor shipments (dispatches). This value also appears when a purchase order receipt contains rejected quantities that are returned to vendors.

Shipment: Normal shipments from sales orders (dispatches).

InterUnit Shipment: Shipments from interunit orders (dispatches).

Purchasing Receipt: Purchase order receipts (arrivals).

InterUnit Receipt: Interunit order receipts (arrivals).

RMA Receipt (return material authorization receipts): Returns from customers (arrivals).

Voucher Adjustment: Financial adjustment (against arrivals) from PeopleSoft Payables.

Manual Entry: Appears when you add a transaction.

Trading Partner Details

Field or Control

Description

Partner Type

Select either Customer or Supplier as a trading partner's designation for the transaction.

Partner SetID

Determines which suppliers or customers are available in the Partner ID field.

Partner ID

Select a supplier or customer ID.

VAT Reg Country (value-added tax registration country)

Select the trading partner's VAT registration country.

VAT Registration ID (value-added tax registration ID)

Appears by default, if the trading partner's ID exists in the system; otherwise, you enter the ID number.

Note: Only countries that are designated as EU member states on the Country page in the Location menu are available for selection. Select Set Up Financials/Supply Chain, Common Definitions to access the Location menu.

Country, Region, Transport Mode, and Port

Select values for these fields, as required by the choices on the Intrastat Characteristics pages.

Delivery Terms

Select values for these fields, as required by the choices on the Intrastat Characteristics pages.

Field or Control

Description

1st Subdivision

Delivery terms for the transaction may be any of the following values:

CFR (Cost and freight).

CIF (Cost, insurance, and freight at port of arrival).

CIP (Carriage and insurance paid to).

CPT (Carriage paid to).

DAF (Delivery at frontier).

DDP (Delivered duty paid).

DDU (Delivered duty unpaid).

DEQ (Delivered ex-quay).

DES (Delivered ex-ship).

EXW (Ex-works).

FAS (Free alongside ship).

FCA (Franco carrier).

FOB (Free on board at port of departure).

Other Delivery terms that differ from the listed values.

2nd Subdivision

Delivery terms include:

In Rprting (in reporting): Located in the territory of the declarant member state.

Other EU: Located in another member state.

Other: Located outside of the EU.

Use the Line Detail page (IST_TXN_TBL2) to change or add Intrastat transaction details.

Navigation:

VAT and Intrastat > Intrastat > Transaction Entry > Line Detail

Field or Control

Description

Item SetID

Select the SetID if you are specifying an inventory item.

Item ID

Specify an inventory ID.

Line

Displays the number of the current line. The line number increases by one as rows are inserted.

Commodity Cd(Commodity Code)

Select the EU Commodity Code associated with the goods being shipped or received. If you have entered an inventory item and assigned a commodity code to that item, the system automatically populates the commodity code. Otherwise, you must enter it manually.

Origin Country

Select a country of origin for arrivals.

Quantity

The system calculates the net mass by multiplying the quantity by the unit weight.

UOM(unit of measure)

Select the unit of measure in which the quantity is specified. If you have entered an inventory item, the system automatically populates the standard UOM specified for this item.

Unit Weight

Enter the item's weight by unit. If you have entered an inventory item, the system automatically populates this field with the weight specified for this item. It is assumed that the weight is specified in kilograms.

Net Mass

The total weight of the goods being shipped or received. The system automatically calculates this based on the quantity and weight of the item.

(Supplementary) UOM

Enter the unit of measure of the supplementary units. If you have manually entered an EU Commodity Code, and if that EU Commodity Code requires that supplementary units be reported, and if the supplementary UOM has been specified on the commodity code, the system populates this automatically.

Suppl Units (supplemental units)

If the EU Commodity Code associated with this transaction requires the reporting of supplementary units, enter the number of units.

Fiscal Regime

Select a value if you are reporting in a country that requires fiscal regimes.

Stat Procedure (statistical procedure)

Select a value if you are reporting in a country that requires statistical procedures.

Nature of Transaction

Field or Control

Description

1st Digit and 2nd Digit

All EU member states require the first digit for Intrastat reporting. In addition, several EU member states use a second digit to categorize transactions. These values are predefined. The appropriate set of values for this second digit is available based on what is defined on the Country Characteristics pages.

Invoice Amount

Field or Control

Description

Reporting

The reporting currency appears. If you leave the field blank, the report extract calculates the reporting amount from the value for transaction or base currency.

Transaction

Enter the transaction currency.

Base

Enter the base currency.

Amount

Enter the values for each currency type.

Statistical Value

Enter a value. If you leave the field blank, the Report Extract process calculates the amount based on the settings on the Statistical Value Details page.

Amount Source

Display options include:

Invoice: Appears if the amount came from an invoice, adjusted invoice, voucher, or adjusted voucher.

Order: Appears if the amount came from a sales order, interunit order, purchase order, RMA order, or return to vendor order.

Manual: Appears if you manually enter a transaction.

Reporting Currency Details

Click to access additional currency information.

Use the Intrastat Txn Exchange Rate (Intrastat Transaction Exchange Rate) page (IST_TXN_SEC) to view additional currency information after running the Report Extract process.

Navigation:

VAT and Intrastat > Intrastat > Transaction Entry > Line Detail > Reporting Currency Details

Once the Report Extract process runs, this page appears with the exchange rate type from the Intrastat Report Extract page.

If the reporting currency is the same as either the base or transaction currency, the Report Extract process uses the base (or transaction) amount for the reporting amount. In this case, the Exchange Rate Source field displays BSE (base) or TXN (transaction). Otherwise, the Report Extract process calculates the reporting amount, in which case TBL (exchange rate table) appears.