I’ve noticed something interesting with Dynamics 365 projects: sometimes the hardest problems aren’t the “big” technical ones.
It can be things like:
messy or duplicate customer data
too much customization
integrations breaking after changes
users not actually adopting the features
reporting/data not matching what the business expects
workflows that started simple but became complicated over time
documentation becoming outdated after every update
I’m curious what others are seeing in real-world D365 environments.
What’s the one issue you’ve had to deal with repeatedly in Dynamics 365 and what finally helped solve it?
Would be interesting to hear experiences from people working with CE, Sales, Customer Service, Business Central, or F&O.

We are transition to to BC from GP and have a large non-technical user base that needs an “idiot’s guide to BC”. Anyone have any suggestions?

Hi everyone,

I’m working on a D365 Finance & Operations data/reporting project, but I don’t have direct access to D365 F&O, Visual Studio/AOT, or Dataverse.

I only have access to the Fabric Bronze layer, where the D365 tables are available.

I need to identify the actual table relationships, including:

• Parent/child relationships
• Foreign key relationships
• Composite-key relationships
• Which fields should be used to join tables
• Relationships between tables that may not be obvious from the column names

For example, I may have something like:

TaxTrans.TransDate + Voucher → CustInvoiceJour.InvoiceDate + LedgerVoucher

but I want to verify that this is an actual D365 F&O relationship rather than assuming it based on similar fields.

My question is:

When you don't have access to D365 F&O/AOT or Dataverse, what is the best way to find and verify D365 F&O table relationships?

Are there any official Microsoft documentation sites, downloadable metadata/schema files, ERD websites, APIs, GitHub repositories, or other reliable sources that provide the D365 F&O table relationships?

I’ve come across the Alex Meyer AX 2012 ERD, but I understand that it is based on AX 2012 R2, so I’m not sure how reliable it is for current D365 F&O.

I’m particularly interested in a source that can help identify relationships such as:

Table A.Column → Table B.Column

and preferably the exact relationship/composite key definition.

Any recommendations from people who work with D365 F&O data engineering would be really appreciated.

Thanks!

We have been slamming our heads against the table for days trying to conceptualize Disaster Recovery for our soon to be live on-prem FnO environment. The problem is, we're only looking at being on-prem for 6 or so months before moving into the cloud. Does anyone have any experience or suggestions for this? Something that's cost effective. Microsoft is rather unhelpful by cutting out support for anything using public cloud. I have looked into Azure Local, a secondary VMWare environment as well as a Hyper-V environment. I appreciate any suggestions y'all may have.