Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Need to find Odata that has customer trans including Financial dimensions, not just GL transactions

Posted on by
For Power BI report, trying to get the transactions for customer by account dimensions.  I cannot find it LedgerJournalLines does not have the trans. for customer.  
  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 11,925 Super User 2024 Season 2 on at
    Need to find Odata that has customer trans including Financial dimensions, not just GL transactions
    Hi,
    There is not a standard entity for this and then you need to create custom one for this purpose and make it public so you can use it via Odata.
    PS. data entity "CustTransBiEntities" have several info from CustTrans while it does not have FD values.
     
  • Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    Need to find Odata that has customer trans including Financial dimensions, not just GL transactions
    Hi,
    You can refer to the following related entities:
    CustVendTrans data entity contains customer and supplier transaction records. You can use this entity to retrieve transaction information about a customer. It contains fields such as transaction date, transaction type, account number (customer number), transaction amount, etc.
    CustTrans entity is used to record transaction information related to customers. For the fields this entity contains, you can check the link below:CustTrans in Transaction - Common Data Model - Common Data Model | Microsoft Learn
    Best Regards,
    Hana
  • Suggested answer
    Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Need to find Odata that has customer trans including Financial dimensions, not just GL transactions
    Hi,

    To retrieve customer transactions including financial dimensions in Dynamics 365 F&O, you can use the following steps:

    1. 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.

    2. 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.

    3. 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.

    Best regards,
    Kevin

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,113 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans