Contents

• Title and Copyright Information
• Preface

1 Introduction to JD Edwards EnterpriseOne Data Interface for Electronic Data Interchange

• JD Edwards EnterpriseOne Data Interface for Electronic Data Interchange Overview
• JD Edwards EnterpriseOne Data Interface for Electronic Data Interchange System Integration
  • JD Edwards EnterpriseOne Sales Order Management
  • JD Edwards EnterpriseOne Procurement
  • JD Edwards EnterpriseOne Inventory Management
  • JD Edwards EnterpriseOne Accounts Payable
  • JD Edwards EnterpriseOne Accounts Receivable
  • JD Edwards EnterpriseOne Demand Scheduling Execution
• JD Edwards EnterpriseOne Data Interface for Electronic Data Interchange Implementation
  • Global Implementation Steps
  • Data Interface for Electronic Data Interchange Implementation Steps

2 Understanding Data Interface for the Electronic Data Interchange System

• Understanding the Electronic Data Interchange System
• Understanding EDI Standards
  • Preparing the System for EDI Implementation
  • EDI Considerations
  • Agreements With Trading Partners
• Understanding EDI Document Processing
• Understanding Electronic Documents Supported by the JD Edwards EnterpriseOne System
• Understanding Program and Table Naming Conventions

3 Setting Up Interfaces for Electronic Data Interchange

• Understanding EDI Interfaces
  • Testing Strategies
  • User-defined Codes for EDI
  • Prerequisites
• Understanding Flat File Data Formatting
  • Flat File Data
  • Formatting Flat File Data for Inbound Documents
    • Dates
    • Numeric Values
    • Character Values
  • Formatting Flat File Data for Outbound Documents
    • Dates
    • Numeric Values
    • Character Values
    • Example: Formatting Flat File Data for Outbound Documents
• Setting Up Customer Billing Instructions
  • Understanding Customer Billing Instructions
  • Prerequisites
  • Forms Used to Set Up Customer Billing Instructions
  • Setting Up Customer Billing Instructions
  • Entering EDI Information for the Customer
  • Entering EDI Transaction Cross-Reference Data for the Customer
• Establishing EDI Information for Suppliers
  • Understanding EDI Information for Suppliers
  • Form Used to Enter EDI Information for Suppliers
  • Entering EDI Information for Suppliers
• Defining EDI Tolerance Rules
  • Understanding EDI Tolerance Rules
  • Form Used to Define EDI Tolerance Rules
  • Adding Tolerance Rules

4 Processing EDI Documents

• Processing EDI Documents
• Receiving EDI Standard Business Documents
  • Understanding the Inbound Flat File Conversion Program (R47002C)
  • Understanding the Inbound Edit/Update Program (R47091)
    • Taxed Prices
  • Accessing the Translator Software Files
  • Running the Inbound Flat File Conversion (R47002C)
  • Setting Processing Options for Inbound Flat File Conversion (R47002C)
    • Transaction
    • Separators
    • Process
  • Running the Inbound Edit/Update Program (R47091)
  • Checking for Inbound Edit/Update Errors
    • Example: Errors from Inbound Flat File Processing
    • Example: Errors from Edit/Update Processing
• Sending EDI Standard Business Documents
  • Understanding the Outbound Extraction Program
  • Understanding the Outbound Flat File Conversion Program
  • Understanding the Update as Sent Program
  • Running the Outbound Flat File Conversion Program
  • Checking Outbound Flat File Conversion Errors
  • Sending EDI Standard Documents to the Network
• Purging Data from the EDI Interface Tables

5 Running Inquiries and Revising EDI Documents

• Understanding EDI Documents
• Determining Document Status
  • Understanding EDI Document Status
  • Form Used to Determine Document Status
  • Running Inquiries on Document Status
• Revising EDI Documents
  • Understanding EDI Document Revision
  • Form Used to Revise EDI Documents
  • Correcting or Deleting EDI Documents
  • Revising EDI Control Information
• Reviewing or Changing Inbound Shipping Information
  • Understanding Inbound Shipping Information
  • Forms Used to Review or Change Inbound Shipping Information
  • Accessing Inbound Shipping Notices
• Reviewing or Changing Outbound Invoice Information
  • Understanding Outbound Invoice Information
    • Taxed Prices
  • Prerequisite
  • Forms Used to Review or Change Outbound Invoice Information
  • Revising Header Information for Outbound Invoices
  • Changing Detail Information for Outbound Invoices
  • Revising Detail Charges for Outbound Invoices

6 Receiving and Sending Electronic Data Interchange Sales Order Documents

• Receiving Requests for Quotes (840/REQOTE)
  • Understanding Inbound Requests for Quotes
    • EDI Inbound Interface Tables
    • Mapping Guidelines
    • Application Table Update
  • Prerequisites
  • Receiving Requests for Quotes
• Receiving Customer Orders (850/ORDERS)
  • Understanding Inbound Customer Orders
    • Shipment, Destination, Quantity Orders
    • EDI Inbound Interface Tables
    • Mapping Guidelines
    • Updating Application Tables
  • Prerequisites
  • Form Used to Process Customer Orders
  • Revising EDI Inbound Order Information
  • Receiving Customer Orders
• Receiving Customer Order Changes (860/ORDCHG)
  • Understanding Inbound Customer Order Changes
    • Using the EDI Inbound Interface Tables
    • Using Mapping Guidelines
  • Form Used to Process Customer Order Changes
  • Processing Customer Order Changes
• Receiving Advice into Sales (861/RECADV)
  • Understanding Inbound Receiving Advices
    • Using the EDI Inbound Interface Tables
    • Using Mapping Guidelines
    • Updating Application Tables (Release 9.1 Update)
  • Form Used to Receive Advice Into Sales
  • Receiving Advice Into Sales
• Receiving Ship and Debit Claim Acknowledgments (845/PRICAT)
  • Understanding Inbound Ship and Debit Claim Acknowledgments
    • Flat File Cross-Reference for Acknowledgments
    • Using Mapping Guidelines
  • Prerequisites
  • Setting Up the Flat File Cross-Reference for Acknowledgments
  • Receiving Claim Acknowledgments (845/PRICAT)
• Receiving Ship and Debit Claim Status (849/ORDRSP)
  • Understanding Inbound Ship and Debit Claim Status
    • Flat File Cross-Reference
    • Notifications of Claim Status
    • Using Mapping Definitions
  • Prerequisites
  • Setting up the Flat File Cross-Reference for Claim Status
  • Receiving Notifications of Claim Status (849/ORDRSP)
• Sending Responses to Requests for Quotes (843/QUOTES)
  • Understanding Responses to RFQs
    • Running the Outbound Extraction Program to Send Responses to RFQs
    • Using Application Tables
    • Using EDI Outbound Interface Tables
  • Forms Used to Process Sales Quotes
  • Processing Sales Quotes
• Sending Order Acknowledgments (855/ORDRSP)
  • Understanding Outbound Order Acknowledgments
    • Using Application Tables to Send Order Acknowledgments
    • Using EDI Outbound Interface Tables to Send Order Acknowledgments
  • Sending Order Acknowledgments
• Sending Order Change Acknowledgments (865/ORDRSP)
  • Understanding Outbound Order Change Acknowledgments
    • Using EDI Outbound Interface Tables to Send Order Change Acknowledgments
    • Using Application Tables to Send Order Change Acknowledgments
  • Sending Order Change Acknowledgments
• Sending Shipping Notices (856/DESADV)
  • Understanding Outbound Shipping Notices
    • Generating Shipping Notices
    • Example: Generating an Outbound Shipping Notice
    • Using Mapping Guidelines
    • Using Application Tables
    • Using EDI Outbound Interface Tables
  • Setting Processing Options for Advanced Ship Notice (ASN) Extraction (R47032)
    • Update
  • Prerequisite
  • Forms Used to Process Advanced Shipping Notices
  • Setting Up Hierarchical Configuration Definition
  • Processing Advanced Shipping Notices
• Sending Invoices (810/INVOIC)
  • Understanding Outbound Invoice Transmissions
    • Using Application Tables When Sending Invoices
    • Using EDI Outbound Interface Tables When Sending Invoices
  • Sending Invoices
  • Running the EDI Invoice Extraction Conversion Program (R47042C)
  • Purging Outbound EDI Invoice Documents
• Sending Ship and Debit Claims (844/ORDCHG)
  • Understanding Ship and Debit Claims
  • Prerequisite
  • Sending Ship and Debit Claims

7 Receiving and Sending Electronic Data Interchange Demand Scheduling Executions Documents

• Demand Scheduling Execution EDI Transactions and Messages
  • Material Release, Delivery Schedule (830, DELFOR)
  • Daily Ship Schedule, Delivery Just in Time (862/DELJIT, 866/DELJIT-JS)
  • Advance Ship Notice, Despatch Advice (856/DESADV)
  • Receiving Advice (861/RECADV)
  • Purchase Order/Release (850/ORDERS)
  • Text, General Purpose (864/GENRAL)
  • Remittance Advice (820/REMADV)
  • Application Advice, Application Error & Acknowledge (824/APERAK)
  • Invoice (810/INVOIC)
  • Functional Acknowledgment (997/CONTRL)
  • Forms Used to Revise Demand Scheduling EDI Information
  • Revising Demand Scheduling EDI Header Information
  • Revising Demand Scheduling EDI Detail Information

8 Processing EDI Purchase Order Documents

• Understanding EDI Purchase Order Document Processing
• Receiving PO Change Acknowledgments
  • Understanding Inbound PO Change Acknowledgments (865/ORDRSP)
    • Using the EDI Inbound Interface Tables
    • Using Mapping Guidelines
    • Updating Application Tables
  • Form Used to Review and Revise Purchase Order Change Acknowledgments
  • Reviewing and Revising Purchase Order Change Acknowledgments
• Receiving Advice Documents into Purchasing
  • Understanding Inbound Advices into Purchasing (861/RECADV)
    • Using the EDI Inbound Interface Tables
    • Using Mapping Guidelines
    • Updating Application Tables
  • Receiving Advice Into Purchasing
• Receiving Invoices with Receipt Matches
  • Understanding Inbound Invoices with Receipt Matches (810/INVOIC)
    • Using the EDI Inbound Interface Tables
    • Using Mapping Guidelines
    • Updating Application Tables
  • Receiving Invoices with Receipt Matches
  • Forms Used to Process Inbound EDI Invoices
  • Processing Inbound EDI Invoices
• Receiving PO Acknowledgments
  • Understanding Inbound PO Acknowledgments (855/ORDRSP)
    • Using the EDI Inbound Interface Tables
    • Using Mapping Guidelines
  • Form Used to Review and Revise Purchase Order Acknowledgments
  • Review and Revise Purchase Order Acknowledgments
• Receiving Shipping Notices
  • Receiving Inbound Shipping Notices (856)
  • Forms Used to Process Inbound Shipping Notices
  • Processing Inbound Shipping Notices
  • Purging Inbound Shipping Notices (856)
• Sending Requests for Quotes
  • Understanding Outbound Requests for Quotes (840/REQOTE)
    • Using Application Tables
    • Using the EDI Outbound Interface Tables
  • Prerequisite
  • Sending Requests for Quotes
• Sending Purchase Orders
  • Understanding Outbound Purchase Orders (850/ORDERS)
    • Using Application Tables
    • Using the EDI Outbound Interface Tables
  • Prerequisite
  • Sending Purchase Orders
• Sending Purchase Order Changes
  • Understanding Outbound Purchase Order Changes (860/ORDCHG)
    • Using Application Tables
    • Using the EDI Outbound Interface Tables
  • Prerequisite
  • Sending Purchase Order Changes
• Sending Receiving Advice
  • Understanding Outbound Receiving Advice (861/IFTMAN)
    • Using Application Tables
    • Using the EDI Outbound Interface Tables
  • Sending Receiving Advice
• Sending Shipping Schedules
  • Understanding Outbound Shipping Schedules (862/DELJIT)
    • Using Application Tables
    • Using the EDI Outbound Interface Tables
    • Defining the Version of Kanban Processing
  • Defining the Version of Kanban Processing
  • Defining the Version of PO Print (R43500) for Kanban Consumption

9 Processing EDI Inventory Documents

• Understanding EDI Inventory Document Processing
• Receiving Product Activity Data
  • Understanding Inbound Product Activity Data Transactions
    • Working With the Product Activity Code
    • Using the EDI Inbound Interface Tables
    • Using Mapping Guidelines
    • Updating Application Tables
  • Receiving Product Activity Data
• Sending Product Activity Data
  • Understanding Outbound Product Activity Data Transactions
    • Using Processing Guidelines
    • Updating Application Tables
    • Using the EDI Outbound Interface Tables
  • Sending Product Activity Data

10 Processing EDI Scheduling and Planning Documents

• Understanding EDI Scheduling and Planning Document Processing
• Receiving Planning Schedule Forecasts
  • Understanding Inbound Planning Schedule Forecasts
    • Working With the Transaction Processing Mode
    • Using the EDI Inbound Interface Tables
    • Using Mapping Guidelines
    • Updating Application Tables
  • Receiving Planning Schedule Forecasts
• Sending Planning Schedule Forecasts
  • Understanding Outbound Planning Schedule Forecasts
    • Using Application Tables
    • Using the EDI Inbound Interface Tables
  • Sending Planning Schedule Forecasts

11 Using EDI Financial Documents

• Understanding Financial Documents
  • EDI Inbound Interface Tables
  • Mapping Guidelines
  • Application Tables Updated
• Understanding the Creation of Inbound EDI Vouchers
• Receiving Invoice-Summary Documents (810/INVOIC)
  • Understanding Invoice-Summary Documents
  • Receiving Documents
• Processing Voucher Information
  • Understanding Voucher Processing
  • Processing Invoice Information
  • Purging Processed Inbound EDI Vouchers
  • Setting Processing Options for Inbound EDI Voucher Edit/Create (R47041)
    • Processing
    • Default Option
    • Default Values
    • Logging
    • Auto Process
• Receiving Lockbox Transactions (823/CREMUL)
  • Understanding Lockbox Transactions
    • EDI Lockbox Interface Tables
    • Mapping Guidelines (Release 9.1 Update)
    • Receiving Transactions
  • Receiving Transactions
• Sending Payment Orders with Remittance (820/PAYEXT)
  • Understanding Payment Order Remittances
    • Application Tables Providing Data
    • EDI Outbound Interface Tables
    • Setup Considerations

12 Appendix A - JD Edwards EnterpriseOne Solution IDs for EDI Transactions

• Electronic Data Interchange Solution IDs

13 Glossary

• Address Number
• Archive
• Authorization to Meet Competition Number
• Batch Number
• Card Number
• Data Element
• Delivery Batch Number
• Document Number
• EDI Standard
• Electronic Commerce
• Electronic Data Interchange (EDI)
• Global Location Number
• Hierarchical Configuration
• Hierarchical Structure Code
• Inbound Document
• Job Number
• Job Sequence Number
• Mapping
• Off Line Date
• Outbound Document
• Product Type
• Purge
• Record Type
• Reference Number
• Routing Date
• Routing Order Sequence Number
• Routing Time
• SCAC (standard alpha carrier code)
• Segment
• Send Method
• SSC Number (shipment container code number)
• Standard Document
• Syntax
• System 47
• Tolerance Rules
• Trading Partner
• Transaction Set
• Transaction Set Purpose
• Translator Software
• UPC Number