Commission Management System For Consumer Services Company

Technology Used

NET, C#, ASPX Web Services, eConnect GP Integrator, Microsoft SQL Server and SSRS, Microsoft Great Plains

Customer Profile

A leading supplier of consumer centric value added services like turning the change into cash, conveniently at a self-serving kiosk. Retail clients are at the fore-front of their business focus. Does business in about 140 countries.

Customer Situation

  • Required system capable of executing complex business logic to determine the commission to be paid to vendors
  • Same system determines how much each of their client will have to pay for utilizing the services of the vendor
  • Needed unattended batch process capable of determining the receivables and payables for each month
  • Accounts receivables and payables needed to integrate with the GL of Microsoft Great Plains (customer’s back office ERP)

Congruent's Solution

  • Built custom .NET based windows application (called CMS) to import the monthly route tickets collected from their vendors and clients
  • CMS had the ability to batch process the available route tickets to determine the receivable and payables for each month
  • CMS created necessary invoices, payment vouchers, credit and debit memos
  • CMS created and posted those documents in the Microsoft Great Plains

Benefits

  • Custom solution effectively replaced the legacy JD Edwards System, which was not supporting the unique business scenarios
  • Route ticket import process eliminated monotonous, error prone manual data entry job
  • Unattended batch process for determining commission saved lot of manual intervention at various states of transactions resulting in staff being spared for more client focused activities
  • Reduction in wrong reporting of commission and payments
  • Ability to control business processes in a much better manner

Congruent's Key Challenges

  • Developing an intuitive user interface that requires very minimal training
  • Import module that has to deal with different forms of route ticket data
  • Integrating the financial documents with the back office ERP system

Know more about our Offshore Software Development Services