Small and medium business | Business Central, N...

Finance Reports

(0) Share

Report

Posted on by BBBCMAN

457

Hi All,

We used to have all our financial report in MR while using Dynamics GP, since we migrated to BC now we are using financial reporting within BC. The problem we are facing is in MR when we drill down the each row which is using account category it will bring in all the GL which is making up the total (we used 3 segments in GP). In BC we have account just one and remaining 2 segment of GP we added them as dimensions and we use them for posting all transactions. The issue what are having is when we drill down the rows of financial report in BC it will just show the GL account but wouldnt have the dimension along with it. Users would like to view the details same as before, any of you faced this situation please let me know how did you deal the same.

Thanks,

babu

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (0)

Sort by

BBBCMAN 457 on at

Like
a
(0)

Report
Copy link

Link copied!

Following is the screenshot of how the drill down happened in MR and how its coming in BC.

Was this reply helpful? Yes No
Suggested answer

Teagen Boll 3,368 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Babu,

If you check your General Ledger Setup page do you see the Segment dimension set as Global dimension 1 or 2.

And in the financial reports when you drill down it will show you a summarized view but not all the detail. Here is an example.

1. In my financial report I have the aggregate line for current liabilities:

2. After clicking on that I get a summarized view with some detail:

3. If you click on any of those numbers you should get the true detail where you can see my department and division dimensions (general ledger entries):

Best,

Teagen Boll, CPA

Work: Catapult ERP

Social: LinkedIn

Was this reply helpful? Yes No
BBBCMAN 457 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Teagen,

Yes thats fine and I will be able to see each transactions if I go find entries but what I am looking for is break of GL with dimensions with it summarised based on dimensions posted into.

Thanks,

babu

Was this reply helpful? Yes No