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 133 on at

Like (1)

Report

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,766 Super User 2025 Season 2 on at

Like (1)

Report

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,225 Most Valuable Professional on at

Like (0)

Report

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,111 Moderator on at

Like (0)

Report

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 95,638 Super User 2025 Season 2 on at

Like (1)

Report

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

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 95,638 Super User 2025 Season 2 on at

Like (0)

Report

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