Electronic Data Interchange (EDI)
Expandable's ELECTRONIC DATA INTERCHANGE module provides import and export capabilities for data rich translation and mapping into standard EDI documents.
To support the broad range of EDI options between two business partners, Expandable provides comprehensive export data sets and a minimum import data set in flat file formats transmitted via SFTP to an EDI translation, mapping and delivery provider.
The Value Added Network service provider or custom translation and delivery application takes the data required by the target trading partner and maps the data per user specifications and delivers them securely to the end trading partner.
File transfers are supported with Secure FTP (SFTP) from Expandable to SFTP Server(s). Each trading partner is supported by their own unique FTP setup and credentials, trading data and production/test mode of delivery within the Expandable Customer Master linking to EDT Partner SFTP server.
MODULE FEATURES
Expandable EDI Core Module
Expandable’s core EDI module supports from one to as many trading partners as required, providng all the necessary SFTP set up for data imports and exports for each trading partner.
Additional system set up utilities are included, allowing for EDI activity and error reporting and email notifications. Specific import and export flat file documents are added as required based on the information exchange supported by the businesses trading partner data requirements. Optional import and export data as required.
Sales Order Exports and Sales Order Changes
Sales Order Export sends a complete order data set with over 370 individual master and detail data fields. All or part of these fields can be mapped to into an EDI purchase order acknowledgement meeting any trading partner’s data requirements for acknowledgement of their order placement.
Unique tab delimited data files are delivered to the “IN” box of your trading partners SFTP site for sales orders that have been set up and confirmed (OPEN status after review and confirmation) for conversion to the trading partner’s order acknowledgement EDI format requirements.
Purchase Order Imports and PO Changes
Allows the importing of a minimum number of data fields from a flat TAB delimited file translated from a formal EDI Purchase Order Request. EDT PO Import also supports a number of optional fields that are echoed back to your trading partner through out the electronic exchange of order to invoice process. Unique tab delimited data files are retrieved from the “OUT” box of your trading partners SFTP site and imported into Expandable as an on HOLD Sales Order allow for operations review. The import can be configured to accomodate drop shipments.
Sales Order Shipment Transactions Export
EDT Order Shipments Export exports completed Order Shipment Data supporting EDI Shipment Notification with over 190 individual shipment transaction data fields. All or part of these fields can be mapped back to into an EDI Shipment Notification as required by the Trading Partner. Unique tab delimited data files are delivered to the “IN” box of your trading partners SFTP site for conversion to Order Shipments meeting the Trading Partner’s Shipment Notice EDI format requirements.
Invoice Export
EDT Invoice Export exports complete Invoice Data supporting EDI Invoices with over 370 individual invoice data fields. All or part of these fields can be mapped back to into an EDI Invoice as required by the Trading Partner. Unique tab delimited data files are delivered to the “IN” box of your trading partners SFTP site for conversion to Invoices meeting the Trading Partner’s Invoice EDI format requirements.
Purchase Order Exports and PO Changes
EDT Purchase Export exports complete Purchase Order Data supporting EDI Purchase Orders with over 340 individual invoice data fields. All or part of these fields can be mapped back to into an EDI Purchase Order as required by the Trading Partner. Unique tab delimited data files are delivered to the “IN” box of your trading partners SFTP site for conversion to Purchase Orders meeting the Trading Partner’s Purchase Order EDI format requirements.
Non-PO Invoice Import
EDT Non-PO Invoice Import allows the user to import Non-PO related Invoices into the AP Vouchering system for payment. This functionality is particularly useful in application that generate expense related data that requires the Accounts Payable team to payout. Unique tab delimited data files are imported with detail into the AP Voucher Header and Voucher Detail from systems such as an Expense Management System.
Enter transactions using your mobile device and Bluetooth scanner
SYSTEM REQUIREMENTS
Expandable ERP
- Expandable Release 9.1.0 or higher (with .NET API)
- Matching version Expandable Sales Order API
Server Side
- Windows Server 2003 – Supporting Task Scheduling
- SQL 2008, SQL 2008R2
Client Side
- Windows XP SP2 or Windows 7
- Internet Explorer 9 or higher (Activity HTML Reporting)
- Adobe Reader (for documentation)
Partner VAN FTP Server Requirements
- Trading Partner SFTP Server Credentials
- Passive Mode FTP Operation
- IN/OUT and TESTIN/TESTOUT Structured File Folders