Tuplin improve efficiency

Having successfully implemented "Boxes" Tuplin recognised that the automatic calculation of wood cuts for packing crates was just the beginning of the efficiencies that they could gain because of their partnership with Laser Byte.

In the first instance, they realised that it would be better that frequently ordered cases, (as used, for instance by aircraft simulator manufacturers CAE and Thales), would be more efficiently dealt with if they were stored as customer parts. That would mean that, if the Tuplin Part number related to the customer's part number, then it would be easier to pull in the customer part and base the job on that part. This would speed up creating jobs and also reduce errors where the wrong case was made.

Secondly, Tuplin, realised that they received orders from some companies for a batch of items at the same time. Why not read these in automatically from either the Sage Sales Order system or from spreadsheets created by the customers? So that is what we did!

The Problem:

Every time a customer sent through an order, often for a part they had ordered before, someone would have to re-create that part within the system. They would have to cross-check dimensions and double check that everything was accurate and was what the customer had ordered. This process was fraught with potential errors. Wouldn't it be a good idea if frequently ordered items were available from a customer parts file?

Often a customer would order many items within the same order. These would be entered onto their Sage Sales Order system, and then someone would manually enter each line of the order manually into the system. Sometimes it would be an Excel spreadsheet. Why not read in the customer orders and create the jobs automatically?

The Solution :

Ask Laser Byte for a solution. For the first problem, Laser Byte created a Customer Parts table which was similar to a job, but had a unique Customer Part Code and was associated with a particular customer.

We then wrote a series of screens and functions that allowed them to create a job in the normal way and then turn that into a Customer Part. We also gave them the ability to create Customer Parts afresh. 

Then, when they add a job, they just look up the customer part number from the customer's order, and the system pulls all those details into the job automatically. No errors!

With the second problem, Laser Byte wrote a series on import programs. These would allow the user to import either CSV files created by Sage or manually, and also Excel spreadsheets created by the customer themselves to a set template. Before they press the "Go" button the system does a test import and shows the user the details of the orders that the system will create. The system also does various pre-import cross-checks to ensure that the files have been formatted correctly for import. This minimises errors, so they just don't exist.

Site powered by WEBDEV from PC SOFT. Programmed by Laser Byte Ltd. Copyright Laser Byte Ltd 2020.