Hi, I've extracted all the info from the following two tables into PowerBI, using the URL xxxxxxxxxxxxxx.operations.dynamics.com/data//data/LedgerJournalHeaders?cross-company=true etc:
- LedgerJournalHeaders
- LedgerJournalLines
And have reconciled an example journal back to the D365 journal entries screen ok.
However I can't work out the link to get from the Journal Voucher number to the Transaction ID and Category entry you can see on the Project tab within the General journal entry window in D365.
For example I have a journal where all entries go onto a project, so there is no way to see the GL code it hit, or deduce it from looking at these two tables alone. In this journal the lines are all project expenses , but within the LedgerJournalHeaders and LedgerJournalLines tables there are no obvious flags to say they are project expense and related category / transaction ID or anther obvious way to deduce this.
It feels like I am missing a key table or two here, any help would be much appreciated!
