EDI Order to Cash Preparation - An Outline


Trading Partner


  1. Document/retrieve all trading partner agreements.  Update as necessary with legal department.
  2. Retrieve/update each trading partner EDI mapping and shipping/receiving document.  This is usually available at the Partner secured web site.  Ensure valid logons are available/created.
  3. Identify each Trading Partner EDI help desk contact information.
  4. Identify each pre-agreed EDI document to be exchanged.
  5. Document pending/untested documents in preparation stages.
  6. Prepare announcement letter to each Trading Partner to notify them of the impending change of ERP systems.  Mail/send prior to go-live testing.  Some may require re-certification, but most will not.  Notification is ‘heads-up’ to early detect any deficiencies and forestall initial chargeback due to format/content errors or discrepancies. 

Data Structure


  1. Analyze the data format, structure and process for the non-ERP to ERP interfaces.
  2. Map/Identify data element components from each source system, how retrieved and updated with format and properties defined.
  3. Document resulting interface tables/records to be used for EDI processing.
  4. Develop corresponding logical file overlay for EDI mapping software.
  5. Develop corresponding EDI mapper User File Definition (UFD) or SQLQuery to link tables.
  6. Test and validate all file/table creation and included data elements and formats.
  7. Create a structural functional test map for each type of transaction format (Order (including SDQ), Invoice, ASN, etc.)
  8. Make adjustments as required.
  9. Validate that the mapping process will work with the table/file structure as presented.
  10. Business Process – Preliminary Testing

Define various order types, processes and data requirements.


  1. Define Customer response requirements and change processes (Order confirmation and/or change).
  2. Define fulfillment business process scenarios: Packaging, Pick n Pack, Pallet, LTL (Less Than Truck Load), Truck Load.
  3. Assign Trading Partners to a business process to group for mapping and testing that correspond to previously defined classification/type.
  4. Identify existing or new inbound orders that will meet the business process requirements by Trading Partner.
  5. Process each order or set of orders by Trading Partner or Business Process (whichever is more expedient).
  6. Map data process flow through the ERP system to verify all elements are passed correctly and data fields are accurately updated (especially for split lines and line change/modification/cancellation).
  7. Generate outbound files for test data mapping and validation.
  8. Test third party integration data components for accuracy and validity.

Define File, Table and data usage.


  1. Document each data element required by the process, its properties and how it will be utilized and passed through (and if it will pass) the ERP system.  Example would be use of user fields and fields normally used for PO numbers.
  2. Identify/Create interface files for mapping as determined by preliminary testing.  These may include auxiliary files to compliment the ERP standard EDI interface file structures on both the inbound as well as the outbound side of the fulfillment process.  These files may also compliment third party auxiliary systems external to the ERP system process architecture (i.e. LogPro, Pfastship, etc.)
  3. Identify cross reference tables used to identify address book to customer ship to locations, etc.
  4. Define external and ERP internal table resources and usage.
  5. Specify user exits for EDI mapper tool to access cross reference tables and lookups.

Mapping Process and End to End testing.

(Each Trading Partner)


  1. Create Trading Partner prototype maps for Order, Invoice and ASN based on available test data and completed orders (see business process above).
  2. Process the EDI files and create inbound/outbound EDI transactions records.
  3. Validate format of EDI transactions according to individual Trading Partner requirements documentation.
  4. Validate format and data content of EDI transactions based on business process and Dorel data content.
  5. Validate completeness of each transaction (no missing data fields that are required to meet Trading Partner specifications).
  6. Compare and Validate ASN transaction data content and format with the corresponding Invoice transaction to verify it matches originating order and subsequent changes (especially line level modifications/splits).
  7. Update status sheet and freeze maps for production insertion.
  8. Repeat for each trading partner map.

Operational Pre-Production


  1. Develop reports, logs and other materials as needed to manage the ongoing production EDI process.
  2. Segregate EDI production maps from ongoing development/maintenance (utilize dual data libraries with Inovis).
  3. Identify operational procedures to insure that the daily EDI interface processing occurs on a regular, scheduled and confirmable basis.
  4. Develop documentation of the EDI Trading Partner agreements, maps, processes & procedures.
  5. Document audit trails (as may be required by Sarbanes-Oxley Act) and transaction process flows.
  6. Develop charge-back monitoring and control to quickly respond to errors and omissions that result in financial penalties due to incomplete or inaccurate EDI transactions submitted to Trading Partners. (See Trading Partner Agreements).