Dimensions EDI Integration
EDI Sales Orders can be imported into Dimensions using Access Transaction Broker. They will be placed into the Sales Order batch ready for review and processing.
The invoices can then be exported to an EDI export file that can be imported in your EDI System.
Introduction
What is EDI?
EDI stands for Electronic Data Interchange and is strictly defined as "the exchange of business data from one organisation's computer application to the computer application of a trading partner". The messages exchanged are typically Orders and Invoices.
Why EDI?
Repetitive manual tasks are often required to support a business relationship, EDI automates the processing of these tasks and removes the paperwork element. EDI increases accuracy by eliminating the re-keying of data and the quality of data is enhanced by agreeing product codes, prices and location codes in advance.
How are EDI messages exchanged?
EDI may involve the use of secure private networks known as VANs (Value Added Networks), which securely and reliably deliver information between trading partners.
EDI messages may also be exchanged via the Internet using AS2 (Applicability Statement) an internationally agreed methodology for transacting secure and auditable business messages over the Internet.
Dimensions EDI Integration
EDI integration with Dimensions uses a combination of software solutions.
EDI Sales Orders are collected by your EDI system.
The Sales Orders are then imported into Dimensions using Access Transaction Broker. Access Transaction Broker is a middleware application that facilitates the flow of information from third party applications into Access Accounts.
Invoices and Credit notes can then be exported from Dimensions for import to your EDI system and transmission by EDI.
Supported Transactions
The Dimensions EDI Integration supports the import of Sales Orders and the export of Invoices and Credit notes.
Adjustments to-, and cancellations of sales orders within your EDI system are not imported to Dimensions.
Cross-reference data
Location codes and delivery addresses will be stored in both your EDI system and Dimensions as cross reference data.
When initially setting up the systems it is important to ensure that the delivery addresses held in your EDI System and those held in Dimensions are exactly the same.
When Sales Orders are written into Dimensions:
the delivery address on the order will be set to the delivery address held in your EDI system's database,
the Customer's delivery location code is written into the Description field on the Sales Order and included on the invoice so that it can be used as a key field when the invoice is imported back into your EDI system.
Required software
The following software is required to use the Dimensions EDI Integration system :
Your EDI software
Dimensions Version 2.42a or above
Configuration
2 dp value configuration
Please note that if your database is not set to 2 dp value configuration, you will need to modify your Invoice and Credit note layouts to 2 dp values in order for these to be compatible with the EDI invoices.
These rounding rules should be followed for the Invoice and Credit note modification:
Values ending in 4 should be rounded down.
Values ending in 5 should be rounded up.
Example: 2.644 should be rounded down to 2.64; 2.645 should be rounded up to 2.65.
Please link to the following pages for details of how to configure both Transaction Broker and Dimensions to integrate with EDI:
Configuring Customer records for EDI
Sales Order Mapping
Exporting EDI Transactions
EDI Export file
