To retrieve customer transactions including financial dimensions in Dynamics 365 F&O, you can use the following steps:
OData Entity: Look for the OData entity that contains customer transactions and financial dimensions data. The entity may not be directly related to LedgerJournalLines, as it primarily deals with GL transactions.
Explore Customer Transactions: Explore entities such as CustInvoiceJour, CustPackingSlipTrans, and other sales-related entities that capture customer transactions. These entities often contain customer-specific transactional data, including financial dimensions.
Data Integration: Consider using Power Query or Data Entities to integrate the relevant OData entities into your Power BI report, allowing you to access customer transactions along with associated financial dimensions.
André Arnaud de Cal... 291,391 Super User 2024 Season 2
Martin Dráb 230,445 Most Valuable Professional
nmaenpaa 101,156