Efficient December 1, 2020, for all 10.0+ variations of Dynamics 365 Monetary Dimension Framework we’re stopping deletion from the next Dimension tables:
This transformation is utilized straight within the database and follows the identical enterprise logic that’s used inside the software.
These adjustments shield the integrity of the monetary accounting information. Any customizations or scripts will should be instantly up to date to adjust to these adjustments. Notice that updating information to clean values isn’t a legitimate answer as a result of this corrupts information. Sooner or later, we will even not enable desk updates.
Why the adjustments had been needed
These tables had been initially designed to be immutable information buildings, which signifies that they’re utterly managed by Microsoft or the official X++ APIs designed for extenders. This design allowed for top throughput and sturdy references that would stand the take a look at of time when performing historic regulatory reporting.
Sadly, many extenders have labored round these tips to delete data from the tables straight, resulting in information corruption and downstream influence. Examples of such points embody:
- Duplicate account rows in monetary experiences which are often utilized in year-end account reconciliation processes.
- Transactional processing failures that forestall the power to put up paperwork like Gross sales order invoices or Buy order invoices, amongst others.
- Historic reporting errors and/or adjustments ensuing within the lack of ability to satisfy auditing and/or regulatory reporting necessities.
- 12 months-end processing that could be blocked resulting from out-of-balance errors.
Fixing these points is extraordinarily error-prone and time-consuming to each prospects and Microsoft. Potential fixes additionally put the accounting information in danger, and enormously restrict the power to give attention to go-forward enhancements.
Microsoft doesn’t present assist on customizations or direct SQL queries to the above-mentioned tables. Because of this front-line assist and engineering groups will be unable to assist with points brought on by these customizations. Should you encounter information corruption resulting from customizations or working direct SQL queries, contact our companies crew or supply companions for help. It is rather vital that you just replace all customizations or direct SQL queries that delete data from these tables. Sooner or later, Microsoft will present a software for self-service correction of knowledge for focused eventualities.
For detailed details about monetary dimensions and the dangers of adjusting information straight, see Part 6: Advanced topics within the “Ledger account combinations” matter. To deal with one of many identified requests of hiding or inactivating values which are now not related, we are going to prioritize the power to assist “soft-deletions” and the corresponding elimination of unused references. You probably have extra requests, please share them within the Dynamics 365 Application Ideas portal.