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

• JD Edwards EnterpriseOne Localizations for European Reporting and SEPA Processing Overview
  • Documentation for Localizations
• Country-Specific Setup and Processes Implementation

2 Setting Up Localizations for European Reporting and SEPA Processing

• Understanding Translation Considerations for Multilingual Environments
• Understanding Translation Routines
• Setting Up User Display Preferences
  • Understanding User Display Preferences
  • Form Used to Set Up User Display Preferences
  • Setting Processing Options for User Profile Revisions (P0092)
    • A/B Validation
    • PIM Server Setup
  • Setting Up User Display Preferences

3 (CZE, HUN, POL, and RUS) Setting Up Legal Numbering for Legal Documents

• Understanding Legal Numbering for Legal Documents
• Setting Up UDCs to Number Legal Documents
  • (CZE and HUN) Generate Contact Information (70/CI)
  • Legal Document Type Group (74/DG)
  • Discriminate Taxes (74/DL)
  • Number of Copies Source (74/NC)
  • Print Line Types for Legal Documents (74/PL)
  • Legal Document Title Print (74/PT)
  • Supplier Address Source (74/SC)
  • VAT Condition (74/VC)
• Setting Up Legal Document Types
  • Understanding Legal Document Types
  • Forms Used to Enter Legal Document Types
  • Entering Legal Document Types
• Associating Legal Document Types with Document Types
  • Understanding How to Associate Legal Document Types with Document Types
  • Forms Used to Associate Legal Document Types with Document Types
  • Associating Legal Document Types with Document Types
• Setting Up Legal Documents Issue Places
  • Understanding Issue Places
  • Forms Used to Set Up Legal Document Issue Places
  • Entering Issue Places
• Setting Up Next Numbers for Legal Documents
  • Understanding Next Numbers for Legal Documents
  • Forms Used to Set Up Next Numbers for Legal Documents
  • Setting Up Next Numbers for Legal Documents
• Setting Up Print Template Definitions for Legal Documents
  • Understanding Print Template Definitions
  • Forms Used to Set Up Print Template Definitions
  • Setting Up Print Template Definitions
• Specifying Rows for Print Template Line Types
  • Forms Used to Specify Rows for Print Template Line Types
  • Defining the Number of Rows
• Associating Legal Document Types with Print Templates
  • Forms Used to Associate Legal Document Types with Print Templates
  • Associating Legal Document Types with Print Templates
• Specifying Programs and Versions to Print Legal Documents
  • Understanding Versions for Legal Documents
  • Understanding How to Set Up Corresponding Versions
  • Forms Used to Specify Versions and Print Programs
  • Specifying Versions and Print Programs
• (CZE and HUN) Setting Up Bank Information for Legal Documents
  • Forms Used to Set Up Bank Information for Legal Documents
  • Setting Up Bank Information for Legal Documents
• (RUS) Setting Up Legal Document Footer Signatures
  • Understanding Legal Document Footer
  • Forms Used to Set Up Footer Signatures
  • Setting Up Footer Signatures
• (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

• Understanding the Setup of Accounts and Layouts for Financial Statement Reports
• Setting Up UDCs for Financial Statement Reports
  • Function (74/FA)
  • Factor to Apply (74/FR)
  • Group Type (74/GT)
  • Report Type Classification (74/RC)
  • Report Layout (74/RL)
  • Report Row Type (74/TR)
• Setting Up Cost Center Groups for Financial Statement Reports
  • Understanding Cost Center Groups
    • Types of Cost Centers
  • Forms Used to Set Up Cost Center Groups
  • Setting Up Global Cost Center Groups
• Setting Up Account Groups for Financial Statement Reports
  • Understanding Account Groups
    • Types of Account Groups
  • Forms Used to Set up Account Groups
  • Setting Up Global Account Groups
• Setting Up Layouts for Financial Statement Reports
  • Understanding Report Layouts
    • Sections
    • Columns
    • Rows
    • Cells
    • Formulas
    • Functions
  • Forms Used to Define Report Layouts
  • Defining Report Layouts
  • Defining Report Sections
  • Defining Report Columns
    • Formula
    • Function
  • Defining Report Rows
    • Title
    • Account Group
    • Account Detail
    • Formula
    • Single Account
  • Setting Up Cell Definitions
    • Formula
    • Function

5 (CZE and POL) Working With Delinquency Fees

• Understanding Delinquency Fees
  • Prerequisites
• Understanding Methods of Calculating Delinquency Fees
  • 30 Day Rule Method
  • Late Payment and Open Invoice Methods
  • Examples of Delinquency Fee Calculations
• Understanding the A/R Delinquency Fee Journal Program
• Understanding the Delinquency Fee Process Flow
• Setting Processing Options for Delinquency Fees (P74P525)
  • General
  • 30–Day Rule
  • Customer Selection
  • RF Generation
• (CZE) Printing Delinquency Notices
  • Understanding Delinquency Notices
  • Prerequisites
  • Printing a Delinquency Notice

6 Setting Up European Union (EU) and SEPA Functionality

• Understanding EU and SEPA (Single Euro Payment Area) Functionality
• Understanding Intracommunity VAT
  • Reporting Considerations
• Setting Up UDCs for European Union Functionality
  • Setting Up UDCs for International Payment Instructions
    • IPI - Address Line Sequencing (00/IA)
    • IPI - Charges Paid By (00/IC)
    • IPI - Form Types (00/IF)
    • IPI - Languages and Countries (00/IL)
    • IPI - Details of Payment (00/IP)
  • Setting Up UDCs for Intrastat Reporting
    • Country Codes (00/CN)
    • European Union Members (00/EU)
    • Intrastat Regime Code (00/NV)
    • State and Province Codes (00/S)
    • Condition of Transport (00/TC)
    • Mode of Transport (00/TM)
    • Triangulation Tax Rates (00/VT)
    • Shipping Commodity Class (41/E)
    • Purchasing Reporting Codes 01 through 05 (41/P1 through 41/P5)
    • Sales Reporting Codes 01 through 05 (41/S1 through 41/S5)
    • Freight Handling Code (42/FR)
    • European Community Members (74/EC)
    • Intrastat Declaration Type (74/IT)
    • Nature of Transaction - EU (74/NT)
    • (CZE) Fiscal Area (74/SG)
    • (GBR) Arrivals or Dispatchings (74/TD)
  • Setting Up UDCs for European Companies
    • Affiliated Companies (74/AC)
    • Code Number (74/30)
  • Setting Up UDCs for SEPA Payments and Credits
    • Localization Country Code (00/LC)
    • Produce Bank File (04/PP)
    • XML Error Code (74/E1)
    • XML Elements Names (74/EN)
    • Transaction Group (74/TG)
    • Replace Character in String (74/RS) (Release 9.1 Update)
    • BIC Country Code (74/SA)
    • Mandate Sequence Type (74/SQ)
    • Business Code (74/BC)
    • Category Purpose (74/CP)
    • Payment Purpose Code (74/PC)
    • Ultimate Creditor (74/UC)
• Setting Up Next Numbers for Intrastat Reporting
• Setting Up Tax Rate Areas for Intracommunity VAT
  • Understanding Tax Rate Areas for Intracommunity VAT
    • GL Considerations
  • Forms Used to Set Up Regional Information for Intracommunity VAT
  • Specifying Intracommunity VAT by Tax Rate/Area
  • (ESP) Entering Additional Tax Rate Information for Spanish VAT
• Setting Up Tax Rate Area Associations
  • Understanding Tax Rate Area Associations
  • Forms Used to Set Up Tax Rate Area Associations
  • Associating Tax Rate Areas with Transaction Types
• Setting Up Commodity Code and Statistical Information
  • Prerequisite
  • Forms Used to Set Up Commodity Codes and Statistical Information
  • Setting Up Commodity Codes
  • (CZE) Adding Statistical Information
• Entering Cross-References for Items and Suppliers
  • Understanding Cross-References for Items and Suppliers
  • Form Used to Enter Cross-References for Items and Suppliers
  • Entering Cross-References
• Setting Up Layouts for the IDEP/IRIS Interface
  • CBS-IRIS - Netherlands
  • CBS-IRIS - Germany
• Setting Up and Verifying Bank Accounts for SEPA Payments
  • Understanding Bank Account Setup for SEPA Payments
  • Forms Used to Set Up Bank Account Records as SEPA Accounts
  • Setting Up Bank Account Records as SEPA Bank Accounts
  • Running the BIC and IBAN Control Report Program
  • Setting Processing Options for BIC and IBAN Control (R740001)
    • General

7 Using European Union Functionality

• Understanding International Bank Account Numbers
• Understanding Bank ID and Bank Account Validation
  • Bank ID Validation Overrides
  • (BEL) Bank Account Validation
  • (FRA) Bank Account Validation
  • (ITA) Bank Account and Bank ID Validation
• Understanding Tax ID Validation
• Understanding European Union Reporting
  • Intrastat Requirements
  • Intrastat Reporting and the Euro
  • Considerations for Creating Intrastat Reports
  • Prerequisites
• Printing Invoices with an Attached International Payment Instruction
  • Understanding International Payment Instructions
    • Data Selection
  • Prerequisites
  • Running the Invoice Print with International Payment Instruction Program
  • Setting Processing Options for Invoice Print with International Payment Instruction (R03B5053)
    • Defaults
    • Print
    • Process

8 Working with SEPA Payments and Credits

• Understanding SEPA Payments
• Generating the XML File for SEPA Payments
  • Understanding the XML File for SEPA Payments
    • XML File
  • Understanding Error Messages in the SEPA XML Credit Transfer - COM Report (R744002)
  • Understanding Unacceptable Characters in the Output File (Release 9.1 Update)
    • Example 1: Replacing A with FG
    • Example 2: Replacing A with FG
    • Example 3: Replacing B with FGHI
  • Setting Processing Options for the SEPA XML Credit Transfer - COM Report (R744002) (Release 9.1 Update)
    • General
    • Currency
    • Remittance Information
    • XML File
• Reviewing and Purging the XML File for SEPA Payments
  • Understanding the SEPA XML Transaction Review Program
  • Forms Used to Review the XML File
  • Setting Processing Options for XML Transaction Review (P74XMLZ1)
    • General
    • Display
  • Reviewing XML Transaction Files
    • Main Filters (header area)
    • Additional Filter
  • Running the SEPA XML Transaction Batch Purge Program
  • Setting Processing Options for XML Transactions Batch Purge (R74XMLI1P)
    • General

9 Working with Direct Debits for SEPA

• Understanding SEPA Direct Debits
• Setting Up the Direct Debit Mandate Program (P743002) for SEPA Direct Debits
  • Understanding the Direct Debit Mandate Program (P743002) for SEPA Direct Debits
  • Forms Used to Set Up the Mandate in the SEPA Direct Debit Mandate Program (P743002)
  • Entering Mandate Data
    • Header
    • Debtor
    • Creditor
    • Ultimate Debtor
  • Reviewing Modifications Made to a Mandate
    • Original Values
    • Grid Data
• Generating the XML File for Direct Debits for SEPA
  • Understanding the XML File for SEPA Direct Debits
    • XML File
  • Understanding the Output Modes of Payments in the XML
  • Setting Processing Options for SEPA Direct Debit Extractor (R743005)
    • General
  • Generating the XML File for SEPA Direct Debits for SEPA

10 Generating the EU Sales List Report

• Understanding the EU Sales List Report
• Extracting Data for the EC Sales List Report
  • Understanding Data Extraction
    • Considerations for Country Codes
    • How the System Determines the Transaction Nature Classification
    • Credit Memos and Adjustments
  • Prerequisites
  • Running the Data Extraction for ESL Program
  • Setting Processing Options for Data Extraction for ESL (R740018A)
    • Process
    • Print
• Generating the European Community Sales List Report
  • Understanding the VAT European Sales List Report
    • Generic XML Output
    • Belgian Intracommunity ˚n 723 Report (Release 9.1 Update)
    • Summary Format
    • Detail Format
    • Data Selection
  • Running the VAT EC Sales List Program
  • Setting Processing Options for the VAT European Sales List Report (R740018D)
    • Default
    • Process
    • Belgium (Release 9.1 Update)
    • Czech
• (BEL) Reviewing and Correcting Data for Reported Records (Release 9.1 Update)
  • Understanding the History VAT Listing Corrections Program
  • Forms Used to Modify Records to Include Corrections in Future Periods
  • Modifying Records to Include Corrections in Future Periods
• Viewing Report Output Generated by BI Publisher for JD Edwards EnterpriseOne
  • Understanding Reports Generated by BI Publisher for JD Edwards EnterpriseOne
  • Verifying Report Definitions for Batch Versions
  • Viewing BI Publisher Output

11 Working With Intrastat Reporting

• Populating the Intrastat Workfile
  • Understanding Work Table Generation for Intrastat
    • Transaction Eligibility
    • Triangulation
    • Multicurrency Environments
    • As If Currency Processing
    • Example of Company and Intrastat Reporting in Different Currencies
    • Performance Considerations
  • Generating the Intrastat Workfile for Sales
  • Setting Processing Options for Intrastat Workfile Generation - Sales (R0018I1)
    • Transaction
    • Defaults
    • Currency
    • Process
  • Generating the Intrastat Workfile for Procurement
  • Setting Processing Options for Intrastat Workfile Generation - Procurement (R0018I2)
    • Process
    • Defaults
    • Currency
• Revising Intrastat Information
  • Prerequisite
  • Form Used to Revise Intrastat Information
  • Revising Intrastat Information
    • Detail
    • Amounts
    • Codes
• Purging Records from the Intrastat Table (F0018T)
  • Understanding the Purge Process
  • Running the Intrastat Workfile Purge Program (R0018TP)
  • Setting Processing Options for Intrastat Workfile Purge (R0018TP)
    • Defaults
• Using the IDEP/IRIS Interface for Intrastat Reporting
  • Understanding the IDEP/IRIS Interface for Intrastat Reporting
    • IDEP/CN8 - France, Italy, Spain, Austria, Belgium, Sweden, Denmark, Finland, Portugal, Greece, Ireland, and Luxembourg
    • Grouping Transactions
    • Electronic Format
  • Prerequisites
  • Running the IDEP CN8/IRIS Interface Program (R0018I3)
  • Setting Processing Options for IDEP CN8/IRIS Interface Program (R0018I3)
    • Defaults
    • Process
    • Currency
    • Rounding
    • Print
• (GBR) Using the SEMDEC Interface for Intrastat Reporting
  • Understanding the SEMDEC Interface for Intrastat Reporting
    • Electronic Format
    • Data Selection
    • Government Forms
    • Submission Deadlines
  • Prerequisites
  • Running the UK SEMDEC Interface Program (R0018I4)
  • Setting Processing Options for UK SEMDEC Interface (R0018I4)
    • Defaults
    • Process
    • Currency
    • Print
    • Print
    • Version
• (DEU) Printing the German Intrastat Report
  • Understanding the German Intrastat Report
  • Running the Germany Electronic Submission (R0018IGF)
  • Setting Processing Options for Germany Electronic Submission (R0018IGF)
    • Identification
    • Shipping
    • Label
    • Tax Number
    • Report Period

A Fields in the SEPA Payments XML File

• Block A: Message Root
• Block B: Group Header Elements
• Block C: Payment Information Elements
• Block D: Credit Transfer Transaction Information
• Reviewing an Example of XML code for SEPA Core Payments

B SEPA Direct Debit XML File

• Group Header Elements
• Payment Information Elements
• Examples of Structured and Unstructured Modes of Payment in the XML

C Elements and Attributes for the Belgium Intracommunity ˚n 723 Report

• Elements and Attributes for the Belgium Intracommunity ˚n 723 Report
• Example of an XML File for the Belgium Intracommunity ˚n 723 Report

Glossary

Index