Optimizing financial reporting and consolidation processes

Headquarters Rotterdam
Employees 2184
Turnover 473.0

Over time, the business model of Fagron changed and SAP BPC was not able to meet all business requirements anymore. They needed a partner to re-design the financial reporting and consolidation processes.

Fagron is global market leader in the market of pharmaceutical compounding and active in 32 countries in Europe, the Americas, the Middle East, Africa, Asia and the Pacific. Fagron products are sold to more than 200.000 customers in over 60 countries.

Over time, the business model of Fagron changed and SAP BPC was not able to meet all business requirements anymore. They needed a partner to re-design the financial reporting and financial consolidation processes. cpmview was selected as the consultancy and implementation partner, based upon a relationship that started several years ago after a successful proof of concept.

The resolution – functional benefits The SAP BPC re-design project had three main objectives:

  • The data model of SAP BPC should be aligned with the Fagron business model,
  • SAP BPC should be less customized and therefore more easy to maintain and finally,
  • SAP BPC should be integrated with Navision.

The data model of SAP BPC should be aligned with the Fagron business model Fagron aligned their business around several business segments; Fagron Specialty Pharma Services, Fagron Trademarks and Fagron Essentials. In order to ensure that all financial and management information is structured according to those business segments, the data model in SAP BPC needed to be re-designed. Based on the new model, Fagron is able to easily report their financial figures per business segment, as well as a consolidated income statement and balance sheet per business segment.

“DUE TO THE SIMPLIFICATION OF THE DATA MODEL WE WORK MORE EFFICIENT AND ARE ABLE TO INTERFACE WITH OUR STANDARD SOURCE SYSTEMS.”

SAP BPC should be integrated with Navision A flat file interface was created between Navision and SAP BPC to reduce the amount of manual input and to increase the efficiency of the financial close process.

SAP BPC should be less customized and therefore more easy to maintain. The previous SAP BPC environment consisted of 3 models, with each a different function. The data needed to be transferred between those models, which was very time consuming. The new BPC environment only consists of 1 consolidation model, which reduces the time needed to finalize the financial and management reports every month and more importantly, it ensures one version of the truth

“WITH HELP OF CPMVIEW WE NOW HAVE A SOLID REPORTING AND CONSOLIDATION SYSTEM WHICH IS ALIGNED WITH OUR STRATEGY.“