Pallet Inventory and Selection System

Customer Profile

Sector: Transportation
Industry: Logistics

The company is a full service logistics provider. The company prides itself in lowering the cost of managing inventory for their clients while providing exceptional service, dependability, and innovation in logistics.

Business Situation

The company was using a Microsoft Access database to coordinate the pallet logistics for a major US corporation. Excel files that contained pallet activity was manually being copied into the database which became very time consuming and decreased productivity.

In addition, the client began to use a different pallet identification system. Since the database was not capable of handling the new system of pallet IDs, the company had to manually manage the pallet activity using the new IDs. As a result, some of the client’s pallets were processed one way and other pallets were processed a different way. This resulted in inefficiencies in client management and reporting.

Pallets get moved to different locations throughout their lifetime. The database did not track the pallet movement history which would be beneficial for tracking pallet lifecycle activity.

Solution

Automating the Import of Pallet Activity

Enhanced functionality was developed to import different types of pallet activity data. Users can now browse and select an Excel file and have the database automatically import the data. This saves the company a considerable amount of time.

Handling the New Pallet ID System

The database was updated to handle the new pallet ID system. All forms, reports, and code were analyzed and several updates to the database logic were made. The automation of processing the new pallet IDs saves the company hours of manual processing and guarantees the accuracy of the pallet information.

Tracking Pallet History

The database was updated to track pallet history. Whenever a pallet is moved, its previous location is now recorded. This enables the company to run a report on a specific pallet and review its lifecycle of location activity. The solution provided by Access Programmers will allow the company to easily analyze its operations and identify areas for improvement.

Contact Us

Please wait...

  • Judicial Attorney Services Inc.

    You continue to do a job well done with the design, updating and maintenance of our company's program. Work is performed in a timely and professional manner.

    - President

  • A Trucking and Warehousing Company

    Their ability to understand our industry from the ground up - just like one of my coworkers would - is their key differentiator.

    - Customer Service Manager

  • A Services Company

    I needed to believe that Access Programmers could help my company. Their team understood my hesitation and took the time to really understand my business needs.

    - Regional Sales & Operations

  • A Non-Profit Advocacy Firm

    Access Programmers has completed several projects for us - all of which we've been extremely satisfied with. The staff is very knowledgeable, accessible, professional and easy to work with.

    - Information Technology Manager