Lenmax Software.


EDI Translator for Adagio Accounting

EDI Translator for Adagio provides 100% automated integration with Adagio Inventory, Order Entry and Receivables, eliminating manual data import and export. It translates valid EDI X12 ASCII files into Adagio recognizable documents such as Sales Orders.

  • Supports the following EDI transactions:
    • Inbound: 850 (Purchase Order), 940 (Shipping Order),  997 (Functional Acknowledgment), 864 (Message)
    • Outbound: 856 (Advance Shipping Notice), 810 (Invoice), 855 (PO Acknowledgment), 812 (Credit/Debit Adjustment), 997 (Functional Acknowledgment)
  • Supports all basic EDI transaction sets
  • Imports sales orders and credit notes that have been created via manual entry by the Adagio user (for future submission via EDI 856, 810 or 812)
  • Imports Trading Partner store numbers as Customer Ship-To Codes
  • Uses Adagio optional fields to keep EDI related information (for centralized data storage)

How does EDI Work? (Purchase Order Example)

  • The buyer enters order information into the production database, which generates a purchase order on the computer. The order information is then channeled through a number of interface programs.
  • The interface software programs perform edits and checks on the document and direct the order data into predefined EDI intermediate files.
  • The EDI intermediate files contain information in a form that the EDI translation software can read.
  • The translation software is a set of programs that translates the interface file data into a document formatted according to EDI standards that the supplier's computer can recognize.
  • The electronic document now consists of a file that contains the order data in a predefined, recognizable order.
  • The communications software adds appropriate communications protocol to the EDI document in preparation for transmission via telephone lines or internet. 
  • Using a modem or WAN, the buyer transmits the EDI purchase order to a VAN (Value added network). Think of this as a mailbox.
  • The communications software on the supplier's computer picks up the document from the VAN, and interprets and/or converts the communications protocols to open the electronic document.
  • The purchase order is now in a standard, recognizable format in a file and is available to the supplier's computer.
  • The supplier's translation software interprets the documents from the EDI format and places the order information in EDI intermediate file(s).
  • The EDI intermediate files contain the translated purchase order information.
  • The interface programs perform edits and checks before the data is integrated with the supplier's production database.
  • The application software on the supplier's computer can now process the buyer's order.

What is the most common EDI cycle?

  1. Customer transmits EDI 850 (purchase order)
  2. Supplier transmits EDI 997 (functional acknowledgement)
  3. Supplier transmits EDI 856 (advance ship notice)
  4. Customer transmits EDI 997 (functional acknowledgement)
  5. Supplier transmits EDI 810 (electronic invoice)
  6. Customer transmits EDI 997 (functional acknowledgement)
  7. Customer transmits EFT (Electronic Funds Transfer) Payment

Inbound processing (850,940,864,997)

  • Runs as Windows service , monitoring the EDI Inbox directory for incoming EDI X12 ASCII files
  • Service creates one Sales Order in Adagio OrderEntry per one Purchase Order in EDI file.  If for any reason an attempt is made to re-import a Purchase Order, the software will prevent creation of the second copy of sales order
  • Records the Purchase Order number into the reference field of the sales order document, sets EDI status in the comments or other configurable field
  • Supports company IC item to Trading Partner SKU/Item/Retail UPC/Case UPC cross reference, validating that all PO detail lines reference valid IC items
  • Supports AR Customer Ship-To to Trading Partner store number cross referencing
  • Provides audit reports for all imported EDI source files
  • E-mails all exceptions or errors to configurable list of system's users
  • E-mails content of 864 transaction to configurable list of system's users
  • Allow to re-import  EDI source file(s) to recover from system errors (certain restrictions may apply)
  • Sends Acknowledgment (997) to Trading Partner for inbound transactions

The Advanced Shipment Notice (856)

  • Uses Adagio's optional fields to map all EDI related information to the Adagio Sales Order. This keeps all the sales order information in one place and minimizes the number of different personnel (shippers, customer service, data entry operators) entering ASN-related information.
  • An intuitive user interface (UI) allows users to select only Sales Orders that are ready to be transmitted as ASN
  • All mandatory segments entered by the Adagio user are validated during shipping procedures before EDI file(s) are generated
  • Displays and logs all exceptions on the user's screen
  • Sets status (comments fields in Sales Order) after successful EDI file generation
  • Delivers EDI files to a folder to be processed by EDI communication software
  • Provides the ability to re-generate ASN transaction(s)
  • Provides an audit report for all generated EDI source files

The Invoice (810)

  • Uses Adagio's optional fields to map all EDI related information to Adagio Invoices. This keeps all the invoice information in one place. Intuitive user interface allows users to select only invoices ready to be transmitted as 810
  • All mandatory segments entered by the Adagio user are validated during invoicing procedures before EDI files are generated
  • Displays and logs all exceptions on the user's screen
  • Sets status (comment field in Sales Order) after corresponding 997 is received
  • Delivers EDI files to a folder to be processed by EDI communication software
  • Provides ability to re-generate 810 transaction(s)
  • Provides an audit report for all generated EDI source files

Messages (864) and Functional Acknowledgements (997)

  • An EDI 864 transaction gives users the ability to electronically send messages, contracts, explanations, and other one-time communications. The inbound 864 is converted to an email message which is sent to configurable list of system's users
  • An EDI 997 Functional Acknowledgment is an electronic version of a receipt. The Functional acknowledgment tells a sending trading partner that a receiving trading partner has in fact successfully received EDI transactions. The inbound 997 flags the status of the Adagio document (using the comments field in the sales order and invoice) allowing customer service to trace Sales Order and Invoice status right from Adagio OE

Currently certified with the following Trading Partners:

THE HOME DEPOT

PRINCESS AUTO

RONA INC

FEDERATED COOP LTD

HOME HARDWARE INC

LONDON DRUGS

LOWE’S CANADA

DO IT BEST

LOBLAWS

Forzani Group Ltd

SAFEWAY INC

OVERWAITEA FOOD GROUP

TARGET CANADA

SOBEYS INC

WAL-MART CANADA

 

Reference Materials

EDI Translator Data Sheet

Copyright © 2010 Lenmax Software Solutions Incorporated. All rights reserved. Adagio is a registered trademark of Softrak Systems Inc.