Consolidating Disparate Sources of Financial Data with FRX
Just bought some distressed companies? Need to consolidate their financial data? How in the heck are you going to consolidate reporting when one company keeps their books on Excel and another in Dynamics AX, and two more use Dynamics GP? On top of that, they all have different chart of accounts structures!
The answer: Microsoft FRx. Naysayers will talk about how old Microsoft FRx is, and how modern reporting tools are so much better. However, to date, nobody else - including Management Reporter, Microsoft’s supposed successor to FRx - have managed to make this scenario doable for an end-user.
The secret is in Microsoft FRx’s unique tree functionality. Anybody can roll up apples to apples. If you have five companies in Dynamics GP, and they all have the same account numbers, it’s a slam dunk. But when you are rolling up apples to oranges, you want to use FRx’s row linking functionality. By allowing units of the tree to actually report not only directly on accounting data sources but also on data from spreadsheets and other units of the tree that use different row formats, Microsoft FRx won’t even break a sweat when 1100-000-123 is cash in one company and 115806-86722-555-444 in another.
Look at this visual representation of how Microsoft FRx rolls up financial data from three separate companies:
Continue reading "Consolidating Disparate Sources of Financial Data with FRX"


