Pomerol Partners Logo
let's talk

Automating ERP for Complex Pricing

Solutions for Challenging Frameworks

Want to create a pdf of this page content to print or email? Click on icon.

image_pdfDownload page as pdf

Streamlining with Smart Automation in the Automobile Industry

The client had started implementing a new ERP system for an existing business unit. The previous ERP system was run on an AS400. The new ERP system is cloud-based, allowing integration with APIs and a web based interface. The New ERP system could not calculate clients’ desired pricing model. The client’s pricing model is based on part classification, supplier price, and customer tier. Power Automate was used to interact with the web-based interface and complete required calculations.

Problem Statement

Complex Pricing Structure

The Client needed this solution before they could fully implement the ERP system. The client had a complex pricing structure involving multiple calculations and lookups. The pricing structure posed challenges inside of the ERP system due to the cost-based APIs. The client also wanted to be able to be notified of price decreases. This allowed us to ensure the maximum margins on reselling of components. This was a completely new process to be integrated into the new ERP system

Solution Overview

Using Power Automate

The Solution was achieved by using several solutions. The first part is using Power Automate Cloud to Automate Power Automate Desktop running on a server. Power Automate Cloud also provided email reporting on if the workflow is completed. The Power Automate Desktop flow uses outlook to provide reporting on pricing and BOMs missing materials.

Results and Impact

The client successfully integrated and added all the supplier parts. The bot calculated the catalog price for all 4 customer tiers and all 4 product tiers for approximately 3500 parts. The process also calculated BOM pricing for approximately 1,500 BOMs using the individual parts that make up the BOM.

Pomerol Partners automated a complex ERP pricing structure using Power Automate, enabling efficient calculations and reporting, which saved the client millions.

Related Case Studies

Transforming Pharmaceutical Sales with Data Visualization

Pomerol transformed the sales management of a global bio-pharmaceutical giant by implementing a data visualization platform with QlikView.

Category:

Data Analytics in Hospitality

Pomerol Partners transformed the hospitality industry by implementing advanced data analytics solutions for high-end game reserves and lodge industries. By integrating cleansed legacy data with accounting and hospitality management packages, they provided clients with actionable insights and automated reporting. This enabled clients to make informed marketing decisions, optimize their booking and revenue cycles, and significantly improve operational efficiency.

Category:

How Pomerol is Driving Agile Wins in Manufacturing

Pomerol Partners transformed a North American manufacturing client’s operations by implementing an agile BI reporting solution using SAP data. The comprehensive Procurement and Spend application, encompassing 14 million records over five years, enabled detailed analysis and proactive problem-solving. The introduction of the Plan for Every Part (PFEP) had an immediate impact, optimizing inventory management and improving supplier relationships.

Category:

Share the Post: