CoorsTek had many customers who gave them purchase orders for the year, so, in addition to the large volume, many of the purchase orders could be 500 lines or more. They were looking for a solution that would give them more control and accuracy with data entry into QAD and allow them to update changing due dates easily. They also wanted to find a more streamlined way to link purchase orders with sales orders and promote better communication between facilities and departments. Bob Sendek and Cindy Kong from CoorsTek joined us for this webinar to demonstrate how they improved their Sales Order process with 32 Soft’s Multiple SO Data Loader. Find out how they …
decreased PO/SO coordination time by 60%
decreased yearly SO data entry time from 40 hours to 6 hours
No. We use a Progress redirection process. The data from the Data Loader excel template goes through a complex validation process before it loads any data to QAD. If an error is found in the data, cells with errors are instantly highlighted, so the user can quickly identify and correct any problems and load the data again. It is all done in real time. You can find out more about how our Data Loaders work here.
Are these discrete or scheduled orders?
These are all discrete sales orders and purchase orders.
How are sales orders sent to CoorsTek from customers?
Most are on paper purchase orders.
Are the paper sales orders keyed into the Excel spreadsheet manually?
In the case of CoorsTek, it is a combination of key-in and copy/paste/modify. However, if you do receive Excel, CSV, or other files from your customers, there is an open file button in the Loader that will allow the data to be imported.
by Cathy Helmers | on 13th October 2022 | in Blog, Webinars