Wholesale Distribution Reporting System

Wholesale distribution reporting system is using .NET desktop technologies to provide aid in sale/purchase, accounting, and inventory domain. It is a comprehensive business solution using an ERP solution for quicker and easier inquiries to the financial data.

Technology Used:
  • .NET C# 2005
  • Progress 9.1D
  • Progress Proxy Generator Tool
  • SQL Server
  • ZED Graph

Key Challenges

The client firm, a wholesale distribution software consulting company based in LA, California, has provided complete business solutions to its customers using an ERP solution (based on the Progress 9.1D database). Their sales/purchase reporting, accounting, and inventory reporting application was too small and required redesign to make it easier and faster to respond to financial data from multiple companies in a group, with better visual reporting and reporting capabilities to cater usability requirements of the potential customers.

ValueCoders took this challenge and designed a robust, modular, scalable, and configurable software, a desktop application, to meet the end user or customer needs.

When they hired ValueCoders, we had to address to the following tasks:

  • A comprehensive business solution was required to manage financial data for multiple companies in a group
  • Client-side should be focussing on various challenges and demands faced by distribution industry
  • A distribution reporting system with better visual &  text reporting features

While developing, we faced various challenges including the following ones:

  • Gathered all risks and impact from the system
  • To display huge datasets in real-time from a Progress database
  • Developing a single system to tackle all these risks and problem

Our developers at ValueCoders had overcome these challenges with their innovative ideas and technical expertise

Our Solutions

The existing application restricted the data view for a single company and an individual account. An inquiry function was required to access sales, finance, accounting, cash and other relevant details for multiple companies and all cash accounts based on daily, weekly, quarterly, month to date, year to date, one year ago.

So, there was a need to develop an efficient solution in order to meet the client’s requirements. As a result, a .NET desktop application with new query screens, which show data for all cash, sales, purchases and inventory values ​​along with the accounting screen is developed.

The application alloweseeingee and manage up to 9 years of data, and each module offers views of data from previous and current years, which facilitates the comparative analysis. It provides well-defined visual aids, such as bar charts and calibration graphs, simpler data structuring, data export to Excel, scheduled reports.

It comes with following features:

  • Configurable Gauge Graphs
  • Customizable Toolbar
  • Windowed Data Browsers
  • Preferences/User Settings

This application first set up connectivity with Progress to first collect data to a SQL server database and thus help in easily modifying & displaying details on Dashboard system in close to real-time response time, keeping the offset within an acceptable range.

Work speaks louder than words

Request a free consultation and get a no obligation quote for your project within 8 Business hours.