Case Study for the Pallet Production System Using SQL Server 2000 Database

Send a Message


 

 

 


 
  

Need help with Microsoft SQL Server? Ask our Experts, or simply Email your query.

About Sql Server Programmers

Our clients can be found both locally in the Chicagoland area and throughout the country. We have over 16 years of experience and are extremely proud of our track record of successfully assisting hundreds of our clients to improve their productivity while focusing on cost.

Microsoft Certified Partner

  

Project Profile for the Pallet Production System

Customer Profile

Sector: Freight Transportation
Industry: Pallets

The company is a manufacturer and distributor of quality wood pallets and containers in the Midwest. The company is strongly committed to providing quality products and superior service at a competitive price.

Business Situation

The company uses an internally developed system to handle several areas of their business. The system tracks customers, sales, jobs, and handles all the accounting. An IT service company was needed to step in and build additional functionality to the system along with fix existing issues.

Solution

SQL Server Programmers stepped in and fixed several known existing issues with the system. Issues remedied included inaccurate pricing of jobs and various reporting issues.

Generating Bank File

Additional functionality was developed to create a file to send to the company’s bank. The file contains a check register of customer payments.

Tracking Inventory

A new module was built onto the system to track and report on the company’s materials in inventory. The inventory module was built onto the existing system to continue to keep the most of the operations in a centralized system.

The updated system enables the company to operate more efficiently and effectively. Employees are able to spend more energy serving their customers and less time on mundane time consuming tasks which are now automated.

  

Executive Summary

Company

The pallet company based in the western suburbs of Chicago has been in business for over 30 years.

Solution Description

SQL Server Programmers developed new functionality to the system along with fixing existing issues.

Software and Services

  • Microsoft Access 2003
  • SQL Server 2000
  • Microsoft Windows XP

"Just to let you know, I am very happy with your services"

Jane
Accounting Controller