- An email and phone call from one of our representatives.
- A time & cost estimation.
- A follow up conversation for your feedback and questions.
Customer is a food production company offering ground beef purveyor. Customer is one of the main suppliers of ground beef to the popular chains. It sells more than 80 million pounds of ground beef with revenue approaching $250 million. Customer company has been one of the biggest suppliers for nearly 40 years delivering high quality ground beef to Burger fanatics across US.
Customer was looking to embed a new Transport Management System (TMS) into their IT systems. With this, there was a need to integrate the cloud based TMS with their on-premises ERP System. The ERP system is a legacy desktop application with very minimum scope for integration with currently available technologies or API’s. Also, there was a limitation to directly connect with the DB/backend system of the ERP. Therefore, for integration of Orders, Shipment writebacks and Invoice processes, there was a lot of manual effort that was being steered by the customer. They were also not able to write data to their backend system, therefore, a lot of manual effort was involved.
After conducting a detailed assessment of the client’s requirements, VNB recommended ERP and TMS Integration using Microsoft Power Automate and Microsoft Power Automate Desktop/Win Automation. The application integration interfaces were developed using Power Automate Flow, UI Flows and Power Automate Desktop/Win Automation processes. Using Robotic Process Automation (RPA) OOB from Microsoft Power Automate, the interfaces would connect to the TMS APIs. For writeback messages from TMS to ERP, the solution was designed to hold this data in a staging area. Power Automate API flows were exposed to TMS to put data into the staging DB. Once the data was staged, Power Automate UI flows and Win Automation processes were used to automate entry of shipment as PO and Invoices into the ERP system and also update Order with the TMS unique order number and details for reporting purposes. The solution provided has the following benefits - • Low code Development: Leverage a low-code experience with a step-by-step record and play back experience • Automation: Automate in a single platform across apps and services that don’t have APIs • Seamless Integration: Seamlessly integrate UI automation with API-based automation by combining UI flows with regular flows • Optimize Application Security Power Automate: Customize, build, and manage UI flows scripts in a secure cloud environment • Improved business processes: By automating these processes, customer can focus their efforts on analyzing information, establishing goals and supporting their teams • Accuracy & Quality: RPA offers improved services to processes that have a high probability of human error, thereby increasing accuracy. RPA optimizes capabilities that multiply the organizational capacity • Faster: As bots are handling the execution here, a larger amount of work can be done in a relatively much shorter period and achieve faster delivery
VNB assisted a logistics customer to automate work order management process leveraging Microsoft PowerApps, Dataverse and Power AutomateVIEW DETAILS
VNB assisted a Non Profit Association supporting veterinarians publish PowerBI data portal for its members using Power PagesVIEW DETAILS