Circles.png

  until the 2018 eoStar User Forum and Technology Conference (August 13-16)
Click here for details

EDI Plugin

From Wiki-eostar.com
Jump to: navigation, search

EDI or Electronic Data Interchange is a set of standards created by the National Institute of Standards and Technology that structures electrical or computer exchanges between and within businesses. Better put, it is a computer-to-computer transmission of business data in a standard format known as a Transaction Set, which replaces a traditional paper business document.

The EDI Plugin allows for the use of these standards in eoStar. The EDI Interface on eoStar allows for the use of multiple formats (UFF 4.0, X12) to and from trading partners.

Note: "Trading Partners" is an EDI term implying organizations that exchange EDI documents.

(For more information see EoStar EDI Menu or Wikipedia-EDI.)

In August 2010, changes were made so that users can now associate a warehouse with a trading partner. When exporting UFF EDI documents, the warehouse associated with a trading partner or transaction will provide the contact information in the header of the document, rather than the "master" information in the database configuration.

Setup EDI

The following items must be completed prior to importing and exporting EDI files:

  1. Communication software provided by the VAN such as GXS/Cleo software must be installed.
  2. File>Database Administration>Configure EDI panel should be filled out.
  3. The EDI trading partners should be added to the Database.
    1. When an alternate company name will be used, modify the Warehouse name for the dba and select the warehouse from the drop down under the Trading Partner name.
    2. Map the items and the Warehouses using the Item Map and Whse Map panels. Be sure to include the correct codes.
    3. Add the Vendor ID and the EDI or X12 settings.
  4. Go to EDI>Pack Name Mapping and map the required pack names.
  5. Go to EDI>Category Mapping and map the Product Categories.
  6. Customers must be assigned to EDI trading partners from the Records>Customer>Records > Assignments panel.
  7. Suppliers must be assigned to EDI trading partners from the Records>Suppler > Supplier > Terms/AP panel.
  8. The Duns + 4 numbers for the company and the customers should be set up.
    1. For the company, go to File>Database Administration>Configure Company Info Panel or Records>Warehouse>Record>ID panel.
    2. For the customers, go to Records>Customer>Records Location panel.

For more information on EDI setup see Setup:EDI Export&Import.

Applications added by the EDI Plugin

EDI Menu with Coke Plugin

The EDI Plugin adds several new capabilities to eoStar. The user can view and import files through the EDI File Browser and EDI Import. Additionally, it is easy to export Invoices and Advance Ship Notices to trading partners with the various options, and keep track of purchases and payments through the trackers.

  • File>Database Administration>Configure menu option.

EDI Menu:


EDI Menu with Miller Plugin

Orders Menu:

How-To Add Permissions for Access to the EDI Plugin for Employees

  • To add permission on an individual Employee basis, go to the Records>Employee>Records Plugins Panel. Under EdiPlugin, check the check boxes next to the permission setting wanted. When finished making changes, click the command button Post.
  • To add permission for a department, go to the Records>Employee>Departments Plugins Panel. Under EdiPlugin, check the check boxes next to the permission setting wanted. When finished making changes, click the command button Post.

Process Overview

These are the steps for EDI for an order.

The following is a list of the process of EDI transaction sets sent between a retailer and distributor. Note: The transaction sets required depend on the trading partner with whom you are working. Additionally, this will only work if the correct EDI Trading Partners are set up. Files are extracted on a daily basis through the eoStar EDI Export/Import Screens. They are then transmitted to the retailer via a program provided by the VAN such as Cleo for GXS.

  1. The retailer (customer) creates an order and sends a Purchase Order (850) to the Distributor (your company).
  2. The distributor then uses the EDI Import screen to import that Purchase Order (850). The Purchase Order (850) is automatically sent to the EDI Purchase Tracker.
  3. The distributor then uses either Send Pre-Delivery (894) Invoices or Send Pre-Delivery (894) Invoices (Uff4) screens to send a Pre-Delivery Notification (894) which outlines the order to the retailer.
  4. The retailer receives the sent Pre-Delivery Notification (894) from the distributor.
  5. The distributor then sends an Advance Ship Notice (856) using the Export Advance Ship Notices (ASN) screen. The advanced ship notices contain pallet information and requires some form of palletizing solution by the distributor.
  6. The retailer receives the sent Advance Ship Notice (856) from the distributor.
  7. The distributor sends the order, which is delivered to the retailer.
  8. The distributor sends an Invoice (810) using the EDI X12 Export 810 Invoices to the retailer.
  9. The retailer receives the sent Invoice (810) from the distributor.
  10. The retailer sends a Payment Order (820) to the distributor.
  11. The distributor then uses the EDI Import screen to import that Payment Order (820). The Payment Order (820) is automatically sent to the EDI Payment Tracker.

Issues

Certain issues in EDI may be caused by a misspelling of names. For example:

The Seagram's brand is spelled "Seagrams" in their DB. The Special handling bit, Vendor IDs, and pack info look right in the DB. However, because of the difference in spelling, the Seagram's sales aren't identified properly:

EDI Naming Issue

Change the spelling of the offending item, and eoStar should properly handle these.


Using and ~, *, or > in the product name will cause an unexpected data separation and the document will fail. GXS recommends using + to resolve the issue.

Notes for Developers

Logged in Developers, see EDI Testing Considerations.