Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

How to bring out ledger trans data with customer and vendor fields onto a report, which data entities/Tables are required in D365?

(0) ShareShare
ReportReport
Posted on by 145

Hi

We are trying to create various cost Centre/Bank reports, in AX we pulled through data via custtrans and vendtrans, however in D365 where we can we are using default description to bring in Customer/Vendor account numbers, This is not available for all posting types and we would like to use the Customer and Vendor fields on the Voucher, I understand that these are Dimension Attribute Values and there are a numbert of tables including DimensionAttributeValuescombination however we are struggling to join on GeneralJournalAccountEntry or Ledger Trans.

In the below transaction we have managed to pull a default description however for Bank postings this does not pull through on the description and only visible through the attribute fields.Has anyone managed to join the tables and if so are you able to share the query or advise if there is another method.

I have also looking into financial reports to see if these attributes can be pulled but no luck. so any help will be appreciated

Thanks

Reshma

  • JamesT Profile Picture
    JamesT 341 on at
    RE: How to bring out ledger trans data with customer and vendor fields onto a report, which data entities/Tables are required in D365?

    Hi Reshma

    Have you looked at the ACCOUNTING SOURCE EXPLORER inquiry.  This includes Customer/Vendor name and code.

    Regards

    James

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,836 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans