Database access intent changed to read-only for frequently used reports
Some of the functionality described in this release plan has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What's new and planned
|Enabled for||Public preview||General availability|
|End users, automatically||Aug 2020||Oct 2020|
Businesses need fast access to information, and don't want to wait while the system finds or calculates it. To speed up several key reports, where you want to view but not change any information, we've changed the default database access intent to use the read-only replica.
To improve performance in reporting we have changed the default database access intent to read-only for a number of frequently used reports. The reports will use the capacity of a read-only replica rather than share the read-write replica (also known as the primary database). Using the database replica reduces the load on the primary database.
For more information, see Managing Database Access Intent.
Read scale-out might introduce a slight delay when reading data from a database's secondary replica. The delay is caused by the way high-availability databases replicate data changes from the primary database to secondary replicas. If a delay isn't acceptable for an object, you can overwrite the default database access intent.
The following sections list the reports for which we changed the default database access intent.
Reports in W1
|Report ID||Report name|
|4||Detail Trial Balance|
|38||Trial Balance by Period|
|101||Customer - List|
|105||Customer - Summary Aging|
|109||Customer - Summary Aging Simp.|
|111||Customer - Top 10 List|
|119||Customer - Sales List|
|120||Aged Accounts Receivable|
|121||Customer - Balance to Date|
|129||Customer - Trial Balance|
|305||Vendor - Summary Aging|
|310||Vendor - Labels|
|311||Vendor - Top 10 List|
|321||Vendor - Balance to Date|
|322||Aged Accounts Payable|
|707||Inventory - Availability Plan|
|712||Inventory - Sales Statistics|
|717||Inventory - Reorders|
|5757||Items with Negative Inventory|
|5808||Item Age Composition - Value|
Reports in US, Canada, and Mexico
|Report ID||Report Name|
|10021||Trial Balance Detail/Summary|
|10023||Trial Balance, per Global Dim.|
|10026||Trial Balance, Spread Periods|
|10040||Aged Accounts Receivable|
|10047||Customer Sales Statistics|
|10085||Aged Accounts Payable|
|10103||Vendor Account Detail|
|10110||Vendor 1099 Information|
|10135||Item Sales Statistics|
|10145||Item Sales by Customer|
Reports in Austria, Germany, and Switzerland
|Report ID||Report name|
|11517||Inventory Value (Help Report)|
Tell us what you think
Help us improve Dynamics 365 Business Central by discussing ideas, providing suggestions, and giving feedback. Use the forum at https://aka.ms/bcideas.