I'm looking for options pull the dataset to Power BI. I explored the GeneralLedgerAccountEntries entity but I'm missing ProjectId and ActivityNumber in it.
Can someone please guide me in achieving the same dataset as shown in the AccountSourceExplorer?
Thanks in advance
Thank you Sukrut Parab for responding!
Where can I find class (AccountingSourceExplorerProcessor) through reverse engineering on visualstudio or anywhere else?
And unfortunately I didn't the tables (Projtable, ProjTransPosting and the Subledger) you have mentioned. Attached screenshots for the same. But we do have the GeneralJournalEntry table.
Please let me know if I'm missing anything.
Thanks in advance.
Hi Ajay ,
You should be able to look at class AccountingSourceExplorerProcessor and identify tables used for populating this form.
For your project specific question, all projects are stored in Projtable and posted transaction's against those projects in ProjTransPosting table which might be joined to subledger using SubledgerVoucher field from GeneralJournalEntry table.
Okay @André. Since I'm new to this Dynamic 365 ecosystem, is there any blog or a tutorial that will help me doing the reverse engineering the data provider?
Also to do that don't we need to have the account source explorer schema exposed in the data provider? Because I don't see that in the data provider. I only see plain data entities in the data provider.
Hi Ajay,
I don't know which exact tables are used in the background by head. It is possible to reverse engineer the data provider classes to check how the information is being compiled together for the report.
Thank you @André for responding. When you say all relevant tables, is there any way I can get the details of all entities that AccountSourceExplorer is using? Because I'm able find all the details except the ProjectID and ActivityNumber for individual transactions only.
If you can guide me in that specific direction or direct me to identify all the entities involved in it, that would be really helpful at this point.
Hi Ajay,
The accounting source explorer is compiled by x++ logic which fills a temporary table. You can export the details from all relevant tables to e.g. Data Lake and use Synapse or other tools to create the view you need or prepare the data in a particular way and then export it to be directly consumed by Power BI.
Share
Report
5
All responses (
Answers (