|
This section explains how to do the one time setup required for Great Plains to process Seradex transactions. The process will take approximately thirty minutes. The integration manager module of Great Plains is utilized to process Seradex AR, AP and GL batches into Great Plains.
Step 1: Copy Integration Manager Files onto Server
Contact your Seradex project manager for the Integration Manager Database and five csv files. The files required are:
IM.mdb – This is the integration database that contains the Seradex integrations:
APMAIN.csv
|
AP Data File
|
APTAXES.csv
|
AP Tax Data File
|
ARMAIN.csv
|
AR Data File AR
|
ARTAXES.csv
|
AR Data File AR Tax Data
|
GLMAIN.csv
|
GL Data File
|
These files need to be placed on your server where personnel using Great Plains can access. Please make note of where you put them.
Step 2: Configure Integration Manager
Launch the integration manager. If you have existing integrations you want to keep you have to import the integrations. From the main integration manager form select File Import Integration. You will be presented now with an open dialog window, please select the IM.MDB provided in the folder you put them in.
Now you should see the three Seradex integrations
Now the next step is to modify each Seradex integration to bind it to the appropriate data file(s).
General Ledger Transactions
Highlight the ! Seradex GL trx integration and Click Open.
Next, under sources, double click GL TRX HDR
Click the button to the right of the File Path Box to change it to GLMain in the folder you put on the server. Then click apply.
Select Yes then OK.
Repeat the exact procedure for GL Trx Detail. Now you will be returned to the Integration form. Final step is to Add the destination mapping.
Right click on Destination Mapping and select Add Destination.
Click OK then select GL Transaction
Click Open. To Set the log path, Double click on the Seradex GL TRX Header.
Select Logs Tab. Set the Path to the folder destination on the server for the log files.
Click the save button at the top of the integration manager form. The process for the Payables and Receivables are done the same way. Below is a table with the steps and the action needed.
Accounts Payable Transactions
|
|
|
Set Source File PM Tax Details
|
Select APTAXES.csv
|
Set Source File PM Dist
|
Select APMAIN.csv
|
Set Source File PM Headr
|
Select APMAIN.csv
|
Destination Mapping
|
Payables Transaction (if already there ignore step)
|
The rest of the steps are the exact same as in the GL example
Accounts Receivable Transactions
|
|
|
Set Source File Rec Trx Header
|
Select ARMAIN.csv
|
Set Source File Rec Trx Dist
|
Select ARMAIN.csv
|
Set Source File Rec Tax Details
|
Select ARTAXES.csv
|
Destination Mapping
|
Receivables Transaction (if already there ignore step)
|
The rest of the steps are the exact same as in the GL example.
Setting Up OrderStream
Now that you have done that launch ActiveERP. From the main profile Select Utilities then select Company Setup.
Make sure you that your Day end Export Path is set to the folder you put the CSV files provided. Now go to Additional Information and ensure Great Plains is selected (talk to your project manager if it is not available)
|
