(Europe) Using European Union Functionality

This chapter provides overviews of international bank account numbers (IBAN), bank ID and bank account validation, tax ID validation, and European Union reporting and discusses how to:

• Print invoices with an attached international payment instruction.

• Populate the Intrastat workfile.

• Revise Intrastat information.

• Purge records from the Intrastat Revision table (F0018T).

• Use the IDEP/IRIS interface for Intrastat reporting.

• (GBR) Use the SEMDEC Interface for Intrastat reporting.

• (DEU) Print the German Intrastat report.

Understanding International Bank Account Numbers

The International Organization for Standardization (ISO) and the European Committee for Banking Standards (ECBS) developed the IBAN to assist companies with account identification.

The IBAN is used internationally to uniquely identify the account of a customer at a participating financial institution. The IBAN allows for validation checks through the use of international 2-character country codes as established by ISO. Additional validation is performed through the use of an algorithm/check-digit process. The account-administering bank is responsible for calculating the IBAN and providing it to its customers.

The IBAN format differs, depending on whether it is transmitted electronically or printed on paper. The variance is only in its presentation; the IBAN number remains the same whether in electronic or print format. The IBAN consists of these segments:

When transmitted electronically, the IBAN is one string of characters. When printed, the IBAN is preceded by the text string IBAN and is split into groups of four characters that are separated by a space. The last group might contain fewer than four characters.

You can link the IBAN number with a bank address in the JD Edwards EnterpriseOne Address Book system. When you link the IBAN with a bank address, the automatic payment process can identify the correct country for suppliers and customers who have bank accounts in multiple countries. You enter the IBAN in the Bank Account Cross-Reference (P0030A) and the Bank Account Information (P0030G) programs in the electronic format. The system stores the IBAN in the electronic format in the Bank Transit Master table (F0030).

This table shows examples of IBANs in Belgium and France:

The ECBS specifies that the IBAN appear on the International Payment Instruction (IPI) form in the print format but without the term IBAN. For example, the IBAN for the Belgian account number in the previous table would appear on an IPI as BE62 5100 0754 7061.

Understanding Bank ID and Bank Account Validation

A bank identification (ID) number identifies the bank with which you have established an account. The bank ID number is included in the customer information that you remit for processing accounts receivable drafts and EFT payments.

You activate bank ID validation routines for these countries by setting up the localization country code in your user profile:

• Belgium

• France

• Finland

• Italy

• Spain

Completing the Localization Country Code field on the User Profile Revisions form causes the system to search for a bank ID validation routine, but the validation routine to use is not specified. For example, if you specify Belgium in the Localization Country Code field, you can still validate bank IDs for other countries. When you use the Bank Account Cross-Reference program (P0030A), the system uses the value in the Country field on the Mailing tab on the Address Book Revision form to determine which validation to use for the address book record.

The system validates bank code numbers and bank branch codes when you enter bank IDs into the Bank Account Cross-Reference program or the Bank Account Information (P0030G) program. The system identifies the customers whose bank information is invalid with an error message.

You can check for missing bank information for customers by running the Bank Account Validation program (R00314).

The system validates account and bank identification information throughout the draft process:

Bank ID Validation Overrides

You can override bank ID validation for a specific country by adding the country code to user-defined code (UDC) table 70/BI. The system does not run bank ID validation routines for countries listed in this UDC table.

(BEL) Bank Account Validation

To process bank transactions for Belgium, the account information that you enter must be accurate to avoid service charges from the bank and possible rejection of electronic funds transfers. Electronic funds transfers can be rejected for payments and receipts because of incomplete or incorrect account information.

The JD Edwards EnterpriseOne system automatically validates the bank account information for Belgian suppliers and customers, including the bank account numbers, according to the standards set by the Belgian banking authority. The Modulus 97 algorithm validates the bank account number when you add or change a bank account number. If you enter an invalid bank account number, you receive an error message stating that the bank account is invalid.

Note. When you add bank account information in the Bank Account Number field, ensure that the control digit is included, in addition to the bank account number, in the Bank Account Number field. The Control Digit field is considered part of the bank account number in Belgium.

(FRA) Bank Account Validation

To process bank transactions for France, the account information that you enter must be accurate to avoid service charges from the bank and possible rejection of electronic funds transfers. Electronic funds transfers can be rejected for payments; receipts can be rejected because of incomplete or incorrect account information.

The system automatically validates the Rélevé d'Identité Bancaire (R.I.B.), including the bank account and transit numbers, according to the standards set by the French banking authority. You must enter the R.I.B. key in the Control Digit field for the account information to be validated. The Modulus97 algorithm checks the R.I.B. key.

Note. In addition to online validation, you can run the Bank Account Exception Report (R00310) to verify that your account information is correct. When you run this report, the system verifies the account numbers based on a control digit (R.I.B. key) and the bank transit number.

(ITA) Bank Account and Bank ID Validation

In Italy, businesses that remit incorrect or incomplete bank identification or account information to the bank are subject to fees. To avoid these charges, businesses must carefully validate bank identification and account information that is entered into the system during data entry.

You can set up your system to automatically validate account information when you use these programs:

• Bank Account Cross-Reference (P0030A).

• Bank Account Information (P0030G).

• Bank Revision - Italy (P7430IT).

• Enter Customer Drafts (P03B602).

• Pre-Authorized Drafts (R03B671).

• A/R Magnetic RIBA Draft Remittance Tape Format (R03B672IT).

The system validates account information based on the Bank ID - Italy table (F74030).

Italian banks assess a service charge when invalid account or bank identification numbers are included in the customer information that businesses remit for processing accounts receivable drafts (RiBa) and automatic payments.

Italian bank identification information consists of a transit code, which includes two 5-character segments:

• The Bank Code (ABI).

• The Bank Branch Code (CAB).

The ABI segment identifies the bank (for example, Banco di Napoli) and is followed by the CAB segment, which identifies the branch (for example, Banco di Napoli - Positano).

The Banca d'Italia maintains and updates valid bank identification numbers. Individual banks can provide their clients with the updated information on tape or diskette.

The JD Edwards EnterpriseOne system supports the COMIT format and ships the Bank ID - Italy table (F74030) with the localized software for Italy. You must upload the bank information that is provided by Banca d'Italia to this table. After you upload the information, you can make your own revisions to the bank table as needed.

To validate bank identification information, the system validates bank codes and branch codes when you:

• Set up bank account information.

• Enter accounts receivable drafts.

• Generate preauthorized accounts receivable drafts.

• Create the accounts receivable drafts remittance table.

The system validates the customer bank information against the valid bank identification information in the F74030 table.

The programs that validate account information and bank identification information are described in this table:

Understanding Tax ID Validation

The system validates tax IDs for certain countries. You can validate tax ID numbers and override the validation process.

See Validating Tax ID Numbers.

Understanding European Union Reporting

Countries that are members of the European Union (EU) observe the Single European Act of 1987. The Single European Act is an agreement that opens markets to an area without internal boundaries, where free movement of goods, persons, services, and capital is assured in accordance with the provisions of the Treaty of Rome.

Because of the Single European Act, businesses in EU countries must adhere to EU requirements. For example, to help monitor the trade among members of the EU, businesses that exceed the limit of intraunion trade must submit these reports to the customs authorities:

• Intrastat Report

• European Community (EC) Sales List

Detailed statistical information regarding merchandise trade between members of the EU is used for market research and sector analysis. To maintain the statistics on trade between EU members, the statistical office of the EU and the statistical departments of member countries developed the Intrastat system.

In compliance with the Intrastat system, information on intraunion trade is collected directly from businesses. If you do business in a country that belongs to the EU, and you use the JD Edwards EnterpriseOne Sales Order Management and JD Edwards Enterprise One Procurement systems, you can set up the system to extract all of the necessary information to meet EU Intrastat reporting requirements.

Intrastat Requirements

Customs formalities and controls at the internal borders between member states of the EU disappeared in 1993 with the creation of the single European market. With the elimination of custom formalities, the traditional systems for collecting statistics on trade between EU member states also disappeared.

Detailed statistical information regarding merchandise trade between members of the EU is important for market research and sector analysis. To maintain the statistics on trade between EU members, the statistical office of the EU and the statistical departments of member countries developed the Intrastat system.

In compliance with the Intrastat system, information on intraunion trade is collected directly from businesses. Periodically, businesses are required to send a statistical declaration or, in some member states, a combined statistical and fiscal declaration that gives detailed information regarding their intraunion trade operations of the previous period. The frequency with which you are required to submit these declarations depends on national requirements.

The major features of the Intrastat system are common in all member states, but the system can take national specifications into account. If you do business in a country that belongs to the EU and you use the JD Edwards EnterpriseOne Sales Order Management and JD Edwards EnterpriseOne Procurement systems, you can extract all of the information that is necessary to meet Intrastat reporting requirements.

Note. The information that is tracked by the Intrastat system is based strictly on the actual physical movement of goods between member countries of the EU. Intrastat information does not apply to the movement of monetary amounts or the placement of orders between member countries.

This flowchart illustrates the Intrastat reporting process:

Intrastat reporting process

Note. JD Edwards EnterpriseOne software does not provide country-specific Intrastat reports.

Intrastat Reporting and the Euro

With the introduction of the euro, the Statistical Office of the European Communities (Eurostat) and the national Statistical Offices of the Economic and Monetary Union (EMU) member nations have changed their Intrastat reporting requirements. Each EMU member nation, however, continues to determine its own Intrastat requirements.

Regardless of whether the company has converted its base currency to the euro, you can handle the Intrastat reporting requirements for the country in which you do business. These examples describe situations that might apply to the company:

• The company has not converted its base currency to the euro, but the Statistical Office of the EMU member nation in which you do business requires that you submit Intrastat reports in the euro.

• The company has converted its base currency to the euro, but the Statistical Office of the EMU member nation in which you do business requires that you submit reports in an alternate currency.

For Intrastat reporting, the as-if currency processing options in the Intrastat generation programs (R0018I1 and R0018I2) provide a simplified approach to reviewing and printing amounts in a currency that is different from the base currency.

Considerations for Creating Intrastat Reports

Before you create Intrastat reports, determine:

• The base currency of each of the companies.

• The currency in which you must submit Intrastat reports for each of the companies.

If the business has multiple companies with multiple currencies, you should approach the Intrastat reporting carefully. You should always be aware of each company's base currency and whether Intrastat reports must be in the euro or an alternate. This information helps to ensure that you convert currencies for Intrastat reporting only if necessary.

Based on the Intrastat reporting requirements for the companies and the countries in which you do business, you can use the processing options and data selection to create different versions of Intrastats - Tax Update - Sales (R0018I1) and Intrastats - Tax Update - Purchasing (R0018I2).

Prerequisites

Before you can collect information for EU reporting, you must perform these tasks:

• Set up tax information for Accounts Payable and Accounts Receivable records.

  See Setting Up Tax Rate Areas.

• Set up UDCs for Intrastat reporting.

• Set up commodity codes.

• For the JD Edwards EnterpriseOne Sales Order Management system, set up country codes for the selling business unit (header business unit), shipping business unit (detail business unit), and customer in the JD Edwards EnterpriseOne Address Book system.

  See Entering Address Book Records, Updating and Purging Address Book Records.

• For the JD Edwards EnterpriseOne Procurement system, set up country codes for the branch/plant and supplier in the JD Edwards EnterpriseOne Address Book system, or enter countries of origin in the Intrastat Item/Supplier Cross Reference program (P744101).

  See Entering Cross-References for Items and Suppliers.

Understanding EC Sales List Reports for European Reporting

If they perform the following functions, businesses in the EU that exceed the local limit of intraunion trade must submit the EC Sales List to their customs authorities on a quarterly basis:

• Supply goods to an entity that is registered for value-added tax (VAT) in another EU-member country.

• Send goods for processing to an entity that is registered for VAT in another EU-member country.

• Return processed goods to an entity that is registered for VAT in another EU-member country.

• Transfer goods from one EU-member country to another EU-member country in the course of business.

  Note. If a sales or purchase transaction is arranged between EU members, but the goods are not shipped, the transaction must still be reported to the government.

You can use either of two EC Sales List programs (R0018L or R0018S) to generate the EC Sales List. Refer to this table to determine which EC Sales List program you should use:

Trade Triangulation

Trade triangulation occurs when one EU member makes a sale or purchase with another EU member, but the goods represented by the transaction are physically shipped from a third EU member. Statistical reports that are submitted to EU authorities must identify trade triangulation transactions. Both the R0018L and R0018S programs identify trade triangulation transactions.

Printing Invoices with an Attached International Payment Instruction

This section provides an overview of international payment instructions, lists prerequisites, and discusses how to:

• Run the Invoice Print with International Payment Instruction program.

• Set processing options for Invoice Print with International Payment Instruction (R03B5053).

Understanding International Payment Instructions

You use international payment instructions (IPIs) for cross-border invoice settlements. When you originate invoices in the JD Edwards EnterpriseOne Accounts Receivable system, you can select to print invoices with an attached IPI form. To print invoices with attached IPI forms, you must use preformatted invoices that contain the IPI form. The system processes and formats data from JD Edwards EnterpriseOne tables, and prints the information in the appropriate places on the IPI form.

IPIs must be printed in English, but they can also contain a second language. Some countries require that you print IPI forms with a secondary language; for some countries, the use of a secondary language is optional. The European Committee for Banking Standards publishes the requirements for IPIs. You specify the secondary language by choosing a value in the IPI - Languages and Countries UDC table (00/IL).

The IPI form contains these four sections:

• Ordering Customer

  This section contains the name, address, and account number of the customer. The system uses the name, address, and account number (CBNK) that are associated with the invoice to which the IPI is attached. The customer sends the IPI to the bank for processing, and the bank credits the account with the specified amount.

• Beneficiary

  This section contains the company name and the bank name and account number that you specify in processing options.

• Amount to be paid

  This section contains the amount and currency of the transaction, as well as a code to indicate who is responsible for paying the bank fees that are associated with the transaction. You specify the code for the bank fees in a processing option; the system uses the amount and currency from the transaction.

• Signature

  The system does not print the signature.

Data Selection

When you set the data selection for the Invoice Print with International Payment Instruction program (R03B5053), you should filter out credit memos and other nonpositive invoices. You can filter out these invoices by specifying that the Amount Open (AAP) is greater than zero. You should also designate in the Payment Instrument UDC table (00/PY) the code to use for invoices with attached IPIs, and then select that payment type in the data selection.

Note. The Invoice Print with International Payment Instruction program does not write error messages to the Work Center; however, you can view error messages in the UBE (universal batch engine) log if you use UBE logging. If the Invoice Print with International Payment Instruction program encounters errors, it prints a blank invoice.

Prerequisites

Set up required UDCs for IPIs.

See Setting Up UDCs for International Payment Instructions.

Running the Invoice Print with International Payment Instruction Program

Select Statement Reminder Processing (G03B22), Invoice Print with International Payment Instruction.

Setting Processing Options for Invoice Print with International Payment Instruction (R03B5053)

Processing options enable you to specify the default processing for programs and reports.

Defaults

Print

Process

Populating the Intrastat Workfile

This section provides an overview of workfile flow generation for Intrastat and discusses how to:

• Generate the workfile for sales.

• Set processing options for Intrastat Workfile Generation - Sales (R0018I1).

• Generate the workfile for procurement.

• Set processing options for Intrastat Workfile Generation - Procurement (R0018I2).

Understanding Work Table Generation for Intrastat

Intrastat reporting is based on the Intrastat Revision table (F0018T). This workfile is populated with information from the JD Edwards EnterpriseOne Sales Order Management, JD Edwards EnterpriseOne Procurement, and other systems. You run Intrastat reports based on the company's sales and procurement transactions for the reporting period. When you do this action, the update process writes all of the required information from the tables in the JD Edwards EnterpriseOne Sales Order and JD Edwards EnterpriseOne Procurement systems to the F0018T table.

This table shows the programs you use to update the F0018T table:

In addition, the update programs collect information from these tables:

• Intrastat Supplier/Item Cross Reference Table (F744101).

• Inventory Constants (F41001).

• Business Unit Master (F0006).

• Company Constants (F0010).

• Currency Codes (F0013).

• Currency Restatement Rates File (F1113).

• Item Master (F4101).

• Item Branch File (F4102).

• Address Book Master (F0101).

• Address by Date (F0116).

• Order Address Information (F4006).

• Item Units of Measure Conversion Factors (F41002).

• Unit of Measure standard conversion (F41003).

• User-Defined Codes (F0005).

When you run the update programs, you use processing options and data selections to select transactions that are based on a number of different criteria in the sales and procurement tables. Depending on the structure of the company and country-specific reporting requirements, you can specify that the system write records at cost, cost plus markup, or at the taxable purchase price. If you want to report the quantity actually shipped rather than the quantity ordered, you can use data selection to select order lines from the sales and procurement tables that are based on the order activity rule that corresponds to the shipped status. The system verifies that the transactions meet the selection criteria and qualify for Intrastat reporting before writing the required information from the sales and procurement tables, and any other applicable information from the additional tables, to the Intrastat Revision table.

To ensure that table F0018T contains the most current information, you should periodically update the information in table F0018T. The update program for sales accesses the detail for the sales transactions in table F4211. If you automatically purge the sales details to the Sales Order History File table (F42119) when you run the Sales Update program (R42800), run the Intrastat generation program for sales after you confirm shipments and before you update sales information. You should update table F0018T at least once per reporting period, after all sales order and purchase order transactions are entered and finalized.

Note. If you change sales order or purchase order information after you generate table F0018T, the changes are not reflected in the F0018T table unless you regenerate the table or manually edit the table using the Intrastat Revision program (P0018T).

See Revising Intrastat Information.

Transaction Eligibility

Sales order transactions are not eligible for Intrastat reporting if either the Sold To country or the Ship To country is the same as the Declarant country, or if any of these countries (Sold To, Ship To, or Declarant) is not in the European Union.

Procurement transactions are not eligible for Intrastat reporting if either the Supplier country or the Ship From country is the same as the Declarant country, or if any of these countries (Supplier, Ship From, or Declarant) is not in the European Union.

The system retrieves the Ship To country from the Order Address Information table (F4006) if a record exists. Otherwise, the system retrieves the Ship To country from the Sales Order Detail File table (F4211).

The system retrieves the Ship From country by searching these tables in sequence:

1. Country (CTR) in the Address by Date table (F0116), using the supplier's address book record

2. Country (CTR) in the Order Address Information table (F4006)

3. Country of Origin (ORIG) in the Intrastat Supplier/Item Cross Reference table (F744101)

In table F744101, the Country of Origin (ORIG) is used to determine transaction eligibility for Intrastat reporting. The Original Country of Origin (ORGO) is for information only. The Original Country of Origin field is populated by the Country of Origin (ORIG) field in the Item Branch File table (F4102) when you generate table F0018T.

You must include codes for all European Union countries as valid values on UDC 74/EC (European Community Members).

Important! Changes to transaction eligibility that occur after you generate table F0018T are not recognized when you regenerate table F0018T using the processing option to refresh it. Oracle recommends that you generate table F0018T only after you have completed all relevant changes to shipping and receiving information for the reporting period. If you must override addresses and change the transaction eligibility after generating table F0018T, you should clear and completely regenerate table F0018T.

Triangulation

The Intrastats - Tax Update - Sales program (R0018I1) includes processing options for triangulation. However, the program has no logic to identify triangulation. Rather, the processing options enable you to indicate how to process interbranch records. If you use the processing options, the header branch/plant from table F4211 is written to table F0018T as the declaring company. Using the processing options also affects the document type and the taxable amount. Three separate taxable amounts can be written to the TAXA field in the Intrastat Revision table:

• The amount extended price (AEXP).

• The amount original cost (ECST).

• The amount total extended cost (TCST).

The amounts are retrieved for the header or detail branch/plant, depending on the processing option fields that you choose.

If you do not use the triangulation processing options, the detail branch/plant from table F4211 is always written to table F0018T as the declaring company; and the document type is always the type that is entered on the sales order.

For the Intrastats - Tax Update - Purchase program, you can specify the actual Ship From in table F4006. For example, suppose that the purchase order specifies the branch/plant (declarant) as Italy, and the supplier as Switzerland. However, when the goods are received, the customs note indicates that the goods were shipped from France. You should specify the actual Ship From in the Order Address table as France to ensure that the transaction is included in the Intrastat Revision table correctly.

Multicurrency Environments

In multicurrency environments, the system creates records in table F0018T based on the base currency of the Sales branch/plant or the Purchasing branch/plant for each transaction.

You might need to restate the domestic amounts of foreign transactions at an official exchange rate or a monthly average exchange rate. To do this restatement, use the processing options on the Currency tab to indicate the exchange rate type and the date for the exchange rate. The system recalculates the domestic amount based on the rate and date that are indicated in the processing options. The exchange rate is taken from table F1113.

As If Currency Processing

To use as if currency processing for the Intrastats - Tax Update - Sales and Intrastats - Tax Update - Purchasing programs, you must set processing options. These programs, unlike other programs that use as if currency processing, write amounts to a table. Other programs display or print as if currency amounts, but do not write amounts to a table.

If you use as if currency processing, you lose the direct audit trail for the amount fields between table F0018T and the original tables in the JD Edwards EnterpriseOne Sales Order Management and JD Edwards EnterpriseOne Procurement systems.

Example of Company and Intrastat Reporting in Different Currencies

The corporate office is located in England and has three branch companies, each with a different base currency. You must submit all Intrastat reports in British pounds (GBP). This table shows the companies and base currencies:

For Intrastat reporting purposes, consider these guidelines:

• For company 1, do not run the Intrastats - Tax Update - Sales (R0018I1) and Intrastats - Tax Update - Purchasing (R0018I2) programs. The company base currency and Intrastat reporting currency are the same.

• For company 2, run the Intrastats - Tax Update - Sales and Intrastats - Tax Update - Purchasing programs to update EUR amounts to GBP.

• For company 3, run the Intrastats - Tax Update - Sales and Intrastats - Tax Update - Purchasing programs to update CAD amounts to GBP.

For companies 2 and 3, run the programs to load information in the Intrastat Revision table (F0018T) and update the amounts. Do this one company at a time, creating a separate version for each company. For both companies, specify GBP and the exchange rate date in the processing options for as if currency.

Performance Considerations

Depending on the data selection and the number of transactions stored in the JD Edwards EnterpriseOne Sales Order Management and JD Edwards EnterpriseOne Procurement systems, the time that is required to run the Intrastat Generation programs varies. Complete these tasks to minimize the impact that these programs have on system performance:

• Specify the data selection as carefully as possible so that only the necessary records are written to table F0018T.

• Update table F0018T as part of the nightly operations.

Generating the Intrastat Workfile for Sales

Select Periodic Processing (G74STAT2), Intrastat Workfile Generation - Sales.

Setting Processing Options for Intrastat Workfile Generation - Sales (R0018I1)

Processing options enable you to specify the default processing for programs and reports.

Transaction

Defaults

Currency

Process

These processing options specify the triangulation records that the system creates. Enter the value to be used followed by the document type for the record. Values are:

Blank: Record not created

1: Price

2: Cost

3: Transfer Cost

Omit the document type to use the original document type.

For example:

3SI: Specifies Transfer Cost, Document Type SI

2: Specifies Cost, Original Document Type

Generating the Intrastat Workfile for Procurement

Select Periodic Processing (G74STAT2), Intrastat Workfile Generation - Purchase.

Setting Processing Options for Intrastat Workfile Generation - Procurement (R0018I2)

Processing options enable you to specify the default processing for programs and reports.

Process

Defaults

Currency

Revising Intrastat Information

You can revise existing data in the Intrastat Revision table (F0018T). You might need to do this revision to correct missing or inaccurate information, to add a specific transaction, to update the process indicator, or to enter information in fields that are required by the authorities but are not populated by the system. You can also use the Intrastat Revision program (P0018T) to update sales order or purchase order information that has changed since you generated table F0018T.

Prerequisite

Run the Intrastats - Tax Update - Sales (R0018I1) and Intrastats - Tax Update - Purchasing (R0018I2) programs to build the Intrastat Revision table (F0018T).

See Populating the Intrastat Workfile.

Form Used to Revise Intrastat Information

Revising Intrastat Information

Access the Intrastat Tax File Revision form.

Detail

Amounts

Access the Amounts tab.

Net Mass in KG (net mass in kilograms)	Enter the net mass of the product as expressed in kilograms. The system extracts this value from the Sales Order Detail File (F4211) table or the Purchase Order Receiver File (F43121) table.
Base Currency	Enter a code that identifies the currency of a transaction.
Taxable Amount	Enter the amount on which taxes are assessed.
Statistical Value Amount	(FRA) In France, enter the nominal costs covering the transport and insurance costs of a shipment to the exit point of the country. Traditionally, the statistical value is a fixed cost per order, percentage, or both of the order amount. This value is commonly required for VAT reporting in France. Countries other than France might use a statistical value and might define it differently. For EU tax reporting purposes, the user supplies this data. You can update the value by using the Intrastat Workfile Revision program (P0018T).
Transaction Currency	Enter a code that identifies the domestic (base) currency of the company on a transaction.
Foreign Taxable Amount	Enter that portion of the sale that is subject to tax in foreign currency.
Foreign Statistical Value	(FRA) The statistical value is commonly required for VAT reporting in France. Although it can be used in other countries, France defines the statistical value to be the nominal costs covering the transport and insurance of a shipment to the exit point of the country. Traditionally it is a fixed cost per order, percentage, or both of the order amount. For EU tax reporting purposes, the user supplies this data. It can be updated using the Intrastat Workfile Revision program (P0018T).
Supplementary Units	Enter the total number of items on a purchase or sales order. This total is updated in the Intrastat Revision table (F0018T) only if the primary weight is zero.

Codes

Access the Code tab.

Country of Origin	Enter a code (00/CN) that identifies the country in which an item originates. This information is useful to organizations that must periodically separate their inventory by source.
Original Country of Origin	Enter a code (00/CN) that indicates the original country of origin of goods. For example, you are a German company that places a purchase order with a French supplier for goods that are manufactured in France but are warehoused in and delivered from Belgium. The country of origin is Belgium, but the original country of origin is France.
Region of Origin or Destination	For EU VAT reporting, certain countries require the region of origin or destination information. The region of origin is taken from the region code (state code) in the address book record of either the ship-to address (in the case of a dispatch) or the supplier (in the case of arrivals).
Mode of Transport	Enter a UDC (00/TM) that describes the nature of the carrier being used to transport goods to the customer, for example, by rail, by road, and so on.
Conditions of Transport	The conditions of transport (or terms of delivery) are taken from the Sales Order Header File table (F4201) or the Purchase Order Header table (F4301). The Terms of Delivery field (FRTH) in the header file is only one character. To obtain the required three-character explanation for EU VAT reporting, the second explanation of category code 42/FR is used. Set up a UDC 00/TC to correspond to the three-character explanation. Sample codes include: EXW: Ex Works FOB: Free On Board CIF: Cost, Insurance, and Freight DDP: Delivered Duty Paid DDU: Delivered Duty Unpaid xxx: Others
Nature of Transaction	Defines whether the movement of goods is for sale, lease, and so on. For EU VAT reporting, you can enter the nature of transaction codes using one of the UDCs on the Sales Order Detail Revisions form or the Order Detail form (for Procurement). For Procurement, use UDCs 41/P1 through 41/P5. For Sales, use UDC 40/S1 through 40/S5. The Intrastat Workfile Generation - Sales program (R0018I1) and Intrastat Workfile Generation - Purchase program (R0018I2) update the information in the Intrastat Revision table (F0018T) if you specify the UDC that you are using (41/P1 through 41/P5 or 40/S1 through 40/S5) in the appropriate processing option on the generation program. You can also enter the data directly in the Intrastat Workfile Revision program (P0018T).
Port of Entry or Exit	Enter the port from which or to which the goods were shipped. For VAT reporting, certain countries require information about the port of exit or entry. This information is not available in the system at the present time. You specify the port of entry or exit when creating a purchase order by using the PO Receipts program (P4312), when creating a sales order by using the Sales Order Entry program (P4210), when confirming shipments by using the Shipment Confirmation program (P4205), or by using the Intrastat Revision program (P0018T). Set up values in UDC 40/PE.
Nature of VAT Regime	Enter a code from the INTRASTAT Regime Code UDC table (00/NV). This code is similar to the Nature of Transaction code (NAT) and is applicable only to certain countries. The system does not automatically supply this data. You enter the data using the Intrastat Workfile Revision program (P0018T). (FRA) Nature of VAT Regime is commonly used in France.
Nature Code	Enter an indicator for European Union VAT reporting. The system cannot supply this data automatically. If this information is required for VAT reporting in the country, enter the data using the Intrastat Workfile Revision program (P0018T).
Process Indicator	Enter an indicator for European Union VAT reporting. Values are: Blank: Record not processed 1: Record processed 2: No processing required The Intrastat reports select only unprocessed records (Process Indicator = Blank). You enter a value of 2 to exclude a specific record from the Intrastat report. For instance, if a supplier in the European Union ships a specific order from a country outside of the European Union, the order needs to be excluded from Intrastat reporting. The system does not supply this data automatically. For VAT reporting, you enter data using the Intrastat Workfile Revision program (P0018T).
Commodity Code	Enter the commodity code number for the item.

Purging Records from the Intrastat Table (F0018T)

This section provides an overview of the purge process and discusses how to:

• Run the Intrastat Workfile Purge Program.

• Set processing options for Intrastat Workfile Purge (R0018TP).

Understanding the Purge Process

The Intrastat Revision table (F0018T) is a temporary workfile that stores information that is used to generate monthly or quarterly Intrastat declarations. After the declarations have been accepted by the tax authority, the data in this file continues to accumulate. You do not need to store this data.

You can purge records from table F0018T. You can use data selection to purge all of the records in the file or purge only selected records. You can specify selection criteria based on the invoice date, general ledger date, procurement date, or shipment date. For example, you might purge records with shipment dates between March 1, 2005 and May 1, 2005.

You can run Intrastat Workfile Purge (R0018TP) in proof mode or final mode. Run the program in proof mode to review which records will be deleted. No records are deleted until you run the report in final mode.

Running the Intrastat Workfile Purge Program (R0018TP)

Select Periodic Processing (G74STAT2), Intrastat Workfile Purge.

Setting Processing Options for Intrastat Workfile Purge (R0018TP)

Processing options enable you to specify the default processing for programs and reports.

Defaults

Use these processing options to specify whether to run the program in proof or final mode, and to specify the dates to use to select transactions.

Using the IDEP/IRIS Interface for Intrastat Reporting

This section provides an overview of the IDEP/IRIS interface, lists prerequisites, and discusses how to:

• Run the IDEP/IRIS Interface (R0018I3) program.

• Set processing options for IDEP/IRIS Interface (R0018I3).

Understanding the IDEP/IRIS Interface for Intrastat Reporting

IDEP/IRIS is an abbreviation for Intrastat Data Entry Package/Interactive Registration of the International Trade Statistics. Use the IDEP/IRIS Interface program (R0018I3) to generate an electronic Intrastat declaration in the format required for each country. This table illustrates the countries that are associated with each format:

Intrastat declarations are based on the information in the Intrastat Revision table (F0018T). Although the information that is required to appear on the Intrastat report is common for most EU members, reporting requirements vary by country.

Note. Neither the IDEP/CN8 format nor the CBS-IRIS format requires a specific file layout.

IDEP/CN8 - France, Italy, Spain, Austria, Belgium, Sweden, Denmark, Finland, Portugal, Greece, Ireland, and Luxembourg

IDEP/CN8 includes an option to import the data that is necessary for the statistical declaration from an external administrative and financial system. IDEP/CN8 does not require a fixed record layout for the import file. You need to define the format of the data to be imported in IDEP/CN8. IDEP/CN8 can automatically perform the required conversions and validations of the data, and produce the declaration.

In IDEP/CN8, you can import this information:

• Detail lines.

• Good codes for the provider of statistical information.

• VAT registration numbers of trading partners.

• Exchange rates.

Although you can import all of the preceding information, the interface with IDEP/CN8 enables you to import only the detail lines and the VAT registration numbers or the trading partners. For sales transactions, the VAT registration number of the customer is based on the declaration type. For statistical declarations, the system uses the value in the Ship To - Address Number field. For fiscal or complete declarations, the system uses the Sold To - Address Number. Because the default declaration type is complete, the VAT registration number uses the Sold To - Address Number. For procurement transactions, the system uses the VAT registration number of the supplier.

Grouping Transactions

To group transactions for sales, purchases, and adjustment declarations, set up versions of the IDEP/IRIS Interface program (R0018I3) that have data selection for sales orders, purchase orders, adjustments for sales orders, and adjustments for purchase orders based on document type.

Electronic Format

Use the IDEP/IRIS Interface program (R0018I3) to create a flat file in the IDEP/IRIS message format, which you can than submit to the proper tax authorities in an electronic format.

The IDEP/IRIS Interface program generates one record for each declaring company.

When you run the IDEP/IRIS Interface program, the system creates a batch for review by the Text File Processor program (P007101). The batch is stored in these tables:

• F007101 - Text Processor Header

• F007111 - Text Processor Detail Table

You must run the Text File Processor program to convert the batch to a flat file that you can submit to the different countries' customs authorities, statistical offices, or both.

The Text File Processor program assigns the batch number and interchange from the seventh field of next numbers for system 00. The Text File Processor assigns the message number from the fifth field of next numbers for system 74.

Prerequisites

Before you complete the tasks in this section:

• Run the Intrastats - Tax Update - Sales (R0018I1) and Intrastats - Tax Update - Purchasing (R0018I2) programs to build the Intrastat Revision table (F0018T).

• Set up the layouts that you need.

Running the IDEP CN8/IRIS Interface Program (R0018I3)

Select Statistical Reports (G74STAT3), IDEP CN8/IRIS Interface.

Setting Processing Options for IDEP CN8/IRIS Interface Program (R0018I3)

Processing options enable you to specify the default processing for programs and reports.

Defaults

Process

Currency

Rounding

Print

(GBR) Using the SEMDEC Interface for Intrastat Reporting

This section provides an overview of the SEMDEC interface, lists prerequisites, and discusses how to:

• Run the UK SEMDEC Interface program (R0018I4).

• Set the processing options for UK SEMDEC Interface (R0018I4).

Understanding the SEMDEC Interface for Intrastat Reporting

SEMDEC is the acronym for Single European Market Declaration.

Intrastat reports are based on the information in the Intrastat Revision table (F0018T). Although the information that is required to appear on the Intrastat report is common for most EU members, report formats vary from country to country.

As of January 1, 1999, businesses in the United Kingdom can submit Intrastat information to HM Customs and Excise in any of three formats:

• Electronic (using diskette, magnetic tape, or electronic mail).

• Preprinted government form (paper).

• Government form posted on the internet.

Electronic Format

Use the UK SEMDEC Interface program (R0018I4) to create a flat file in the SEMDEC message format, which can be submitted to HM Customs and Excise on a diskette.

Note. The SEMDEC message format combines the information from the Intrastat Revision table that is required for the declaration of Intra EC Trade Statistics and the EC Sales List.

Businesses in the United Kingdom do not need to submit the EC Sales List report.

When you submit the UK SEMDEC Interface program (R0018I4) to create the EC Sales List, the system submits the SEMDEC Interface - Intra EC Trade Statistics program (R0018I41) to create the Intra EC Trade Statistics report.

You must use the Text File Processor tool to create a flat file in the SEMDEC message format that contains the EC Sales List and Intra EC Trade Statistics information. Text File Processor information is stored in these files:

• F007101 - Text Processor Header

• F007111 - Text Processor Detail

You must use the Text File Processor program (P007101) to copy the text batch that is generated by the SEMDEC Interface programs (R0018I4 and R0018I41) to a flat file that you can submit to HM Customs and Excise.

HM Customs and Excise provides these file names for the flat file in the SEMDEC message format:

• KEDCSD.TRX - use for live data.

• KEDCSD.TST - use for test data.

You should use these names when you copy the SEMDEC text batch in the Text File Processor.

Important! HM Customs and Excise rejects any submission that contains lowercase letters. Verify that the company name has been entered in all uppercase letters in the Companies program (P0010), or enter the company name in the processing options of the SEMDEC Interface program (R0018I4).

Data Selection

You can run the UK SEMDEC Interface program (R0018I4) for a single declaring company, or you can consolidate multiple companies to declare their information under a single company's VAT registration number.

Use data selection to list the company or companies for which you are declaring Intrastat information. If you list more than one company in the data selection, the system consolidates the statistical information for these companies on the report.

If you list only one company in the data selection, that company's name appears in the header of the report as the reporting company. If you list multiple companies in the data selection, you must enter the address book number of the declaring company in the processing options of the UK SEMDEC Interface program. If you list multiple companies in the data selection but do not complete the processing option, the system prints the name, address, and VAT registration number of company 00000 in the header of the report.

You must use matching data selection for Company on UK SEMDEC Interface and SEMDEC Interface - Intra EC Trade Statistics (R0018I41) programs. You should also use data selection on UK SEMDEC Interface to select sales transaction only. You do not need to include corresponding data selection for sales transactions on SEMDEC Interface - Intra EC Trade Statistics.

Government Forms

JD Edwards EnterpriseOne software does not provide a printed version of the Intrastat report on government forms.

Submission Deadlines

Intra EC Trade Statistics must be submitted monthly by the tenth working day of the following month to HM Customs and Excise, although you can submit them more frequently. HM Customs and Excise combines submissions from the same month to produce a monthly total.

In contrast, the EC Sales List is required quarterly within six weeks of the calendar quarter end, but it can also be submitted monthly. When you submit the EC Trade Statistics and EC Sales List together, they must be submitted monthly to meet the EC Trade Statistics due date. You must advise the local VAT office if you intend to submit the electronic EC Sales List monthly.

Prerequisites

Before you complete the tasks in this section:

• Set up UDC 74/TD for arrivals and dispatches.

• Run the Intrastats - Tax Update - Sales (R0018I1) and Intrastats - Tax Update - Purchasing (R0018I2) programs to build the Intrastat Revision table (F0018T).

• Set up next numbers for the Text File Processor.

  The Text File Processor assigns the batch number and interchange from line 7 of Next Numbers System 00. The Text File Processor assigns the message number from line 5 of Next Numbers System 74.

Running the UK SEMDEC Interface Program (R0018I4)

Select Statistical Reports (G74STAT3), UK SEMDEC Interface.

Setting Processing Options for UK SEMDEC Interface (R0018I4)

Processing options enable you to specify the default processing for programs and reports.

Defaults

These processing options let you specify information about the declaring company and the agency submitting the declaration.

Process

These processing options let you specify whether to run the report in test or live format, and whether the declarant or an agency is submitting the declaration.

Currency

This processing option lets you report amounts in either the domestic currency or the currency of the Intrastat Revision table (F0018T).

Print

These processing options do not control the selection of records from the Intrastat workfile. Complete these processing options to meet the HM Customs and Excise requirement that the submission include the reporting period and year.

Print

Version

(DEU) Printing the German Intrastat Report

This section provides an overview of the German Intrastat report and discusses how to:

• Run the Germany Electronic Submission (R0018IGF).

• Set processing options for Germany Electronic Submission (R0018IGF).

Understanding the German Intrastat Report

You print Intrastat reports based on the information in the Intrastat Revision table (F0018T). Although the information that is required to appear on the Intrastat report is common for most EU members, report formats vary from country to country.

The Germany Electronic Submission program (R0018IGF) creates a flat file that can be copied to a magnetic tape that is sent to the German Statistical Office.

When you run the Germany Electronic Submission program, the Process Indicator field in table F0018T is updated to the value 1 to indicate that the record has been processed. You can use the processing options to specify that this value not be updated.

Running the Germany Electronic Submission (R0018IGF)

Select Statistical Reports (G74STAT3), Germany Electronic Submission.

Setting Processing Options for Germany Electronic Submission (R0018IGF)

Processing options enable you to specify the default processing for programs and reports.

Identification

Shipping

Label

Tax Number

Report Period

Printing the EC Sales List Report (R0018L)

This section provides an overview of the EC Sales List program, lists prerequisites, and discusses how to:

• Run the EC Sales List report (R0018L).

• Set processing options for EC Sales List (R0018L).

Understanding the EC Sales List

You can print the EC Sales List (R0018L) in summary or detail mode. Detail mode provides information for auditing.

If you print in summary mode, the EC Sales List provides this information about customers:

• VAT number.

• Country of destination.

• Total amount in reporting currency.

• Triangulation.

If you print in detail mode, the EC Sales List provides this information about customers in addition to the preceding information:

• Company order number

• Order type

• Country of sale

• Country of shipment

Triangulation

Triangulation can be reported in summary and detail mode in either of the methods illustrated in this table:

Data Selection

You must run the EC Sales List separately for each VAT-registered company in the organization.

If you have interbranch shipments from branch/plants that are located in countries other than the country of the headquarters organization, you must submit the EC Sales List for each country within which you operate.

For example, if a German company has three branch/plants in Germany, one branch/plant in France, and one branch/plant in Denmark, that company must run the EC Sales List three times:

• For the three branch/plants in Germany.

• For the branch/plant in France.

• For the branch/plant in Denmark.

To run the EC Sales List for the branch/plants in each country, set up data selection with Document Company (KCO) equal to the company number of the headquarters company, and Company (CO) equal to the companies that are associated with each branch/plant.

Note. The companies that are associated with the branch/plants must be set up with the country code that corresponds to the location of the branch/plant.

In the preceding example, you would run the EC Sales list with this data selection:

For branch/plants in Germany:

• Document Company (KCO) = German company.

• Company (CO) = company for German branch/plant 1.

• Company (CO) = company for German branch/plant 2.

• Company (CO) = company for German branch/plant 3.

For the branch/plant in France:

• Document Company (KCO) = German company.

• Company (CO) = company for French branch/plant.

For the branch/plant in Denmark:

• Document Company (KCO) = German company.

• Company (CO) = company for Danish branch/plant.

Prerequisites

Before you complete the tasks in this section:

• Enter VAT registration numbers for each customer.

• Enter country codes for each customer.

• Run the Intrastats - Tax Update - Sales (R0018I1) and Intrastats - Tax Update - Purchasing (R0018I2) programs to build the Intrastat Revisions table (F0018T).

Running the EC Sales List Report (R0018L)

Select Statistical Reports (G74STAT3), EC Sales List.

Setting Processing Options for EC Sales List Report (R0018L)

Processing options enable you to specify the default processing for programs and reports.

Process

Use these processing options to specify whether to print the report in summary or detail mode, and to specify the triangulation method to use.

Print

Use these processing options to specify the reporting period for the report.

Currency

Specify the currency code for as if currency processing.

Printing the EC Sale List - AR Report (R0018S)

This section provides an overview of the EC Sale List - AR (R0018S) program, lists prerequisites, and discusses how to:

• Run the EC Sales List - AR report (R0018S).

• Set processing options for EC Sale List - AR (R0018S).

Understanding the EC Sales List - AR Report (R0018S)

You can print the EC Sale List - AR (R0018S) in summary or detail mode. If you print in summary mode, the EC Sale List - AR provides this information about customers:

• Country of destination.

• Customer VAT registration number.

• Total value of supplies.

• Triangulation (yes or no).

• (Optional) Customer name and address.

If you print in detail mode, the EC Sale List - AR also includes the document number.

The EC Sale List - AR includes this information in the report header:

• Reporting company VAT registration number.

• Reporting company currency code.

• Company name and address.

The report header can also include the approval code of the EC authority to whom the report will be submitted.

Information about the report is sequenced by company, address book number, tax ID, and document number. Line numbering and page numbering restart for each reporting company.

Prerequisites

Before you complete the tasks in this section:

• Enter VAT registration numbers for each customer.

• Enter country codes for each customer.

• Set up tax rules for both the JD Edwards EnterpriseOne Accounts Receivable and JD Edwards EnterpriseOne Accounts Payable systems with these options selected:

  • Tax on Gross Including Discount

  • Discount on Gross Including Tax

    See Setting Up Tax Rules by Company.

• Set the processing options in the General Ledger Post Report program (R09801) to automatically update the Taxes table (F0018).

• Set up the UDC for Triangulation Tax Rates (00/VT).

Running the EC Sales List - AR Report (R0018S)

Select Statistical Reports (G74STAT3), EC Sale List - AR.

Setting Processing Options for EC Sales List - AR (R0018S)

Processing options enable you to specify the default processing for programs and reports.

Select

Process

Display

As-If-Currency

Approval Code