RedCloud Consulting
  • WHAT WE DO
  • WHO WE ARE
    • About Us
    • MEET THE TEAM
  • CAREERS
  • COMMUNITY
  • HIGHLIGHTS
    • Latest News
    • CASE STUDIES
  • CONTACT

Case Study 

Picture

At a Glance

An enterprise tech company wanted a modern digital, secure business process for managing payment terms for all global subsidiaries and sellers. 
​
RedCloud consultants worked closely with the client to develop a custom solution that streamlined their submission process, accommodated local labor laws, provided (near) real-time tracking for 200+ payment terms, and ultimately saved them hundreds of hours of tedious labor. ​

Challenge

Before each fiscal year, a RedCloud client managing payment matters on behalf of 100+ global subsidiaries must collect terms documentation for thousands of sellers. Each subsidiary must accept the payment terms or customize them through an exception process, which involved countless emails and executed documents.

At the project outset, this process was managed by one person, and manually tracked in an Excel workbook. It took hundreds of hours to complete, and the margin for error was high without the ability to log/audit the process. This was costing the company hundreds of hours in labor each year and left it prone to legal/financial issues. 

Solution

After meeting with key stakeholders to discuss technical and business requirements for a customized system, we developed a business application utilizing all workloads of the Microsoft Power Platform to transform the entire payment terms submission process.

This new “Power Platform” streamlined terms submissions and exception requests, automated repetitive tasks, and eliminated the need for countless email and document exchanges.

All edits made to requests are tracked in audit and change history logs, and every email is saved and logged in a secure database. Overall, the new payment terms submission process is significantly more efficient and has reduced the company’s legal/financial risks.   
We needed this platform to streamline the process as simple as possible, so it’s easier to manage/refresh.

We wanted automated decision documentation, and needed to
 make sure important elements are secure and that it was designed to have access by geo."

-- Client Representative

What We Did

  • Interviewed stakeholders running the payment term process to develop business requirements 
  • Established technical requirements
  • Designed and built a modern business solution utilizing all workloads of the Microsoft Power Platform
  • Customized the app with quick adjustments to best fit evolving business needs and requirements
  • Ran QA and UAT tests
  • Implemented the Power Platform, delivering a complete solution

Tools Used:

Picture

​Eliminated tedious manual reporting process of 6 workstreams into one cohesive live Power BI dashboard. 
​

Picture

​Replaced an email and Excel based task management process with a customized SharePoint form and automated email notifications. 
​

Picture

​Improved data security by e
nabling row-level-security for SharePoint lists and document libraries using PowerAutomate. Sent daily batched emailer reminders for tasks managed in Microsoft Planner.  

Picture

​Reduced handling time by 50% by transforming an email managed invoice process into a custom PowerApp, connected to the company’s master data source to integrate critical vendor details. 

Automated a three-party approval process with a custom PowerApp and PowerAutomate Approvals for national and international contracts. 

Results

99%+ of localized business rules document requests were complete within the two-week deadline. 115 payment terms were customized in-tool; 102 non-standard exceptions accommodated in-tool. The time to submit and process each payment term was reduced by an estimated 75% in comparison to the previously tedious, time-consuming submission process
11000 NE 33rd PL, Suite 100, Bellevue, WA 98004                 |         425-305-4121​        |         info@redcloudconsulting.com
©2020 RedCloud Consulting, Inc.  |   All Rights Reserved.  |  Privacy Policy  |  Terms of Use 
  • WHAT WE DO
  • WHO WE ARE
    • About Us
    • MEET THE TEAM
  • CAREERS
  • COMMUNITY
  • HIGHLIGHTS
    • Latest News
    • CASE STUDIES
  • CONTACT