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

Analysis View

(4) Share

Report

Posted on by BBBCMAN

164

Hi All,

I am using Analysis View and got my data by month into refreshable pivot table using data connector. The following is the excel which bringing the net moment of the month correctly but I wanted to bring opening balance for the year so when we do report for Balance sheet it will be opening + net moment of the month and closing will be the figure for the balance sheet for the period. How to do them.

Categories:

Dynamics 365 Business Central

All responses (8)

Answers (0)

Gerardo Rentería Ga... 19,142 Most Valuable Professional on at

Like (2)

Report

Analysis View

Hi, good day
I hope this can help you, and give you some hints.

https://learn.microsoft.com/en-us/dynamics365/business-central/reports/report-4410?wt.mc_id=MVP_354389

Best Regards
Gerardo
Suggested answer

Khushbu Rajvi. 16,382 Super User 2025 Season 1 on at

Like (2)

Report

Analysis View

If this helps: https://learn.microsoft.com/en-us/dynamics365/business-central/reports/report-4405
BBBCMAN 164 on at

Like (2)

Report

Analysis View

Thanks Zhu,

Can you please confirm on excel layout how to get opening balance and closing balance so that I can get balance sheet in excel which can be refreshable.

Thanks
Suggested answer

YUN ZHU 83,301 Super User 2025 Season 1 on at

Like (1)

Report

Analysis View

I think it will be much simpler to use Excel Layout. Analysis View is mainly used to view data within BC. If you need to use Excel, it is recommended to use Excel Layout.

Hope this helps.

Thanks.

ZHU
Suggested answer

Khushbu Rajvi. 16,382 Super User 2025 Season 1 on at

Like (2)

Report

Analysis View

I am not sure if this helps or not but still check if it provide you some hints: https://www.youtube.com/watch?v=Zu2MrHfBoQQ

https://learn.microsoft.com/en-us/dynamics365/business-central/reports/report-38

https://community.dynamics.com/forums/thread/details/?threadid=d1d82600-60d5-4c1b-9f61-73c1441f13cc
Suggested answer

Jainam M. Kothari 7,938 on at

Like (1)

Report

Analysis View

May this can help : https://learn.microsoft.com/en-us/dynamics365/business-central/year-prepare-close-statement

https://learn.microsoft.com/en-us/dynamics365/business-central/finance-reports
BBBCMAN 164 on at

Like (2)

Report

Analysis View

hi I just opened analysis view card then edit the same in excel and saved it so its connected to BC. Whenever I wanted it I can press refresh which will update the data. And I use the data to build my pivot table in excel.
Inge M. Bruvik 1,025 Moderator on at

Like (1)

Report

Analysis View

What data connector are you using?

Are you pulling the data from an API?