Finance Reporter - auto populate main accounts based on main account categories

(0) Share

Report

Posted on by Scott_Bumphrey

Hi There,

I am rather new to D365 and the Finance Reporter product within D365FO (googling taught) and am trying to understand if something is possible or not. I have a report that is currently set to display at a Main Account Category level using the Financial Dimension Link in the row definition, however I was wondering if that it was possible to get the report to automatically create all of the lines based on the specified main account category? Preferably with a solution that may be possible for the columns too and other dimensions.

An example of this would be that I would stipulate the Main Account Category to be Staff Costs, which includes a number of Main Accounts. I would want the report to create a row for each of the main accounts that fall under the Staff Costs Category and not have to manually create a line for each one.

The reason I am after this is is for a couple of reasons:

The business is currently going through its migration to D365 and new accounts will likely be added as required, so potential for a lot of changes.
We have dimensions that have a lot of potential movements, such as a brand we are selling and the maintenance of this will be continuous.
There are lot of businesses in the wider group so if there is a solution we can use to not have to manually create each report for each business and their different dimension values it would be great.
There is a potential to use this for a consolidated reporting tool but not if we need to manually amend every report each time.

To me it feels like it should be possible as other (lesser) systems I have used in the past can do it with ease.

Thanks,

Scott

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Finance Reporter - auto populate main accounts based on main account categories

Hello Scott,

The tool that can automatically adjust and include the accounts that make up your category is PowerBI.

Yet, this requires a different design and setup.

What might help are the standard GL trial balance, balance sheet and income statement examples that ship with the MS demo companies.

Have a look at them and then you might be able to design something similar yourself.

Best regards,

Ludwig

Was this reply helpful? Yes No
Scott_Bumphrey 10 on at

Like (0)

Report

RE: Finance Reporter - auto populate main accounts based on main account categories

@Sourav_Dev I am not looking for the drill down function, as mentioned it is more for being able to pre-set a report to show all accounts under a specified main account category at the front sheet level, not drilling down. The reason for this is that the reports are exported and part of management reports which are distributed to people who do not have access to D365FO.

@Ludwig_Reinhard Thanks for your response, it seems that you have confirmed my fear that the reports will require manual intervention to update for new/obsolete main accounts or dimensions, creating job for report maintenance.

To confirm the example as you requested, I have a cost report where I would like to provide a view at main account level, we have circa 150 main P&L accounts currently and are using the main account categories alongside. I was hoping that I could just stipulate the category and then all main accounts under that category are automatically populated to the front sheet, not through a drill down function (see below).

Main accounts is probably not the biggest part that will change in our business, there will be more under a other dimensionality but it is the easiest to show and the principle is the same.

Thanks,

Scott

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Finance Reporter - auto populate main accounts based on main account categories

Hi Scott and Sourav,

My understanding is different and I would say that the financial reporter cannot automatically create new financial reporting lines once a new account is added in F&O that has this category assigned.

I agree with Sourav that the drilldown from the top level report site will show you all of the accounts that belong to the category.

However, my understanding of this question is different because you want to see all of the accounts on the top level report site.

It would thus be great if Scott could provide a simplified example what is expected here exactly.

Many thanks,

Ludwig

Was this reply helpful? Yes No
SouravDam 11,730 on at

Like (0)

Report

RE: Finance Reporter - auto populate main accounts based on main account categories

Hi Scott_Bumphrey,

The key part of your query is this as you mentioned - "to create a row for each of the main accounts that fall under the Staff Costs Category and not have to manually create a line for each one".

Yes, this is possible and you only need to link "Staff costs" related main account category in the Row Definition.

Once the report is generated, you will find the staff costs related total value is showing in the report provided that you already have posted transaction records in the system. You can then click on that total value which will appear as a "Link" type. It will then drill down to the posted entry level. And once it drills down, you will be able to see multiple staff costs related main accounts and their posted values.

But in order to get the staff costs related total value as a type of "Link", you have to do this setup in the "Report Definition" first.

Just open the Report Definition, and select Financial & Account option in 'Detail level' section. Save it and then generate the report.

Financial - It will only show values in the report but no drill down option will be available.

Financial & Account - It will help you to drill down insight of the value shows in the report.

Financial, Account, & Transaction - It will give you more layered drill down option even to the posted transactional level. Which means, once you drill down at every account wise posted value level, you will further have the option to click on each and every individual main account value to see the posted transactions which is summed up to show the value in report for that main account.

The 3rd option above will work like this.

Staff costs = 1000.00
You click on 1000.00 and it drills down to next level where you will find staff costs related main accounts like 1001 and 1002. Each of these account have their own posted value.
Now you will have further option to click on those values which will also appear as a "Link". Below are the options you will get.

-- Drill to report transaction level
-- Open account transactions

If you click on Drill to report transaction level, you will be able to see the posted transaction detail in the report itself.

Else, click on Open account transactions. System will take you directly inside to the posted voucher transaction in system with that main account.

Kindly check and provide your feedback.

Regards,
Sourav

Was this reply helpful? Yes No