GoCanvas is a mobile application that can be integrated into Viewpoint to allow the client to collect GPS information to ensure haul cards are properly submitted. Our client realized that the information from GoCanvas was being improperly integrated into Vista by Viewpoint, resulting in a weekly Excel report that was over 1000 lines long. GoCanvas was supposed to make accounting easier, but instead led to an employee spending four days every week reducing a massive file into a usable format.
Our CEO and founder, Jon Olsen, sat down with the accountant tasked with manipulating the document. Within two minutes, he understood that it was a simple data transformation issue. The original process was approximately 20-30 steps that the accountant had to undertake manually each week. Olsen Consulting created a data transformation file that ingested the un-formatted sheet from the particular data source (in this case, GoCanvas) and transformed it into an up loadable format for their ERP. From then on, all our client had to do was export the file from the GoCanvas app, save it in a particular folder, change the data source and refresh the file.
Olsen Consulting employs expert consultants to assist you with all of your Vista by Viewpoint implementation, customization, and reporting needs. Don't see something on the list? Book a free consultation and see how Olsen Consulting can help your business.