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:
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.
The International Organization for Standardization (ISO) and the European Committee for Banking Standards (ECBS) developed the International Bank Account Number (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:
Segment |
Definition |
Country code |
A two-letter country code as specified by ISO. The country code used in the IBAN is the code of the county in which the bank or branch that is servicing the IBAN resides. |
Check digits |
Two digits that are assigned according to an algorithm. |
Basic Bank Account Number (BBAN) |
An alphanumeric string of characters of up to 30 characters that includes 0-9 and A-Z in upper case letters only. The electronic format cannot contain separators or county-specific characters. The length of the BBAN is determined by the country of origin, and includes an explicit identification code of the bank or branch servicing the account at a fixed position within the BBAN. |
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 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:
Table Column Heading |
Example for Belgium |
Example for France |
Account Number |
510-0075470-61 |
20041 01005 0500013M026 06 |
Electronic IBAN format |
BE62510007547061 |
FR1420041010050500013M02606 |
Print IBAN format |
IBAN BE62 5100 0754 7061 |
IBAN FR14 2004 1010 0505 0001 3M02 606 |
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.
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:
Italy
France
Belgium
Finland
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 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 Exception Report (R00314).
The system validates account and bank identification information throughout the draft process:
Process |
Function |
The system prints an error report that lists customers with missing or invalid bank information. You can review the list to correct or update the bank information before you generate the drafts. |
|
When you remit drafts, the system validates bank information again and includes the drafts for all of the specified customers in the electronic bank file. The system prints an error report that lists the customers with missing or invalid bank information. |
Bank ID Validation Overrides
You can override bank ID validation for a specific country by adding the country code to UDC 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.
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 pre-authorized 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:
Program |
Function |
Bank Account Information (P0030G) |
The system issues an error on the Revise Bank Information form if bank information is missing or invalid. |
Bank Account Cross-Reference (P0030A) |
If the Localization Country Code field in the User Profile Revisions form is not blank and the customer, supplier, or employee country code on the Address Book Revision form is IT (Italy), the system issues an error on the Set Up Bank Accounts By Address form if bank information is missing or invalid. |
Enter Our Drafts or Enter Customer Drafts (P03B602) |
The system issues an error on the Draft Entry form if bank information is invalid. |
Pre-Authorized Drafts (R03B671) |
The system prints an error report that lists customers with missing or invalid bank information. You can review the list to correct or update the bank information before you generate the drafts. |
When you remit drafts, the system validates bank information again and includes the drafts for all of the specified customers in the electronic bank file. The system prints an error report that lists the customers with missing or invalid bank information. |
The system validates tax IDs for certain countries.
See (Europe) Setting Up Intracommunity VAT.
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 the 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).
Before you can collect information for European Union reporting, you must perform these tasks:
Set up tax information for Accounts Payable and Accounts Receivable records.
Set up user-defined codes 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).
If they perform the following functions, businesses in the European Union (EU) that exceed the local limit of intra-union 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:
EC Sales List (R0018L) |
EC Sale List - AR (R0018S) |
Retrieves trade information from Supply Chain. |
Retrieves trade information from Financials. |
Bases results on information in the Intrastat Revision table (F0018T). |
Bases results on information in the Taxes table (F0018). |
Reports trade triangulation in summary and detail mode. You can report triangulation for interbranch transactions, direct ship transactions, or both. |
Uses tax rates from the Triangulation Tax Rates UDC (00/VT) to identify trade triangulation. |
Can exclude nonstock items. Use data selection on the Intrastat generation programs (R0018I1 and R0018I2) to exclude nonstock items. |
Cannot distinguish between stock and nonstock items; use this report only if the business does not provide services. |
Does not net trade amounts based on credit memos, discounts, and write-offs. |
Nets trade amounts based on credit memos, discounts, and write-offs. |
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.
This section provides an overview of International Payment Instructions and discusses how to:
Run the Invoice Print with International Payment Instruction program.
Set processing options for Invoice Print with International Payment Instruction (R03B5053).
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.
When you set the data selection for the Invoice Print with International Payment Instruction program (R03B5053), you should filter out credit memos and other non-positive 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 log if you use UBE logging. If the Invoice Print with International Payment Instruction program encounters errors, it prints a blank invoice.
Set up required UDCs for IPIs.
See Setting Up UDCs for International Payment Instructions.
Select Statement Reminder Processing (G03B22), Invoice Print with International Payment Instruction.
Processing options enable you to specify the default processing for programs and reports.
Defaults
1. Invoice Print Date |
Specify the date that the system prints on the invoices. If you leave this processing option blank, the system uses the current date. |
2. Customer Bank Account Type |
Specify the type of bank account of the ordering customer. The system uses this account type code to retrieve the bank account number of the ordering customer. The code you enter must exist in the Bank Type Code UDC (00/BT) table. If you leave this processing option blank, the system uses bank type D. |
3. Customer Address Format |
Specify the IPI - Address Line Sequencing code (UDC 00/IA). This code determines the combination of the values for the Postal Code, City, and Country that the system includes as the second address line of the ordering customer's address on the IPI. The code that you enter must exist in the IPI - Address Line Sequencing (00/IA) UDC table. If you leave this processing option blank, the system uses 00 (Postal Code City). |
4. Beneficiary Bank Account |
Specify the beneficiary's G/L bank account number on the IPI. The system uses this account number to locate the corresponding bank account information from the Bank Transit Master table (F0030), including the IBAN (International Bank Account Number) and SWIFT bank identification code. If you leave this processing option blank, the system uses the account associated with AAI item RB. |
5. Beneficiary Bank Account Format |
Use this processing option to define the beneficiary's bank account format on the IPI. Typically, you use the IBAN from the Bank Transit Master table (F0030). In some cases you can use a national account number (CBNK) from the Bank Transit Master table instead of the IBAN. Values are: Blank: Use the IBAN as the bank account format. 1: Use the CBNK as the bank account format. |
6. Beneficiary Bank Name |
Use this processing option to define the beneficiary's bank name on the IPI. The IPI allows you to present the bank name in one of two formats. You can either use the SWIFT Bank Identification Code (BIC), stored as SWFT in the Bank Transit Master table (F0030), or you can use the name of the bank. Values are: Blank: Use the BIC code. 1: Use the bank name. |
7. Details of Payment |
Specify the data that appears in the Details of Payment section on the IPI. You select a hard-coded value from the IPI - Details of Payment UDC table (00/IP). If you leave this processing option blank, the system uses 00. Values are: 00: Unstructured - DOC. The system writes the value from the DOC field in the Customer Ledger (F03B11) table to the Details of Payment section of the IPI. 01: Unstructured - DOC, DCT, & CO. The system concatenates the values in the DOC, DCT, and CO fields in the F03B11 table and writes the concatenated string to the Details of Payment section of the IPI. 02: Unstructured - DOC & AN8. The system concatenates the values in the DOC and AN8 fields in the F03B11 table and writes the concatenated string to the Details of Payment section of the IPI. |
8. Charges Paid By |
Specify the entity responsible for paying the bank charges associated with the International Payment Instruction (IPI). The value that you enter must exist in the IPI - Charges Paid By UDC table (00/IC). If you leave this processing option blank, the system uses 0 (Ordering Customer). Values are: 0: Ordering Customer 1: Beneficiary 2: Shared/Both |
9. IPI Form Type |
Specify the type of preformatted form to use. The value that you enter must exist in the IPI - Form Types UDC table (00/IF). If you leave this processing option blank, the system uses 03 (Black - Unstructured). Values are: 00: Blind Colour - Structured 01: Blind Colour - Unstructured 02: Black - Structured 03: Black - Unstructured 04: Drop Out - Structured 05: Drop Out - Unstructured |
1. Tax Amounts |
Specify whether tax amounts appear on the invoices. Values are: Blank: Tax amounts do not appear on invoices. 1: Tax amounts appear on invoices. |
2. Attachments |
Specify whether generic text that is associated with the invoice appears on the invoice. Values are: Blank: Do not include generic text attachment. 1: Include generic text attachment. |
3. Customer Bank Account Number |
Specify whether the customer's bank account number appears on the IPI portion of the invoice. Values are: Blank: Do not include the customer's bank account number. 1: Include the customer's bank account number. |
4. Customer Name and Address |
Specify whether the name and address of the customer appears on the IPI portion of the invoice. Values are: Blank: Do not include the customer's name and address. 1: Include the customer's name and address. |
5. Details of Payment |
Specify whether the system completes the payment details section on the IPI portion of the invoice. Values are: Blank: Do not complete the payment details section. 1: Complete the payment details section. The system prints in the payment details section the data that you specified in the Details of Payment processing option on the Defaults tab. |
6. Charges To Be Paid By |
Specify whether the system completes the charges to be paid section on the IPI portion of the invoice. Values are: Blank: Do not complete the charges to be paid section. 1: Complete the charges to be paid section. |
7. IPI Currency and Currency Amounts |
Specify whether the currency and amount appear on the IPI portion of the invoice. Values are: Blank: Do not print the currency and amount. 1: Print the currency and amount. |
1. Maximum IPI Amount |
Specify the maximum amount allowed for an IPI. If the IPI is greater than this amount, the system will not generate an IPI. If you leave this field blank, the system uses 999,999.99 as the maximum IPI amount. |
1. Tax Amounts |
Specify whether tax amounts appear on the invoices. Values are: Blank: Tax amounts do not appear on invoices. 1: Tax amounts appear on invoices. |
2. Attachments |
Specify whether generic text that is associated with the invoice appears on the invoice. Values are: Blank: Do not include generic text attachment. 1: Include generic text attachment. |
3. Customer Bank Account Number |
Specify whether the customer's bank account number appears on the IPI portion of the invoice. Values are: Blank: Do not include the customer's bank account number. 1: Include the customer's bank account number. |
4. Customer Name and Address |
Specify whether the name and address of the customer appears on the IPI portion of the invoice. Values are: Blank: Do not include the customer's name and address. 1: Include the customer's name and address. |
5. Details of Payment |
Specify whether the system completes the payment details section on the International Payment Instrument portion of the invoice. Values are: Blank: Do not complete the payment details section. 1: Complete the payment details section. The system prints in the payment details section the data that you specified in the Details of Payment processing option on the Defaults tab. |
6. Charges To Be Paid By |
Specify whether the system completes the charges to be paid section on the International Payment Instrument portion of the invoice. Values are: Blank: Do not complete the charges to be paid section. 1: Complete the charges to be paid section. |
7. IPI Currency and Currency Amounts |
Specify whether the currency and amount appear on the International Payment Instruction portion of the invoice. Values are: Blank: Do not print the currency and amount. 1: Print the currency and amount. |
Process
1. Maximum IPI Amount |
Specify the maximum amount allowed for an IPI. If the IPI is greater than this amount, the system will not generate an IPI. If you leave this processing option blank, the system uses 999,999.99 as the maximum IPI amount. |
This section provides an overview of workflow generation for Intrastat and discusses how to:
Generate the workfile for sales.
Set processing options for the Intrastat Workfile Generation - Sales program (R0018I1).
Generate the workfile for procurement.
Set processing options for the Intrastat Workfile Generation - Procurement program (R0018I2).
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:
Program |
Description |
Updates the F0018T table with sales information based on these tables:
|
|
Updates the F0018T table with purchase information based on these tables:
|
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 which 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 in this Global Solutions guide for information about manually editing the Intrastat Revision table.
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:
Country (CTR) in the Address by Date table (F0116), using the supplier's address book record
Country (CTR) in the Order Address Information table (F4006)
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. It is recommended 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 allow 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:
Company |
Base Currency |
Intrastat Reporting Currency |
Company 1 |
GBP |
GBP |
Company 2 |
EUR |
GBP |
Company 3 |
CAD |
GBP |
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.
Select Periodic Processing (G74STAT2), Intrastat Workfile Generation - Sales.
Processing options enable you to specify the default processing for programs and reports.
Transaction
1. Reporting Code Method |
Specify the Sales Reporting Code (1-5) which contains the Nature of Transaction if you wish to use the reporting code method. Alternatively, you can use the User-Defined Code method. |
1. System Code and User-Defined Code |
Specify the system code or the user-defined code for the UDC table which contains the Nature of Transaction. If no values are entered in these processing options, the system uses UDC table 74/NT. |
2. Enter '1' to refresh transactions that already exist in the Intrastat Work File (F0018T). |
Specify whether the system refreshes transactions that already exist in the Intrastat Work File (F0018T). If left blank, only new transactions will be written. |
Defaults
1. Enter a value to update all records written during this execution for VAT Regime. |
Specify whether the system updates all records for VAT Regime written during this execution. Alternatively, enter a UDC table which contains the value to be used in the following processing options. |
1. System Code and User-Defined Codes |
Specify the system code or the user-defined code for the UDC table which contains the Nature of Transaction. If no values are entered in these processing options, the system uses UDC table 74/NT. |
2. Enter a value to indicate if the Statistical Value Calculation is required. |
Specify whether the statistical value calculation is required. Values are: Blank: Not Required 1: Required |
3. Enter the constant value per Kg to be used for Statistical Value Calculation. |
Specify the constant value per kilogram to use for the statistical value calculation. (Statistical Amount = Constant * Net Mass in KG + Taxable Amount). |
3. To use the percentage method, enter the percentage to be used. (for example, 105 = 105% of actual value). |
Specify the percentage to use for the percentage method. For example, 105 = 105 percent of actual value. If no values are entered in these options, the statistical value will be equal to the actual value. (FRA) In France, this is 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 or a percentage of the order amount. This value is commonly required for value-added tax (VAT) reporting in France. Countries other than France might use a statistical value and might define it differently. For European Union tax reporting purposes, the user supplies this data. You can update the value by using the Intrastat Workfile Revision program (P0018T). |
Currency
1. Enter the currency code for as-if currency reporting. |
Specify the currency code for as-if currency reporting. This option enables the system to print amounts in a currency other than the currency they are stored in. Amounts will be translated and print in this as-if currency. If left blank, amounts will print in their database currency. |
2. Enter the As-Of date for processing the current rate for the as-if currency. |
Specify the as-of date to use for processing the current rate for the as-if currency. If left blank, the system date will be used. |
3. Rate - Type |
Enter the rate type value from UDC 11/RT in conjunction with the date effective to restate domestic amounts of foreign transactions at an official or monthly average exchange rate. |
3. Date - Effective |
Enter the effective date in conjunction with the rate type to restate domestic amounts of foreign transactions at an official or monthly average exchange rate. |
Process
These processing options specify the triangulation records 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
Leave the document type blank to use the original document type.
For example:
3SI: Specifies Transfer Cost, Document Type SI
2: Specifies Cost, Original Document Type
1. Export from Header to Customer |
Specify the value and document type for the export from header to customer process when the header branch and customer in the same country and the detail branch are in a different country. |
1. Export from Detail to Customer |
Specify the value and document type for the export from detail to customer process when the header branch and customer in the same country and the detail branch are in a different country. |
1. Export from Detail to Header |
Specify the value and document type for the export from detail to header process when the header branch and customer in the same country and the detail branch are in a different country. |
1. Import from Header to Detail |
Specify the value and document type for the export from header to detail process when the header branch and customer in the same country and the detail branch are in a different country. |
2. Export from Header to Customer |
Specify the value and document type for the export from header to customer process when the header branch and detail branch in the same country and the customer is in a different country. |
2. Export from Detail to Customer |
Specify the value and document type for the export from detail to customer process when the header branch and detail branch in the same country and the customer is in a different country. |
3. Export from Header to Customer, 3. Export from Detail to Customer, 3. Export from Detail to Header, and 3. Import to Header from Detail |
Specify the value and document type for the export from header to customer process when the header branch, detail branch, and customer are in a different countries. |
Select Periodic Processing (G74STAT2), Intrastat Workfile Generation - Purchase.
Processing options enable you to specify the default processing for programs and reports.
Process
1. Enter the Purchasing Report Code (1-5) which contains the Nature of Transaction |
Specify the purchasing report code that contains the nature of transaction OR use the System Code and User-Defined Codes processing options to enter the user-defined code table that contains the Nature of Transaction. |
1. System Code and 1. User-Defined Codes |
Specify the UDC table that contains the Nature of Transaction. Use these processing options in conjunction with the User-Defined Codes processing option or the System Code processing option. If no values are entered in this option, the system uses UDC 74/NT. |
2. Enter '1' to refresh transactions that already exist in the Intrastat Work File (F0018T). |
Specify whether the system updates transaction records that exist in the Intrastat Work File (F0018T). If left blank, the system writes new transactions only. |
3. Use this processing option to specify how the system enters the country of origin (ORIG). |
Specify how the system enters the country of origin (ORIG). Values are: Blank: Enters the country of origin based on the address number of the supplier from the Address by Date table (F0116). 1: Enters the country of origin based on the Intrastat Supplier/Item Cross Reference table (F744101). Note. Any country that is specified in the Order Address Information table (F4006) takes precedence over all other countries of origin. |
4. Enter a '1' to use the Intrastat Supplier/Item Cross-Reference Table (F744101) for Original Country of Origin. |
Specify how the system enters the country of origin (ORIG). Values are: Blank: Enters the country of origin based on the address number of the supplier from the Address by Date table (F0116). country of origin in the Item Branch File table (F4102). If no value exists in the F4102 table, the system uses the address number of the supplier from the Address by Date table (F0116). 1: Enters the original country of origin based on the Intrastat Supplier/Item Cross Reference table (F744101). Note. Any country that is specified in the Order Address Information table (F4006) takes precedence over all other countries of origin. |
Defaults
1. Enter a value to indicate if the Statistical Value Calculation is required. |
Specify whether the Statistical Value Calculation is required. Values are: Blank: Not Required 1: Required |
2. Enter a percent to use for calculating Statistical Value. |
Specify the percent the system uses to calculate Statistical Value. For example, 105 = 105 percent of actual value) OR use the following processing option to enter the constant value per kilogram. |
2. Enter the constant value per KG to be used. |
Specify the constant value per kilogram that the system uses to calculate Statistical Value. For example, Statistical Amount = Constant * Net mass in Kg + Taxable Amount (FRA) In France, this is 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 or a percentage 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 European Union tax reporting purposes, the user supplies this data. You can update the value by using the Intrastat Workfile Revision program (P0018T). |
3. Enter a value to Statistical Procedure to update all records with. |
Specify 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. Instead of using this processing option, you can use the System Code and User-Defined codes processing options to enter the user-defined code table which contains the value to be used. |
3. System Code and 3. User-Defined Codes |
Specify the system code or the user-defined code of the UDC table that contains the desired value. If no values are entered in these processing options, the system uses UDC 74/NT. |
Currency
1. Enter the currency code for as-if currency reporting. |
Specify the currency code for as-if currency reporting. This option enables the system to print amounts in a currency other than the currency stored. Amounts will be converted and printed in this as-if currency. |
2. Enter the As-Of date for processing the exchange rate for the As-If currency. |
Specify the as-of date for processing the exchange rate for the as-if currency. If left blank, the system date will be used. |
3. Exchange Rate Type |
Use this processing option in conjunction with the Date Exchange Rate Effective processing option to restate domestic amounts of foreign transactions at an official or monthly average exchange rate. |
3. Date Exchange Rate Effective |
Use this processing option in conjunction with the Exchange Rate Type processing option to restate domestic amounts of foreign transactions at an official or monthly average exchange rate. |
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.
Run the Intrastats - Tax Update - Sales (R0018I1) and Intrastats - Tax Update - Purchasing (R0018I2) programs to build the Intrastat Revision table (F0018T).
See Revising Intrastat Information.
Access the Intrastat Tax File Revision form.
Branch/Plant |
Enter an alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority. |
Ship To/From |
Enter a number that identifies an entry in the JD Edwards EnterpriseOne Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location. |
Document Company |
Enter a number that, with the document number, document type, and general ledger date, uniquely identifies an original document, such as invoice, voucher, or journal entry. If you use the Next Numbers by Company/Fiscal Year feature, the Automatic Next Numbers program (X0010) uses the document company to retrieve the correct next number for that company. If two or more original documents have the same document number and document type, you can use the document company to locate the desired document. |
Document Number |
Enter a number that identifies the original document, such as a voucher, invoice, or journal entry. On entry forms, you can assign the document number or let the system assign it using the Next Numbers program (P0002). Matching document numbers (DOCM) identify related documents in the JD Edwards EnterpriseOne Accounts Receivable and JD Edwards EnterpriseOne Accounts Payable systems. Examples of original and matching documents are: Accounts Payable Original document - voucher Matching document - payment Accounts Receivable Original document - invoice Matching document - receipt Note. In the JD Edwards EnterpriseOne Accounts Receivable system, these transactions simultaneously generate original and matching documents: deductions, unapplied receipts, chargebacks, and drafts. |
Document Type |
Enter a user-defined code (00/DT) that identifies the origin and purpose of the transaction. The system reserves several prefixes for document types, such as vouchers, invoices, receipts, and timesheets. The reserved document type prefixes for codes are: P: Accounts payable R: Accounts receivable T: Time and pay I: Inventory O: Purchase order S: Sales order |
Line Type |
Enter a code that controls how the system processes lines on a transaction. It controls the systems with which the transaction interfaces, such as the JD Edwards EnterpriseOne General Accounting, JD Edwards EnterpriseOne Job Cost, JD Edwards EnterpriseOne Accounts Payable, JD Edwards EnterpriseOne Accounts Receivable, and JD Edwards EnterpriseOne Inventory Management systems. It also specifies the conditions under which a line prints on reports, and it is included in calculations. Codes include: S: Stock item J: Job cost N: Nonstock item F: Freight T: Text information M: Miscellaneous charges and credits W: Work order |
G/L Date (general ledger date) |
Enter a date that identifies the financial period to which the transaction is to be posted. The company constants specify the date range for each financial period. You can have as many as 14 periods. Generally, period 14 is used for audit adjustments. The system validates this field for PBCO (posted before cutoff), PYEB (prior year ending balance), PACO (post after cutoff), and WACO (post way after cutoff) messages. |
Invoice Date |
Enter the date the invoice was printed. The system updates this date when you run the invoice print program in the JD Edwards EnterpriseOne Sales Order Management system. |
Actual Ship |
Enter the date on which the shipment to the customer is confirmed as shipped. During shipment confirmation, the system updates the Sales Order Detail table (F4211) with this date. |
Receipt Date |
Enter the date you received this purchase order line. |
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 European Union 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 may 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. |
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 user-defined code (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 user-defined code 00/TC to correspond to the three-character explanation. Sample codes include: EXW: Ex Works FOB: Free On Board CIF: Cost, Insurance, and Freight DUP: 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 European Union VAT reporting, you can input the nature of transaction codes using one of the user-defined codes 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 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. |
This section provides an overview of the purge process and discusses how to:
Run the Intrastat Workfile Purge Program.
Set processing options for the Intrastat Workfile Purge Program (R0018TP).
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.
Select Periodic Processing (G74STAT2), Intrastat Workfile Purge.
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.
1. Proof or Final Mode |
Specify the mode in which you want to run this report. Final mode deletes all selected records from the Intrastat Revision table (F0018T). Values are: Blank: Proof mode. 1: Final mode. |
2. From Date (Required) and 3. Thru Date (Required) |
Specify the beginning date or the last date of the records you want to purge. These dates are used with the date specified for comparison. The system purges records whose comparison date is greater than or equal to the From Date and less than or equal to the Thru Date. |
4. Compare Date (Required) |
Specify which date to use for comparison. Values are: Blank: Invoice date 1: General ledger date 2: Receipt date 3: Ship date |
This section provides an overview of the IDEP/IRIS interface and discusses how to:
Run the IDEP/IRIS Interface (R0018I3) program.
Set processing options for the IDEP/IRIS Interface program (R0018I3).
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:
Format |
Where Used |
IDEP/CN8 |
France, Italy, Spain, Austria, Belgium, Sweden, Denmark, Finland, Portugal, Greece, Ireland, and Luxembourg |
CBS-IRIS |
Holland |
CBS-IRIS |
Germany |
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 information above, the interface with IDEP/CN8 provides the ability 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.
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.
Select Statistical Reports (G74STAT3), IDEP/IRIS Interface.
Processing options enable you to specify the default processing for programs and reports.
Defaults
1. Tax ID |
Specify which tax ID to use for the company and the customer. You can retrieve the tax ID from either the Additional Tax ID field (ABTX2) or the Tax ID field (ABTAX) in the Address Book Master table (F0101). Values are: Blank: Tax ID (date item ABTAX) 1: Additional Tax ID (date item ABTX2) |
2. Country Code |
Specify which format to use for the country code. Values are: Blank: Two-character ISO code. You must enter a two-character ISO code that is defined in UDC 00/CN. 1: Three-digit GEONOM code. You must enter a three-digit GEONOM code that is defined in the Special Handling Code field of UDC 00/CN. |
3. Declaration Type (UDC 74/IT) |
Specify the Intrastat declaration type (required for IDEP). Values are: 1: Fiscal 2: Statistical 3: Complete The codes that correspond to these declaration types are maintained in the Intrastat Declaration Type UDC (74/IT). For IDEP, the code specified in the special handling code for the UDC is written to the text field in the Text Processor Detail table (F007111). This special handling code is also used to determine the VAT registration number for sales transactions. For statistical declarations, the system uses the Ship To - Address Number. For fiscal or complete declarations, the system uses the Sold To - Address Number. |
Process
1. Interface Type |
Specify the interface type for which the data should be formatted. Values are: Blank: IDEP 1: Dutch version of IRIS 2: German version of IRIS |
2. Commodity Flow |
Specify the direction of the movement of goods. Values for Holland are: 6: Arrivals 7: Dispatches For values for Germany, consult the CBS-IRIS documentation. Note. This option is required only for the IRIS interface. |
3. Level of Detail |
Specify whether the program should be run in detail or summary mode. In detail mode, the system reports on all transactions. In summary mode, the system summarizes the transactions according to the version you set up. Values are: Blank: Detail mode 1: Summary mode Note. The level of summarization is determined by the version sequencing. If any sequenced field value changes, a level break occurs and a summarized record is written to the text file. |
4. Proof or Final Mode |
Specify the mode in which you want to process the IDEP/IRIS Interface. Final mode updates the Text Processor Header table (F007101) and the Text Processor Detail table (F007111). Values are: Blank: Proof mode. 1: Final mode. |
Currency
1. As-if Processing |
Specify whether the invoice amount and statistical amount are reported to IRIS in the domestic currency or in the as-if currency. Values are: Blank: Domestic currency 1: As-if currency Note. The as-if values can be used only if the Intrastat Revision table (F0018T) has been generated using as-if processing. If you generate the Intrastat Revision table using as-if currency, both the domestic and the as-if amounts are stored in the F0018T table. |
2. Number of digits to truncate from monetary amounts |
Specify how the system determines how many digits are truncated from monetary amounts. For example, if the value entered is 3, the monetary amount 123456 is truncated to 123. Values are 0 - 9. |
Rounding
1. Round Rules |
Specify the method to round both domestic and foreign taxable amounts. Values are: Blank: No rounding. For example: 14.66=14.66 1: Round to the nearest whole amount. For example: 14.66=15 (no decimals). 2: Round down to the nearest whole amount. For example: 14.66=14 (no decimals). 3: Round up to the nearest whole amount. For example: 14.66=15 (no decimals). 4: Round to the nearest half. For example: 14.66=14.5 (one decimal place). 5: Round to the nearest tenth. For example: 14.66=14.7 (one decimal place). 6: Divide by one hundred and then round. For example: 1674=17. 7: Divide by one thousand and then round. For example: 1674=2. Statistical Amount Specify the method to round both domestic and foreign statistical amounts. Supplementary UOM Specify the method to round the supplementary unit of measure. Net Mass UOM Specify the method to round the net mass unit of measure. |
1. Reporting Period |
Year (Required) Specify the reporting year. Period (Required) Specify the reporting period. |
This section provides an overview of the SEMDEC interface and discusses how to:
Run the UK SEMDEC Interface program (R0018I4).
Set the processing options for UK SEMDEC Interface (R0018I4).
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 have the option of submitting 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 (Single European Market Declaration) 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.
Before you complete the tasks in this section:
Set up user-defined code 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.
Select Statistical Reports (G74STAT3), UK SEMDEC Interface.
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.
1. Company Name |
Specify the company name of the Declarant. If left blank, the system uses the description for company 00000. Warning! You must enter the company name using all uppercase letters. HM Customs and Excise will reject any submission that contains lowercase letters. |
2. VAT Registration Number |
Specify the VAT registration number of the Declarant. If left blank, the system uses the tax ID from the address book record for company 00000. |
3. Agent Reference |
Specify the reference code associated with the agency submitting the declaration. Complete this processing option in conjunction with the Submission Type processing option on the Process tab. |
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.
1. Mode |
Specify the format in which you want to run this report. You can run the report in test format to verify data. However, you must submit the report in live format to HM Customs and Excise. Values are: Blank: Test format 1: Live format |
2. Submission Type |
Specify who is submitting the declaration. Values are: Blank: Declarant submission 1: Agent/agency submission Complete this processing option in conjunction with the Agent Reference processing option on the Defaults tab. |
Currency
This processing option lets you report amounts in either the domestic currency or the currency of the Intrastat Revision table (F0018T).
1. Currency |
Specify whether amounts are reported in the as-if currency. Values are: Blank: Domestic currency. 1: Currency used in the Intrastats workfile (F0018T). Note. This option is available only if the Intrastat workfile was created using as-if currency. You specify the as-if currency for the Intrastat workfile on the processing options for Intrastat Generation - Sales (R0018I1) and Intrastat Generation - Procurement (R0018I2). |
These processing options do not control the selection of records from the Intrastat work file. Complete these processing options to meet the HM Customs and Excise requirement that the submission include the reporting period and year.
1. Reporting Period |
Year Enter the reporting year of the submission. Period Enter the reporting period. |
Reporting Period: Year |
Specify the year for the reporting period. |
Reporting Period: Period |
Specify the accounting period for the report. |
Version
1. Intra EC Trade Statistics Report Version (R0018I41) |
Specify the Intra EC Trade Statistics Report Version (R0018I41) The default value is XJDE0001. |
This section provides an overview of the German Intrastat report and discusses how to:
Run the Germany Electronic Submission (R0018IGF).
Set processing options for the Germany Electronic Submission (R0018IGF).
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.
Select Statistical Reports (G74STAT3), Germany Electronic Submission.
Processing options enable you to specify the default processing for programs and reports.
Identification
1. Enter the Branch ID to print on the Report. |
Specify the branch identification number that prints on the report. |
2. Enter the Region Code of the Tax Authority. |
Specify a user-defined code (00/S) that identifies the tax authority. This code is usually a postal service abbreviation. |
Shipping
1. Shipping Type |
Specify whether the system imports or exports the file. Values are: Blank: Exports 1: Imports |
Label
1. Diskette Label |
Specify whether the diskette label is required. Values are: Blank: Not required 1: Required |
2. Object Library Name |
Specify the file name. |
2. Member ID |
Specify the library of the file. |
Tax Number
Enter the Tax Number of the Registrar. |
Specify the tax number of the registrar. If left blank, the Tax Number from the address book record for the company will be used. If the registrar is a third-party, enter their Tax Number here. |
Report Period
Report Period: Period |
Specify the report period to print on the report heading. |
Report Period: Year |
Specify the year to print on the report heading. |
This section provides an overview of the EC Sales List program and discusses how to:
Run the EC Sales List report (R0018L).
Set processing options for EC Sales List (R0018L).
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 information above:
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:
Method |
Description |
Interbranch |
Identifies as trade triangulation a transaction between two EU member countries in which the goods are shipped from a branch/plant of the supplier who is located in a third EU member country |
Direct Ship |
Identifies as trade triangulation a transaction between two EU member countries in which the goods are shipped directly from a third company that is located in a third EU member country |
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 example above, 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.
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).
Select Statistical Reports (G74STAT3), EC Sales List.
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.
1. Reporting Level |
Specify whether to run the program in summary or detail mode. If you run the program in detail mode, the report displays information that can be used for auditing. Values are: Blank: Summary 1: Detail |
2. Triangulation |
Specify which triangulation method to use. Trade triangulation occurs when one EU member makes a sale or purchase with another EU member but the goods are physically shipped from a third EU member. If the goods are not shipped from an EU member then the transaction is not required to be reported to the government. This terminology is used specifically in the EU for Intrastat. Values are: Blank: No triangulation 1: Direct Ship and Interbranch 2: Direct Ship 3: Interbranch |
Use these processing options to specify the reporting period for the report.
1. Reporting Period |
From month Specify the beginning month of the period for which you are submitting the EC Sales List. From year Specify the beginning year of the period for which you are submitting the EC Sales List. To month Specify the ending month of the period for which you are submitting the EC Sales List. To year Specify the ending year of the period for which you are submitting the EC Sales List. |
Currency
Specify the currency code for as-if currency processing.
1. As-if Processing |
Specify whether the invoice amount is reported in the domestic currency or in the as-if currency. Values are: Blank: Domestic currency 1: As-if currency Note. The as-if values can be used only if the Intrastat Revision table (F0018T) has been generated using as-if processing. If you generate the Intrastat Revision table using as-if currency, both the domestic and the as-if amounts are stored in the F0018T table. |
This section provides an overview of the EC Sale List - AR (R0018S) program and discusses how to:
Run the EC Sale List - AR report (R0018S).
Set processing options for EC Sale List - AR (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 on the report is sequenced by company, address book number, tax ID, and document number. Line numbering and page numbering restart for each reporting company.
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
Set the processing options in the General Ledger Post Report program (R09801) to automatically update the Taxes table (F0018).
Set up the user-defined code for Triangulation Tax Rates (00/VT).
Select Statistical Reports (G74STAT3), EC Sale List - AR.
Processing options enable you to specify the default processing for programs and reports.
Select
Use these processing options to specify the branch ID and the date range for the report.
1. Branch ID |
Specify the branch ID for the reporting company. The branch ID is displayed in the report heading; it is not used for data selection. |
From month (1-12) and To month (1-12) |
Specify the first calendar month or the last calendar month of the reporting period. This information is used for data selection. |
From year (4 digits) and To year (4 digits) |
Specify the first four-digit calendar year or the last four-digit calendar year of the reporting period (for example, 2001). This information is used for data selection. |
Process
Use this processing option to specify whether to print the report in detail or summary mode.
1. Report Mode |
Specify whether to run the report in summary mode or detail mode. If you select detail mode, the document number of each transaction is displayed on the report. Values are: Blank: Detail mode 1: Summary mode |
Display
Use this processing option to specify whether to display the name and address on the report.
1. Name and Address |
Specify whether to include the name and address of each customer on the report. Values are: Blank: Do not print. 1: Print. |
As-If-Currency
Use these processing options to specify the as - if currency and the date to use to select the exchange rate.
1. As-If-Currency Code |
Specify the currency code for as-if-currency reporting. This option lets you print amounts in a currency other than the currency in which they are stored. Amounts are converted and are displayed in the currency you specify. If you leave this processing option blank, amounts are displayed in the reporting company's base currency. |
2. Exchange Rate Date |
Specify the as-of date for determining the exchange rate for the as-if-currency conversion. If you leave this processing option blank, the system uses the current date. |
Approval Code
Use this processing option to specify the approval code for the reporting authority.
Reporting Authority Approval Code |
Enter the Reporting Authority Approval Code. This code is displayed in the report heading. This code is required in Germany. |