Overview
The SQL API integration code "FMISSQLAPI" is used integration LinkSOFT with a FMIS database.
The following SQL API integration packs are
available:
-
-
-
-
-
-
Steps to configure the SQL API
integration
:
-
Apply
the appropriate SQL API integration scripts using SSMS to
the FMIS/ERP database. The scripts are located in the installed folder:
<Installed Folder>\Link Technologies\DBIntegrationScripts
-
Configure the connection details in menu
"Integration -> Integration Setup -> FMISSQLAPI -> Integration
Settings"
-
-
Database Name
: Enter the
FMIS database
name
-
User Name
: Enter the SQL User Login Name that will
be used to connect to the FMIS database. This field
is required when the FMIS database is on
a different
server.
-
Password
: Enter the
SQL User's
password.
-
Enable the following processes in menu "Company
Administration -> Processes".
These processes are used to interact between LinkSOFT
and FMIS
database.
-
FMIS Import - Perform all master file import from
FMIS. This includes Accounts Receivable, Accounts Payable, Inventory
and General
Ledger
-
FMIS AP - Perform FMIS integration
for Accounts
Payable
-
FMIS AR - Perform FMIS integration for
Accounts Receivable
Process
-
FMIS AR Validate - Perform FMIS integration for
Accounts Receivable
Validate
-
FMIS GL - Perform FMIS integration
for General
Ledger