ERP vs. CPM: What CFOs Need to Know

Your ERP may be the financial system of record—but should it also be your planning system? Dominick Zappia, Partner at Admiral Consulting Group, sits down with Gurpreet Chaggar, Product Marketing Manager at Prophix, to explore why growing finance teams often outgrow ERP-only financial processes. They discuss the role of CPM and FP&A, reducing spreadsheet dependency, improving forecasting and financial close, connecting Business Central with Prophix, and why clean, governed data must come before AI.

 

Key Discussion Points

1. Your ERP isn't designed to do everything finance needs.
   ERP systems excel at recording transactions and showing what happened. As companies become more complex, budgeting, forecasting, scenario planning, and forward-looking analysis often require capabilities beyond the ERP itself.
2. Excel can be a warning sign that finance has outgrown its current architecture.
   When critical planning processes move into spreadsheets, organizations can face disconnected files, version-control problems, manual consolidation, and uncertainty about whether leadership is working from trusted numbers.
3. A new ERP alone may not solve the planning problem.
   For CFOs evaluating ERP modernization, one of the most important lessons is architectural: distinguish the system of record from the system of analysis, intelligence, and control. Prophix can complement an ERP such as Microsoft Dynamics 365 Business Central rather than forcing the ERP to handle every financial process.
4. Modern FP&A gives CFOs more powerful ways to model the future.
   Instead of exporting data into spreadsheets to answer every new "what if?" question, finance teams can use multi-scenario modeling to evaluate variables such as cash, headcount, investments, and other assumptions side by side.
5. Faster close creates capacity for higher-value finance work.
   Gurpreet says Prophix customers can potentially remove three to seven days from the close process. The broader opportunity is moving finance professionals away from data manipulation and toward analysis and decision support.
6. AI readiness starts with the data—not the AI tool.
   Adding AI on top of fragmented, ungoverned financial information doesn't fix the underlying problem. CFOs should first ask, "Is our data ready for AI?" Clean, governed, connected information creates the foundation for trustworthy AI-powered analysis.
7. ERP modernization is an opportunity to rethink the entire finance architecture.
   Prophix can bring information together from ERP, CRM, HRIS, flat files, and other source systems. That gives CFOs an opportunity to think beyond replacing their ERP and instead build a connected financial environment for reporting, planning, forecasting, analytics, and eventually AI.

Notable Quotes:

• • “An ERP is built more to be a transactional system of records. So it's showing what happened.”
• • On the cost of manual warehouse operations: “A lot of manual effort or processes from receiving to picking and then manually posting it later…”
• • “It's pretty much moving through that mess faster rather than giving you an answer that is correct and grounded in reality.”
• • “The greatest reason to have a CPM tool is to bring all of that data into one place.”
• • On eliminating tribal knowledge risk: “Now they’re doing everything from one system… it’s available to everybody to see in real time.”

Chapters

[00:00] Why Your ERP Can't Do Everything

[01:32] Why Finance Keeps Falling Back on Excel

[03:03] Automating Reporting, Dashboards & Financial Processes

[03:36] Why AI Can Accelerate Bad Financial Data

[04:44] How Prophix Is Bringing AI into Finance

[05:49] ERP vs. CPM: Understanding the Difference

[07:00] Business Central + Prophix

[08:40] Connecting Prophix with ERP Data

[09:24] The Business Case for Faster Financial Close

[11:05] Moving Beyond Basic Budgeting with Scenario Planning

[12:03] Bringing Enterprise Planning Power to the Mid-Market

[14:27] Why Most AI Strategies Should Start with Data

[15:43] What a Prophix Implementation Looks Like

[17:23] Connecting ERP, CRM, HR & Other Business Data

[19:21] The First Question CFOs Should Ask About AI

[20:41] How Long Does Prophix Take to Implement?

[22:22] Supporting Finance After Go-Live

[25:28] Self-Service Financial Reporting & Analytics

[26:37] Why Finance Leaders Don't Always Know They've Outgrown Their Tools

[29:33] Better Decisions Through Connected Financial Data

[32:16] Prophix Updates, Integrations & Platform Evolution

[34:37] Closing Thoughts

 

Why Watch This Episode

If your finance team is outgrowing spreadsheets, or you're evaluating a new ERP, this episode will help you understand what your ERP should do, what it shouldn't, and where modern FP&A fits. Learn how connected financial planning, forecasting, scenario modeling, and AI can help your team spend less time managing data and more time making confident business decisions.

 

Ready to get more intelligence from Business Central?

Discover how AI and modern financial planning can help you turn Business Central data into deeper insights, smarter forecasts, and more confident decisions.

 

Talk with Admiral Consulting Group about the next step in your finance transformation.

 

Schedule Your Free Consultation Today