WebApp: Dynamic Online Sales Reporting for Reps

Overview:

To build an online reporting portal for a legacy ERP system that was only accessible over remote desktop, providing autonomous reporting capabilities.

The ERP system lacked API functionality but had a proprietary ODBC driver running on a specific operating system. Multiple businesses using the ERP system each had separate databases, and the umbrella company needed data access to compile reports and financial statements.

Solution by ACKRO:

ACKRO designed and built a solution leveraging data connections for each company and developed a web application that compiled data at runtime, producing live and current reports.

The WebApp featured:

  • Role-based Permissions: From the Head Office Financial Controller (access to all companies’ data) to Sales Managers (access to their sales reps’ data) to individual sales reps (access to their own sales data).
  • Immediate Reporting: Authorized users could see real-time results instead of waiting for weekly reports.

Impact:

This solution not only achieved its goals but also unlocked further opportunities for automated reporting capabilities with the legacy ERP system.

Problems:

  • Legacy ERP system with a single access point to the database.
  • Each company had its own ERP system version and separate database.
  • Time taken for manual report generation by Data Maintenance Officers using Excel/Access every week.
  • Risk of data integrity issues due to manual handling of the data.

Solutions:

  • Web Server & Application: Built a web server and web application to act as a portal and gateway to the data.
  • Automated Routines: Compiled data from multiple systems, ran integrity checks, and performed clean-up tasks.
  • Role-based Access: Assigned roles to users with varying access levels (from full access to company/user-specific access).
  • Live & Dynamic Reporting: Utilized PHP/JavaScript for up-to-the-second live reporting.
  • Automated Email Reports & Alerts: Generated reports based on specific criteria, data integrity or sales figures.
  • Sales Dashboard: Provided an online dashboard for sales managers to oversee their sales reps.
  • Resource Optimization: Freed up staff resources previously dedicated to manual report generation in Excel.

Contact US

Fill out the form below, and we will be in touch shortly.
Contact Information
What can we do to help:

Thank you for viewing your sample site!

We take the stress out of websites for you and offer quick, easy web design so you can get your business online as quick as possible.  Start growing and get exposure now!

Below is what you get when you sign up to our site:

  • Unlimited website content updates*
  • Professional email address
  • Online Contact forms
  • Domain name
  • Web Server Hosting
  • Full site maintenance, updates, backups and restore

*Content and images need to be supplied

We also offer additional growth packages to Jet your business to the sky!

  • SEO keyword reviews ($2500 per month)
  • Marketing Content Generation
  • Online Ecommerce Store
  • Online Booking & Appointment System
  • Online Payment System (with Paypal/Stripe/Square)
  • And MORE!

Let us know below if you would like your site started