Forum Discussion
Business Central: key fields GL Entry not found (creator, modifier)
Dear,
I'm currently working on a Power BI report to map out the GL entries.
You can look at it from a kind of audit stand point: which entries were made, by whom, for which amount etc.
I can not seem to find the creator, creation date and modifier of the GL booking.
I've tried the tables "G_LEntries" (webservices) and "generalLedgerEntries" via standard API v2.0, but this does not contain these columns. This seems so strange to me, as all other data sources I've connected with do include this.
I can not find a "changeLogEntries" table, as other articles (and copilot) suggest.
Can anyone point me in the right direction?
Thank you!
Hi, MCLHRSM
First, you can check if you have permission to access this table. Then you can follow the documentation below to see which page contains the item you need:
Power BI FAQ - Business Central | Microsoft Learn
To enable Change Log in Microsoft Dynamics 365 Business Central:
Auditing changes - Business Central | Microsoft Learn
Setting up the Change Log - Microsoft Dynamics 365 Business Central - YouTube
After you enable it, reload it in Power BI and check if the changeLogEntries exists. Here is a blog with the complete process for reference:
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi, MCLHRSM
First, you can check if you have permission to access this table. Then you can follow the documentation below to see which page contains the item you need:
Power BI FAQ - Business Central | Microsoft Learn
To enable Change Log in Microsoft Dynamics 365 Business Central:
Auditing changes - Business Central | Microsoft Learn
Setting up the Change Log - Microsoft Dynamics 365 Business Central - YouTube
After you enable it, reload it in Power BI and check if the changeLogEntries exists. Here is a blog with the complete process for reference:
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, MCLHRSM
Have you already solved the current problem? If yes, you can share your solution here and then mark it as a solution. This will help others in the community when they encounter similar problems.
Your sharing will contribute to the development of the community with us! Thank you again!Best Regards
Jianpeng Li