web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Ways to extract Main A...
Small and medium business | Business Central, N...
Suggested Answer

Ways to extract Main Accounting Book

(0) ShareShare
ReportReport
Posted on by JMartin 160

Morning mates,

I'm trying to extract the Main Accounting Book on SaaS Business Central.

We have the report but the limit are 1 million registers. We hace more movements and we can't "pdf" it.

Is there any other ways to take that information? Like web services or any other ways.

Thank you so much! :)

  • Community Member Profile Picture
    Community Member on at

    Hello,

    I am not an expert here but saw this article:

    community.powerbi.com/.../1160327

    Thanks,

    Steve

  • JMartin Profile Picture
    JMartin 160 on at

    Hello mate! :)

    I don't want to export a table, it's a report :(

    I can't create web services or connect to PBI or something like that. Main Accounting Book seems to be complicated.

    Anyway, thanks four you answer ^^

  • Suggested answer
    JAngle Profile Picture
    JAngle 159 on at

    Web services could be used in excel with a power query. Volume of data will impact the usage with web services - very slow, plus there are settings on row limits. 20,000 is the usual but I believe this can be configured.

    Have you considered scheduling the report you output into pdf but choosing excel instead?

    There is also this: docs.microsoft.com/.../finance-analyze-excel

    If your reporting needs a not being met you could look at a 3rd party solution. With large volumes data cubes are a good idea. Jet Analytics is one of the possible choices.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hello,

    Adding to what Josh replied... Sounds like you want to run a paper report/pdf and dump the accounting transactions. Based on the fact you over 1 million records you will hit a wall to create the report but look into what just sent as links. I would agree that a data cube might solve all this, with Jet Analytics or Power BI.

    Hope this helps.

    Thanks,

    Steve

  • JMartin Profile Picture
    JMartin 160 on at

    Thanks all for your answers

    Anyway, I don't know how to create data cubes. I know that we can export data through Excel or PBI or Jet. For that, I need the web service of Main Accounting Book on Navision or Business Central and I can't find it. It's not a table, It's not a page :(

    I just want to export a massive Main Accounting Book with over 1 million rows without split it 

    Any other ideas please? Thanks again you all !!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 715 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 452 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 371 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans