web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Available finance tabl...
Finance | Project Operations, Human Resources, ...
Answered

Available finance tables for BYOD

(0) ShareShare
ReportReport
Posted on by S_Fryer 20

Hi all, 

We currently export various entities/tables from D365 (which I'm new to) and are now looking to export the various finance entities / tables, but there seems to be very little available for BYOD. Can anyone share links to any documentation that will shed light on this?

I'm interested in the following:

  • General Journal Entry
  • General Journal Account Entry (We already have this)
  • Ledger Entry
  • Ledger Entry Journal
  • Ledger Journal Trans
  • Sub Ledger Voucher General Journal Entry

The main one would be the general Journal Entry as from what I can see, this contains party name and party number (vendor).

Any support on this is greatly appreciated. Apologies for any vagueness due to lack of knowledge.

Regards,

Steve 

I have the same question (0)
  • Alex VN Profile Picture
    Alex VN 1,994 on at
    RE: Available finance tables for BYOD

    Hi,

    You can try to use this table. The data can be extract from LedgerDimension in LedgerJournalTrans and also you need to folter on Account Type of Vendor also.

    DimensionAttributeValueCombination dimensionAttributeValueCombination;

    select firstonly DisplayValue from dimensionAttributeValueCombination

               where dimensionAttributeValueCombination.RecId == _ledgerJournalTrans.LedgerDimension;

    Hope this will help.

  • S_Fryer Profile Picture
    S_Fryer 20 on at
    RE: Available finance tables for BYOD

    Do you happen to know which tables/entities would allow linking a supplier/vendor to the general journal?

  • S_Fryer Profile Picture
    S_Fryer 20 on at
    RE: Available finance tables for BYOD

    Thank you Alex. I'll have a chat with our contact.

  • Suggested answer
    Alex VN Profile Picture
    Alex VN 1,994 on at
    RE: Available finance tables for BYOD

    Hi Steve,

    For this one I think you can get the base table, then ask your technical team to check for out of box entities available.

    In case the entities are not available standardly, you can consider to create custom entity with the below post for your own usage of BYOD. This might need some technical knowledge for D365FO development with Visual Studio.

    d365ffo.com/.../

    Hope this helps.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,333

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 846 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 681 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans