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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,113 Super User 2024 Season 2
Martin Dráb 229,918 Most Valuable Professional
nmaenpaa 101,156