Finance | Project Operations, Human Resources, ...

ERD Documentation for D365 Data Entities

(2) Share

Report

Posted on by MG-09041621-0

Hi all,

I just want to check if anyone knows of any Microsoft ERD Documentation showing data entity relationships.

I am working on a project and I'm trying to find how the Purchase Order relates to the Journal entries or ledger.

Please let me know if you have any suggestions.

Thank you,

Mike G

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Holly Huffman 6,522 Super User 2025 Season 2 on at

Like (1)

Report
ERD Documentation for D365 Data Entities

Good morning, afternoon, or evening :) depending on your location!

You can find documentation on D365 Finance & Operations data entities and their relationships, including how Purchase Orders connect to Journal Entries and the Ledger, in Microsoft's official resources. Here are some useful references:

General Journal Entity Documentation – Covers how journal headers and lines interact with financial transactions. You can check it out here.

Ledger and Subledger Overview – Explains how financial transactions flow into the ledger and subledger, including purchase order impacts. You can find more details here.

Ledger Journal Line Entity – Provides insights into journal entries and their structure within Dynamics 365. See the documentation here.

If you're looking for a visual ERD (Entity Relationship Diagram), Microsoft does not always provide explicit ERDs for all data entities, but you can explore Application Object Tree (AOT) in Dynamics 365 Finance & Operations to understand relationships between tables.

Hope this helps!

Was this reply helpful? Yes No
MG-09041621-0 9 on at

Like (0)

Report

ERD Documentation for D365 Data Entities

Thank you for all the information, Holly!

I very much appreciate your help!

Was this reply helpful? Yes No
André Arnaud de Cal... 299,415 Super User 2025 Season 2 on at

Like (0)

Report

ERD Documentation for D365 Data Entities

Hi Mike,

When your question is about data entities, then the relations are very limited. In case of a purchase order, there is a relation with purchase order lines, but there is no option to find ledger entries based on a PO number using data entities.

Can you tell what exactly you need to achieve so we can try to guide you?

Was this reply helpful? Yes No
MG-09041621-0 9 on at

Like (0)

Report

ERD Documentation for D365 Data Entities

Hi Andre

Thank you very much for your reply!

I'm looking to join the Purchase Order lines V2 back to the general journal entities, ledger, or account.

Please let me know if you have any suggestions.

Thanks,

Mike

Was this reply helpful? Yes No

Join the conversation

Community site session details

ERD Documentation for D365 Data Entities

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

ERD Documentation for D365 Data Entities

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates