Jitterbit

SPP Pumps had a completely manual processes to manage and schedule more than 60 field service calls a day for their 30+ field engineers. The invoice generation process took up to 14 days to complete, typically. It involved paper forms; signed and then faxed back to the office. Administrative staff had to manually enter work order information into SAP before an invoice could be generated and sent to the customer for payment. There was no guarantee that what was faxed and entered was accurate or complete.

SPP Pumps had a completely manual process to manage and schedule more than 60 field service calls a day for their 30 field engineers. The mechanism of generating an invoice from the field could take up to 14 days to complete. Service engineers filled out paper forms, signed them, and then faxed the forms back to the head office for each service call. Their administrative staff then had to manually enter work order information into SAP before an invoice could be generated. This manual system of filling out paper forms was time-consuming, resulted in many errors, and created cash flow problems for the company. This paper base system also siloed service engineers from the sales teams and the supply chain hindering communication. Often service engineers would show up to sites without the correct parts or leave without being able to identify to the sales team potential business at the customer sites.

The State of Iowa's Department of Administrative Services (DAS) was tasked with maintaining a database of debtors within a vendor-offset program. This required the integration of data from both inside and outside the state's network. In 2007, legislation was passed allowing county and city agencies to add their debtors to the database, leveraging the state's data processing power to secure payments of locally oriented debts. This new program required the database to pull information from dozens of different file types. The challenge was that thousands of files from local agencies were inundating the database with incomplete files and mismatched data.