Greetings!
I'm assisting with the creation of reports in Power BI for a D365 F&O client.
Basically, I need this information for posted transactions:
GL Account Number
GL Account Description
Posting Date (LedgerJournalTable.PostedDateTime)
Debit Amount (LedgerJournalTrans.amountcurdebit)
Credit Amount (LedgerJournalTrans.amountcurcredit)
Journal Name (LedgerJournalTable.journalname)
Transaction Description (LedgerJournalTable.name)
Journal Entry Number (LedgerJournalTable.journalnum)
I believe I need, at least, these tables:
LedgerJournalName -- Contains the list of journal names, like JE, AP, etc. and their descriptions.
LedgerJournalTable -- Contains the header information, like journalname, journalnum, name, posteddatetime for a transaction.
LedgerJournalTrans -- Contains the line item transactions. Information found is amountcurdebit, amountcurcredit.
What I cannot find is the source of the account number and description. There is a column in LedgerJournalTrans called LedgerDimension. What table would have the account number used for a transaction and the description?
If there are different tables to use, please let me know.
I'm only looking for posted transactions.
Here's an example:
| GL Account Number |
GL Account Description |
Posting Date |
Debit Amount |
Credit Amount |
Journal Name |
Transaction Description |
Journal Entry Number |
| 2100-20-2 |
Trade Accounts Payable |
12/16/2024 |
|
100 |
JE |
Month-end accrual |
LBJ48482 |
| 5200-40-3 |
Misc Expenses |
12/16/2024 |
100 |
|
JE |
Month-end accrual |
LBJ48482 |
Thank you
