Microsoft has scheduled Dynamics 365 Finance & Supply Chain Management (D365 F&SCM) version 10.0.42 for general availability for self-update on December 27, 2024. However, the release became available slightly earlier, on December 23, 2024.
While Microsoft’s Release Notes for both Finance and Supply Chain Management provide a high-level overview of new features and changes, many organizations require a more detailed and controlled approach to managing their upgrade process.
This is where AXImprove’s solutions, particularly ConfigCompare, provide significant value. To offer deeper insights into table structure changes between versions 10.0.41 and 10.0.42, we performed an upgrade of a standard D365 Finance & Supply Chain Management demo environment (Contoso database) under ConfigCompare’s monitoring.
While our findings from the Contoso database provide useful insights, the most accurate assessment of changes and data integrity should be performed in your own environment before upgrading.
Upgrade Analysis Process
Our analysis followed a structured methodology:
1. Export Dataset from D365 Finance & SCM 10.0.41
- Used standard definitions (all modules): 935 configuration tables.
- Requested table statistics, generating 14,164 rows in TableStats.
- Requested table and entity structures, yielding 215,371 rows in TableColumns.
2. Upgrade to Version 10.0.42
3. Export Dataset from Upgraded D365 Finance & SCM 10.0.42
- Using the same parameters, the dataset now contained:
- 14,283 rows in TableStats.
- 217,659 rows in TableColumns.
4. Comparison of 10.0.41 vs. 10.0.42 Datasets
- Analyzed configuration table changes, new tables, row count changes, potential structural fixes, and other notable inconsistencies.
Configuration Table Changes
Our analysis identified:
- 12 tables with structural changes.
- 10 tables with modified content (155 rows affected), out of 933 identified configuration tables in D365 Finance & SCM.
Example: Noteworthy Change in Sales Parameters
One significant update was identified in SalesParameters:
- A new field, SalesOrderLineDateFieldValidation, was introduced.
- This field is initialized to “Yes” by default.
This underscores the importance of diligence in updates, ensuring that organizations fully understand what has changed before deployment.
For ConfigCompare users, we are distributing the full Contoso 10.0.41 vs. 10.0.42 comparison in its original format.
General System-Wide Table Changes
New Tables
Version 10.0.42 introduces 119 new tables, categorized by module/functionality:
Tables with Changed Row Counts
- 90 tables exhibited changes in row count.
- Noteworthy cases:
- ArchiveServiceType increased from 8 to 11
- CDSVirtualEntityList (Dataverse Virtual Entity) increased from 3,859 to 3,932 rows, suggesting significant changes in this area.
Potential Structural Fixes
Some table structures and field labels were adjusted for greater accuracy:
Inconsistencies Discovered
Our analysis flagged several potential documentation or labelling inconsistencies:
- SourceDocumentCleanupForSalesOrderInvoiceRemoveQueue
- Unusually long, full-sentence labels, which may belong in the Developer Documentation property
- SourceDocumentCleanupForSalesOrderPackingSlipRemoveQueue
- Similar issue as above.
- DimensionValueRenameAudit
- Label remains invalid and requires further investigation.
Additional Observations
- Several tables, especially within the CustInvoice* range, have a new system field: SYSDATASTATECODE.
- This appears to be related to a State Machine property, requiring further analysis.
We have attached the full comparison between Dynamics 365 Finance & SCM versions 10.0.41 and 10.0.42, prepared using ConfigCompare. Just click on the Download button and bookmark it for easy access anytime in your day-to-day work.