BLOG SPOT

08/13/2017

Alister Harris

Framework completes GP integration project for Sessions Payroll.

eConnect Integration with GP Dynamics for Sessions Payroll

Framework completes a project for Sessions Payroll, Hollywood’s number one movie extra payroll bureau, to integrate their custom .Net Payroll Portal with GP Dynamics for fully automated accounting.
GP Dynamics, what is it?

GP Dynamics, what is it?

Microsoft GP Dynamics is a complete enterprise resource planning (ERP) solution for small and medium sized businesses. It is a flexible and configurable back office accounting system designed to help businesses gain greater control over their financials, inventory, and operations.

Dynamics GP includes:

  • Financial management and accounting
  • Inventory management and operations
  • Sales and service
  • Business intelligence and reporting
  • Human resources and payroll

eConnect, what is it?

eConnect is Microsoft middleware used for building integration between Microsoft back-office applications including GP Dynamics. It is a collection of tools, components and interfaces that allow external applications like web store fronts, web services and POS systems to programmatically interact with Microsoft Dynamics GP.

What did Framework do?

Framework's consultants created a custom .Net solution for Sessions some years ago. This project built on top of the Payroll Portal and involved utilizing eConnect to submit invoice data generated by daily payroll cycles, in order to push this data into the GP Dynamics AR module from where automated posting routines generate General Ledger (GL) entries.

The net result is that Sessions is able to produce fully automated financials on an as needed basis.

What were the challenges in this project?

What were the challenges in this project?

  • Migrating accounting data in from QuickBooks.
  • Deprecating a manual general ledger accounting process, and replacing it with a fully automated process due to the complexites of determining a starting point.
  • The Great Plains multi-company process setup required eConnect calls associate companies with their parent companies to assist in cash receipt posting.

What did Framework have to build?

  • eConnect calls to insert invoices into Great Plains.
  • eConnect calls to insert new client companies and parent company associations.
  • Nightly Automated SQL Jobs to push the invoice data to Great Plains.
  • Email notifications to internal staff of invoice nightly push with relevant reconciliation information.

What was the process the programmers had to go through?

  • Build the invoice eConnect call to get the invoice data from the Extrapayroll portal into GP.
  • Worked with internal accounting team to construct the chart of accounts and post routine.
  • Worked with TMC to setup the automated posting.
  • Configure and setup test environnment.
  • Run test transactions through.
  • Analyze the resulting G/L accounting entries.
  • Resolve anomalies that were identified with the G/L posted entries.
  • Baseline the system with G/L account starting positions.
  • Setup a weekly automated audit process. 
  • Work with TMC and Sessions staff to go live with a new fully integrated, automated E-Dynamics accounting solution.
Who was the team?

Who was the team?

Our Framework.net and SQL application developers worked closely with GP dynamics vendor TMC (Technology Management Concepts), based in El Segundo, to build, test, and deploy this integrated payroll solution.

Business benefit: this .Net/eConnect/Dynamics GP solution saved over 80 hours of manual labor on a bi-weekly basis to synchronize accounting data across systems.

Learn more about the custom .Net payroll solution we created for Sessions Payroll Management Inc.

Framework Solutions Custom Software Developer Los Angeles