Downloading GL entries from Microsoft dynamics

(1) Share

Report

Posted on by Mshah12

Hello,

I am trying to download all GL entries from Microsoft dynamics 365 business central to excel. I am using power automate query

Can somebody please help me. Am I doing something wrong ? Is there any otherway ?

I have selected various API categories but none of them is exporting any data. Here are the AP categaries that is showing in sys

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (1)

JAngle 152 on at

Like (1)

Report
Copy link

Link copied!

Reportsfinance/beta is the best one to use. Here’s the documentation for it: https://learn.microsoft.com/en-us/dynamics365-release-plan/2022wave2/smb/dynamics365-business-central/excel-layouts--new-report-datasets-excel-reporting

Was this reply helpful? Yes No
Suggested answer

KasparsSemjonovs 4,817 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Have You tried Configuration packages? Depends how many entries there are in table, could be You have to filter by parts and then just copy them in one excel file.

Was this reply helpful? Yes No
Suggested answer

Gerardo Rentería Ga... 25,555 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

HI

Maybe this can help you

https://community.dynamics.com/forums/thread/details/?threadid=387fb46b-bcd1-4c7f-b41b-cfec4b1dacc2

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/api/dynamics_generalledgerentry_get

Best Regards

gerardo

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,165 Moderator on at

Like (0)

Report
Copy link

Link copied!

If it is not too much data you want to export you can use the easiest way and that is to go to the G/L Entry page and then chose Open in Excel.

I do not think that Power Automate is the best option to achieve what you want to do.

https://learn.microsoft.com/en-us/dynamics365/business-central/across-work-with-excel?source=docs&WT.mc_id=email&sharingId=DX-MVP-5005315

Another option I would consider is to create a report and use an excel layout to get the data to Excel.

Was this reply helpful? Yes No
Verified answer

YUN ZHU 99,090 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi, please try the standard API below.

More details: How to export data from Business Central to a csv file with Power Automate (No customization) – JSON to csv

https://yzhums.com/46871/

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Mshah12 8 on at

Like (0)

Report
Copy link

Link copied!

Hi @ZHU

This is exactly what I need. I have tried the steps. but I am not sure how to get ROWID ?

Thanks

Mohsin

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,090 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, if you are using the Find records (V3) action, there is no need to specify the row id. If you are referring to the Row ID in Get record (V3), just select the id in the Find records (V3) step above.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No