Wednesday, September 9, 2009

Dimension wise Profit & Loss and Balance sheet............ in FRX or AX?

During the implementation of Microsoft Dynamics AX 2009, there is a usual concern about creating a Balance sheet and P&L. either FRX is the best solutions or default AX Financial reports using row structure?

I believe this depends on a particular scenario. There is no doubt in the functionality of FRX, but AX default financial statements creation is a plus benefit. Especially in the following scenario.

SCENERIO:
If there is only one company configured in AX with around 100 divisions in dimensions, and you want to create a profit & Loss standard format for all the divisions. In FRX. You would need to create respective row formats and reporting tree or report catalogues. I mean there will be much effort required to create that.
If we create one P&L format in Default AX financial statements, we will just use dimension focus to take report for all the divisions.

It will definitely save time and give quickly results and will also increase customers trust on the application. This happened with me, might happen with you!

I hope above information is helpful.

Regards,
Ali Jawad

2 comments:

  1. So how do you make sure that the balance sheet balances by dimension? Or is that not an issue? :)

    ReplyDelete
  2. @Shirley,
    Well it depends on your design of capturing finacial data into the syste. If your design was made keeping in consideration above said requirement, definitely you can achieve this. :)

    ReplyDelete