Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Once the application is successfully installed, the following message will be displayed.

 

 

 

 

Create new database for EDIHQ in SQL Management Tools.

      From SQL Server Management Studio > right click on Databases > New Database > Type in the Database name > click OK.

 

Image Added

 

 

 

Create 32/64 Bit ODBC Data Source for Aeros ERP.

  1. From the Server where EDI HQ was EDIHQ application was installed > Search in Administrative Tools folder > Open the appropriate ODBC Data Sources (32-bit or 64-bit).

...

     7. If the connection is successfully established, the following window will be displayed.

 

 

 

 

Create new EDIHQ

...

      From SQL Server Management Studio > right click on Databases > New Database > Type in the Database name > click OK.

 

Image Removed

 

 

Create new EDI HQ Data Source pointing to MSSQL.

     1. Open EDI HQ EDIHQ application > Setup > Data Sources.

...

     10. Highlight the database that you just create and check the Default check box > click Close.

 

 

 

Create ODBC Connection objects in EDI HQ for Aeros ERP's EDI tables.

Tools > Current Data Source Settings > Integration Settings.

...

  1. Setup connection to EDI_File table.




    Click on the Test Connection button to confirm that the connection has been established succesfully.
    If the test is successful, the following screen will be displayed.



  2. Setup connection to EDI_POHeader table.
    Click on the Test Connection button to confirm that the connection has been established succesfully.



  3. Setup connection to EDI_PODetail table.
    Click on the Test Connection button to confirm that the connection has been established succesfully.



  4. Setup connection to EDI_Transmission table.
    Click on the Test Connection button to confirm that the connection has been established succesfully.



  5. This is how the screen would look after all the ODBC connection objects have been established.

 

 

Create File definitions for Outbound documents.

 

 

 

 

Create Inbound File definition.



 

Create EDI to ERP File Update StatusID.

 

 

 

 

Create 882 DSD Summary (If needed).

 

 

 

 

Create Processes.

 

 

 

 

Create Jobs for Inbound and Outbound Processes.

 

 

 

 

Create Triggers for Jobs.