| Back Office into
Front Office Integration
80% of the MIG’s clients have a front office system. They
are looking to integrate into the back-office to eliminate double
entry and re-keying of information. This is perhaps the most important
integration an organization can undertake, which in turn leads to
a very high return on investment.
Background
To achieve payroll data synching from a web payroll processing portal
into the Great Plains (GP) user base.
Our goal was to create a direct synch-link that lets users click
a Chart of Accounts SYNCH button to upload their General Ledger
chart of accounts to the web Payroll processing portal back-end.
Once the chart of accounts is set up on the web back-end for the
specific client, after each pay period is finished, the client clicks
on the Payroll SYNCH button to download the payroll data in a specific
format then import it into Microsoft Business Solution Great Plains (GP)
as a single check.
Solutions/Integrated Functions
Created a plug-in that accomplished the transmission of the payroll
data directly from the web back-end to the Great Plains (GP) back-end
and vice versa. The plug-in runs a wizard-type interface on the
browser to select the Great Plains (GP) versions, and then format the
data accordingly, to be imported directly into Great Plains (GP).
Phases of Project
- Install and configure Great Plains (GP) & SDK
- Build an ActiveX plug-in which communicates with the Great Plains (GP)
COM object, login, and read the General Ledger accounts.
- Build a web page to test the running of the ActiveX plug-in
while browsing, using an Internet Explorer (I.E) browser.
- Develop code to test the communication from the ActiveX plug-in
to the server.
- Automatically import a payroll summary transaction and post
it into predefined General Ledger accounts.
- Deliver the ActiveX plug-in developed along with the communication
code, to work with the Payroll processing portal backend.
Technical Details
We created two COM objects which would be called by the Payroll
portal ASP applications and a plug-in that automated the sync process
of importing payroll specific data into Great Plains (GP) with minimal
user intervention.
Return On Investment
Double keying of information was eliminated, which the Auditor of
our client was insisting was a major problem. Client retention rate
has increased through the automation of business processes. Our
client is offering the synch service as an option for $7.5/month
making this solution a revenue raising add-on product.
|
