Answered

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:

Administration and permissions

All responses (7)

Answers (1)

Suggested answer

YUN ZHU 68,536 Super User 2024 Season 2 on at

Like (0)

Report

Downloading GL entries from Microsoft dynamics

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
Mshah12 8 on at

Like (0)

Report

Downloading GL entries from Microsoft dynamics

Hi @ZHU

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

Thanks

Mohsin
Verified answer

YUN ZHU 68,536 Super User 2024 Season 2 on at

Like (1)

Report

Downloading GL entries from Microsoft dynamics

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
Suggested answer

Inge M. Bruvik 32,744 Moderator on at

Like (0)

Report

Downloading GL entries from Microsoft dynamics

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.
Suggested answer

gdrenteria 8,744 Most Valuable Professional on at

Like (0)

Report

Downloading GL entries from Microsoft dynamics

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
Suggested answer

KasparsSemjonovs 3,660 Super User 2024 Season 2 on at

Like (1)

Report

Downloading GL entries from Microsoft dynamics

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.
JAngle 33,141 on at

Like (1)

Report

Downloading GL entries from Microsoft dynamics

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