Go to main content
1/21
Contents
List of Figures
Title and Copyright Information
Preface
Audience
JD Edwards EnterpriseOne Products
JD Edwards EnterpriseOne Application Fundamentals
Documentation Accessibility
Related Documents
Conventions
1
Introduction to Localizations for European Reporting and SEPA Processing
1.1
JD Edwards EnterpriseOne Localizations for European Reporting and SEPA Processing Overview
1.1.1
Documentation for Localizations
1.2
Country-Specific Setup and Processes Implementation
2
Setting Up Localizations for European Reporting and SEPA Processing
2.1
Understanding Translation Considerations for Multilingual Environments
2.2
Understanding Translation Routines
2.3
Setting Up User Display Preferences
2.3.1
Understanding User Display Preferences
2.3.2
Form Used to Set Up User Display Preferences
2.3.3
Setting Processing Options for User Profile Revisions (P0092)
2.3.3.1
A/B Validation
2.3.3.2
PIM Server Setup
2.3.4
Setting Up User Display Preferences
3
(CZE, HUN, POL, and RUS) Setting Up Legal Numbering for Legal Documents
3.1
Understanding Legal Numbering for Legal Documents
3.2
Setting Up UDCs to Number Legal Documents
3.2.1
(CZE and HUN) Generate Contact Information (70/CI)
3.2.2
Legal Document Type Group (74/DG)
3.2.3
Discriminate Taxes (74/DL)
3.2.4
Number of Copies Source (74/NC)
3.2.5
Print Line Types for Legal Documents (74/PL)
3.2.6
Legal Document Title Print (74/PT)
3.2.7
Supplier Address Source (74/SC)
3.2.8
VAT Condition (74/VC)
3.3
Setting Up Legal Document Types
3.3.1
Understanding Legal Document Types
3.3.2
Forms Used to Enter Legal Document Types
3.3.3
Entering Legal Document Types
3.4
Associating Legal Document Types with Document Types
3.4.1
Understanding How to Associate Legal Document Types with Document Types
3.4.2
Forms Used to Associate Legal Document Types with Document Types
3.4.3
Associating Legal Document Types with Document Types
3.5
Setting Up Legal Documents Issue Places
3.5.1
Understanding Issue Places
3.5.2
Forms Used to Set Up Legal Document Issue Places
3.5.3
Entering Issue Places
3.6
Setting Up Next Numbers for Legal Documents
3.6.1
Understanding Next Numbers for Legal Documents
3.6.2
Forms Used to Set Up Next Numbers for Legal Documents
3.6.3
Setting Up Next Numbers for Legal Documents
3.7
Setting Up Print Template Definitions for Legal Documents
3.7.1
Understanding Print Template Definitions
3.7.2
Forms Used to Set Up Print Template Definitions
3.7.3
Setting Up Print Template Definitions
3.8
Specifying Rows for Print Template Line Types
3.8.1
Forms Used to Specify Rows for Print Template Line Types
3.8.2
Defining the Number of Rows
3.9
Associating Legal Document Types with Print Templates
3.9.1
Forms Used to Associate Legal Document Types with Print Templates
3.9.2
Associating Legal Document Types with Print Templates
3.10
Specifying Programs and Versions to Print Legal Documents
3.10.1
Understanding Versions for Legal Documents
3.10.2
Understanding How to Set Up Corresponding Versions
3.10.3
Forms Used to Specify Versions and Print Programs
3.10.4
Specifying Versions and Print Programs
3.11
(CZE and HUN) Setting Up Bank Information for Legal Documents
3.11.1
Forms Used to Set Up Bank Information for Legal Documents
3.11.2
Setting Up Bank Information for Legal Documents
3.12
(RUS) Setting Up Legal Document Footer Signatures
3.12.1
Understanding Legal Document Footer
3.12.2
Forms Used to Set Up Footer Signatures
3.12.3
Setting Up Footer Signatures
3.13
(HUN) Setting Up Your System to Issue a Document in Lieu of an Invoice
4
(CZE, HUN, and ESP) Setting Up Accounts and Layouts for Financial Statement Reports
4.1
Understanding the Setup of Accounts and Layouts for Financial Statement Reports
4.2
Setting Up UDCs for Financial Statement Reports
4.2.1
Function (74/FA)
4.2.2
Factor to Apply (74/FR)
4.2.3
Group Type (74/GT)
4.2.4
Report Type Classification (74/RC)
4.2.5
Report Layout (74/RL)
4.2.6
Report Row Type (74/TR)
4.3
Setting Up Cost Center Groups for Financial Statement Reports
4.3.1
Understanding Cost Center Groups
4.3.1.1
Types of Cost Centers
4.3.2
Forms Used to Set Up Cost Center Groups
4.3.3
Setting Up Global Cost Center Groups
4.4
Setting Up Account Groups for Financial Statement Reports
4.4.1
Understanding Account Groups
4.4.1.1
Types of Account Groups
4.4.2
Forms Used to Set up Account Groups
4.4.3
Setting Up Global Account Groups
4.5
Setting Up Layouts for Financial Statement Reports
4.5.1
Understanding Report Layouts
4.5.1.1
Sections
4.5.1.2
Columns
4.5.1.3
Rows
4.5.1.4
Cells
4.5.1.5
Formulas
4.5.1.6
Functions
4.5.2
Forms Used to Define Report Layouts
4.5.3
Defining Report Layouts
4.5.4
Defining Report Sections
4.5.5
Defining Report Columns
4.5.5.1
Formula
4.5.5.2
Function
4.5.6
Defining Report Rows
4.5.6.1
Title
4.5.6.2
Account Group
4.5.6.3
Account Detail
4.5.6.4
Formula
4.5.6.5
Single Account
4.5.7
Setting Up Cell Definitions
4.5.7.1
Formula
4.5.7.2
Function
5
(CZE and POL) Working With Delinquency Fees
5.1
Understanding Delinquency Fees
5.1.1
Prerequisites
5.2
Understanding Methods of Calculating Delinquency Fees
5.2.1
30 Day Rule Method
5.2.2
Late Payment and Open Invoice Methods
5.2.3
Examples of Delinquency Fee Calculations
5.3
Understanding the A/R Delinquency Fee Journal Program
5.4
Understanding the Delinquency Fee Process Flow
5.5
Setting Processing Options for Delinquency Fees (P74P525)
5.5.1
General
5.5.2
30–Day Rule
5.5.3
Customer Selection
5.5.4
RF Generation
5.6
(CZE) Printing Delinquency Notices
5.6.1
Understanding Delinquency Notices
5.6.2
Prerequisites
5.6.3
Printing a Delinquency Notice
6
Setting Up European Union (EU) and SEPA Functionality
6.1
Understanding EU and SEPA (Single Euro Payment Area) Functionality
6.2
Understanding Intracommunity VAT
6.2.1
Reporting Considerations
6.3
Setting Up UDCs for European Union Functionality
6.3.1
Setting Up UDCs for International Payment Instructions (IPI)
6.3.1.1
IPI - Address Line Sequencing (00/IA)
6.3.1.2
IPI - Charges Paid By (00/IC)
6.3.1.3
IPI - Form Types (00/IF)
6.3.1.4
IPI - Languages and Countries (00/IL)
6.3.1.5
IPI - Details of Payment (00/IP)
6.3.2
Setting Up UDCs for Intrastat Reporting
6.3.2.1
Country Codes (00/CN)
6.3.2.2
European Union Members (00/EU)
6.3.2.3
Intrastat Regime Code (00/NV)
6.3.2.4
State and Province Codes (00/S)
6.3.2.5
Condition of Transport (00/TC)
6.3.2.6
Mode of Transport (00/TM)
6.3.2.7
Triangulation Tax Rates (00/VT)
6.3.2.8
Shipping Commodity Class (41/E)
6.3.2.9
Purchasing Reporting Codes 01 through 05 (41/P1 through 41/P5)
6.3.2.10
Sales Reporting Codes 01 through 05 (41/S1 through 41/S5)
6.3.2.11
Freight Handling Code (42/FR)
6.3.2.12
European Community Members (74/EC)
6.3.2.13
Intrastat Declaration Type (74/IT)
6.3.2.14
Nature of Transaction - EU (74/NT)
6.3.2.15
(CZE) Fiscal Area (74/SG)
6.3.2.16
(GBR) Arrivals or Dispatchings (74/TD)
6.3.3
Setting Up UDCs for European Companies
6.3.3.1
Affiliated Companies (74/AC)
6.3.3.2
Code Number (74/30)
6.3.4
Setting Up UDCs for SEPA
6.3.4.1
Localization Country Code (00/LC)
6.3.4.2
Produce Bank File (04/PP)
6.3.4.3
XML Error Code (74/E1)
6.3.4.4
XML Elements Names (74/EN)
6.3.4.5
Transaction Group (74/TG)
6.3.4.6
Replace Character in String (74/RS) and (70/RS) (Release 9.1 Update)
6.3.4.7
BIC Country Code (74/SA)
6.3.4.8
Mandate Sequence Type (74/SQ)
6.3.4.9
Business Code (74/BC)
6.3.4.10
Category Purpose (74/CP)
6.3.4.11
Payment Purpose Code (74/PC)
6.3.4.12
Ultimate Creditor (74/UC)
6.4
Setting Up Next Numbers for Intrastat Reporting
6.5
Setting Up Tax Rate Areas for Intracommunity VAT
6.5.1
Understanding Tax Rate Areas for Intracommunity VAT
6.5.1.1
GL Considerations
6.5.2
Forms Used to Set Up Regional Information for Intracommunity VAT
6.5.3
Specifying Intracommunity VAT by Tax Rate/Area
6.5.4
(ESP) Entering Additional Tax Rate Information for Spanish VAT
6.6
Setting Up Tax Rate Area Associations
6.6.1
Understanding Tax Rate Area Associations
6.6.2
Forms Used to Set Up Tax Rate Area Associations
6.6.3
Associating Tax Rate Areas with Transaction Types
6.7
Setting Up Commodity Code and Statistical Information
6.7.1
Prerequisite
6.7.2
Forms Used to Set Up Commodity Codes and Statistical Information
6.7.3
Setting Up Commodity Codes
6.7.4
(CZE) Adding Statistical Information
6.8
Entering Cross-References for Items and Suppliers
6.8.1
Understanding Cross-References for Items and Suppliers
6.8.2
Form Used to Enter Cross-References for Items and Suppliers
6.8.3
Entering Cross-References
6.9
Setting Up Layouts for the IDEP/IRIS Interface
6.9.1
CBS-IRIS - Netherlands
6.9.2
CBS-IRIS - Germany
6.10
Setting Up and Verifying Bank Accounts for SEPA Payments
6.10.1
Understanding Bank Account Setup for SEPA Payments
6.10.2
Understanding Mass Update of IBAN and BIC (Release 9.1 Update)
6.10.3
Forms Used to Set Up Bank Account Records as SEPA Accounts
6.10.4
Setting Up Bank Account Records as SEPA Bank Accounts
6.10.5
Updating IBAN and BIC for Multiple Accounts (Release 9.1 Update)
6.10.6
Running the BIC and IBAN Control Report Program
6.10.7
Setting Processing Options for BIC and IBAN Control (R740001)
6.10.7.1
General
7
Using European Union Functionality
7.1
Understanding International Bank Account Numbers
7.2
Understanding Bank ID and Bank Account Validation
7.2.1
Bank ID Validation Overrides
7.2.2
(BEL) Bank Account Validation
7.2.3
(FRA) Bank Account Validation
7.2.4
(ITA) Bank Account and Bank ID Validation
7.3
Understanding Tax ID Validation
7.4
Understanding European Union Reporting
7.4.1
Intrastat Requirements
7.4.2
Intrastat Reporting and the Euro
7.4.3
Considerations for Creating Intrastat Reports
7.4.4
Prerequisites
7.5
Printing Invoices with an Attached International Payment Instruction
7.5.1
Understanding International Payment Instructions
7.5.1.1
Data Selection
7.5.2
Prerequisites
7.5.3
Running the Invoice Print with International Payment Instruction Program
7.5.4
Setting Processing Options for Invoice Print with International Payment Instruction (R03B5053)
7.5.4.1
Defaults
7.5.4.2
Print
7.5.4.3
Process
8
Working with SEPA Payments and Credits
8.1
Understanding SEPA Payments
8.2
Generating the XML File for SEPA Payments (Release 9.1 Update)
8.2.1
Understanding the XML File for SEPA Payments
8.2.1.1
XML File
8.2.2
Understanding Error Messages in the Payment Information Extractor Report for SEPA (R704001)
8.2.3
Understanding Unacceptable Characters in the Output File
8.2.3.1
Example 1: Replacing A with FG
8.2.3.2
Example 2: Replacing A with FG
8.2.3.3
Example 3: Replacing B with FGHI
8.2.4
Setting Processing Options for the SEPA Credit Transfer POs - COMM - 04 (P744001)
8.2.4.1
General
8.2.4.2
Remittance Information
8.2.4.3
XML File
8.2.4.4
Validations
8.3
Printing the Detailed Payment Report for SEPA (Release 9.1 Update)
8.3.1
Understanding the SEPA Credit Transfer Report
8.3.2
Printing the SEPA Credit Transfer Report
9
Working with Direct Debits for SEPA
9.1
Understanding SEPA Direct Debits
9.2
Setting Up the Direct Debit Mandate Program (P743002) for SEPA Direct Debits
9.2.1
Understanding the Direct Debit Mandate Program (P743002) for SEPA Direct Debits
9.2.2
Renewing an Expired Mandate Using the Direct Debit Mandate Program (P743002) (Release 9.1 Update)
9.2.3
Forms Used to Set Up the Mandate in the SEPA Direct Debit Mandate Program (P743002)
9.2.4
Entering Mandate Data
9.2.4.1
Header
9.2.4.2
Debtor
9.2.4.3
Creditor
9.2.4.4
Ultimate Debtor
9.2.5
Reviewing Modifications Made to a Mandate
9.2.5.1
Original Values
9.2.5.2
Grid Data
9.3
Generating the XML File for Direct Debits for SEPA
9.3.1
Understanding the XML File for SEPA Direct Debits
9.3.1.1
Changing the Status of Payments Using the Copy to Diskette program (P0457D) (Release 9.1 Update)
9.3.1.2
Replaced Characters in the Direct Debit XML File (Release 9.1 Update)
9.3.1.3
XML File
9.3.2
Understanding the Output Modes of Payments in the XML
9.3.3
Setting Processing Options for SEPA Direct Debit Extractor (R743005)
9.3.3.1
General
9.3.3.2
Process
9.3.4
Setting Processing Options for the SEPA Direct Debit Multiple XML Extractor Report (R743005A) (Release 9.1 Update)
9.3.4.1
Bank File
9.3.5
Generating the XML File for SEPA Direct Debits for SEPA
9.4
Extracting the SEPA Direct Debit Statement (Release 9.1 Update)
9.5
Generating the XML File for Draft Remittance for SEPA Direct Debits (Release 9.1 Update)
9.5.1
Understanding the XML File for Draft Remittance for SEPA Direct Debits
9.5.2
Setting Processing Options for SEPA Direct Debit for Draft Remittance Extractor (R743007)
9.5.2.1
General
9.5.2.2
Process
9.5.3
Setting Processing Options for SEPA Direct Debit Multiple XML Extractor for Draft (R743007A)
9.5.3.1
Bank File
9.5.4
Generating the XML File for Draft Remittance for SEPA Direct Debits
10
Generating the EU Sales List Report
10.1
Understanding the EU Sales List Report
10.2
Extracting Data for the EU Sales List Report
10.2.1
Understanding Data Extraction
10.2.1.1
Considerations for Country Codes
10.2.1.2
How the System Determines the Transaction Nature Classification
10.2.1.3
Credit Memos and Adjustments
10.2.2
Prerequisites
10.2.3
Running the Data Extraction for ESL Program
10.2.4
Setting Processing Options for Data Extraction for ESL (R740018A)
10.2.4.1
Process
10.2.4.2
Print
10.3
Generating the European Community Sales List Report
10.3.1
Understanding the VAT European Sales List Report
10.3.1.1
Generic XML Output
10.3.1.2
Belgian Intracommunity °n 723 Report (Release 9.1 Update)
10.3.1.3
Summary Format
10.3.1.4
Detail Format
10.3.1.5
Data Selection
10.3.2
Running the VAT EU Sales List Program
10.3.3
Setting Processing Options for the VAT European Sales List Report (R740018D)
10.3.3.1
Default
10.3.3.2
Process
10.3.3.3
Belgium (Release 9.1 Update)
10.3.3.4
Czech
10.4
(BEL) Reviewing and Correcting Data for Reported Records (Release 9.1 Update)
10.4.1
Understanding the History VAT Listing Corrections Program
10.4.2
Forms Used to Modify Records to Include Corrections in Future Periods
10.4.3
Modifying Records to Include Corrections in Future Periods
10.5
Viewing Report Output Generated by BI Publisher for JD Edwards EnterpriseOne
10.5.1
Understanding Reports Generated by BI Publisher for JD Edwards EnterpriseOne
10.5.2
Verifying Report Definitions for Batch Versions
10.5.3
Viewing BI Publisher Output
11
Working With Intrastat Reporting
11.1
Populating the Intrastat Workfile
11.1.1
Understanding Work Table Generation for Intrastat
11.1.1.1
Transaction Eligibility
11.1.1.2
Triangulation
11.1.1.3
Multicurrency Environments
11.1.1.4
As If Currency Processing
11.1.1.5
Example of Company and Intrastat Reporting in Different Currencies
11.1.1.6
Performance Considerations
11.1.2
Generating the Intrastat Workfile for Sales
11.1.3
Setting Processing Options for Intrastat Workfile Generation - Sales (R0018I1)
11.1.3.1
Transaction
11.1.3.2
Defaults
11.1.3.3
Currency
11.1.3.4
Process
11.1.4
Generating the Intrastat Workfile for Procurement
11.1.5
Setting Processing Options for Intrastat Workfile Generation - Procurement (R0018I2)
11.1.5.1
Process
11.1.5.2
Defaults
11.1.5.3
Currency
11.2
Revising Intrastat Information
11.2.1
Prerequisite
11.2.2
Form Used to Revise Intrastat Information
11.2.3
Revising Intrastat Information
11.2.3.1
Detail
11.2.3.2
Amounts
11.2.3.3
Codes
11.3
Purging Records from the Intrastat Table (F0018T)
11.3.1
Understanding the Purge Process
11.3.2
Running the Intrastat Workfile Purge Program (R0018TP)
11.3.3
Setting Processing Options for Intrastat Workfile Purge (R0018TP)
11.3.3.1
Defaults
11.4
Using the IDEP/IRIS Interface for Intrastat Reporting
11.4.1
Understanding the IDEP/IRIS Interface for Intrastat Reporting
11.4.1.1
IDEP/CN8 - France, Italy, Spain, Austria, Belgium, Sweden, Denmark, Finland, Portugal, Greece, Ireland, Netherlands, and Luxembourg
11.4.1.2
Grouping Transactions
11.4.1.3
Electronic Format
11.4.2
Prerequisites
11.4.3
Running the IDEP CN8/IRIS Interface Program (R0018I3)
11.4.4
Setting Processing Options for IDEP CN8/IRIS Interface Program (R0018I3)
11.4.4.1
Defaults
11.4.4.2
Process
11.4.4.3
Currency
11.4.4.4
Rounding
11.4.4.5
Print
11.5
(GBR) Using the SEMDEC Interface for Intrastat Reporting
11.5.1
Understanding the SEMDEC Interface for Intrastat Reporting
11.5.1.1
Electronic Format
11.5.1.2
Data Selection
11.5.1.3
Government Forms
11.5.1.4
Submission Deadlines
11.5.2
Prerequisites
11.5.3
Running the UK SEMDEC Interface Program (R0018I4)
11.5.4
Setting Processing Options for UK SEMDEC Interface (R0018I4)
11.5.4.1
Defaults
11.5.4.2
Process
11.5.4.3
Currency
11.5.4.4
Print
11.5.4.5
Print
11.5.4.6
Version
11.6
(DEU) Printing the German Intrastat Report
11.6.1
Understanding the German Intrastat Report
11.6.2
Running the Germany Electronic Submission (R0018IGF)
11.6.3
Setting Processing Options for Germany Electronic Submission (R0018IGF)
11.6.3.1
Identification
11.6.3.2
Shipping
11.6.3.3
Label
11.6.3.4
Tax Number
11.6.3.5
Report Period
A
Fields in the SEPA Payments XML File (Release 9.1 Update)
A.1
Block A: Message Root
A.2
Block B: Group Header Elements
A.3
Block C: Payment Information Elements
A.3.1
Credit Transfer Transaction Information
A.3.2
Reviewing an Example of XML Code for SEPA Core Payments
A.3.3
Structured
B
SEPA Direct Debit XML File
B.1
Group Header Elements
B.2
Payment Information Elements
B.3
Examples of Structured and Unstructured Modes of Payment in the XML
C
SEPA Direct Debit for Draft Remittance XML File (Release 9.1 Update)
C.1
Group Header Elements
C.2
Payment Information Elements
C.3
Examples of Structured and Unstructured Modes of Payment in the XML
D
Elements and Attributes for the Belgium Intracommunity °n 723 Report
D.1
Elements and Attributes for the Belgium Intracommunity °n 723 Report
D.2
Example of an XML File for the Belgium Intracommunity °n 723 Report
Glossary
Index
Scripting on this page enhances content navigation, but does not change the content in any way.