News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... ERD Documentation for ...

Finance | Project Operations, Human Resources, ...

Suggested answer

ERD Documentation for D365 Data Entities

(1) Share

Report

Report

Posted on by MG-09041621-0

7

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

All responses Img

All responses (4)

Answers Img

Answers (0)

MG-09041621-0 7 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
André Arnaud de Cal... 294,261 Super User 2025 Season 1 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?
MG-09041621-0 7 on at

Like (0)

Report

ERD Documentation for D365 Data Entities

Thank you for all the information, Holly!

I very much appreciate your help!
Suggested answer

Holly Huffman 5,917 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!

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 294,261 Super User 2025 Season 1

#2

Martin Dráb 233,017 Most Valuable Professional

#3

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans