Optimizing Performance in Dynamics 365 Business Central - Application areas

The Application areas which can cause performance impact to the system and tips to overcome it.

PublishedFebruary 20, 2023

Optimizing Performance in Dynamics 365 Business Central - Application areas

Hi there! I'm a Techno-functional consultant specializing in ERP systems, specifically Dynamics 365 Business Central. I work with businesses to optimize their processes, improve efficiency, and help them get the most out of their technology investments.

In addition to my work with Business Central, I'm also an aspiring learner in low-code technology, particularly Microsoft Power Apps. I believe that low-code solutions have the potential to revolutionize the way we build and deploy software, and I'm excited to be a part of this rapidly evolving field.

Through my blog, I hope to share my insights and knowledge with fellow ERP consultants, business owners, and technology enthusiasts. Whether you're looking to improve your Business Central performance or explore the possibilities of low-code technology, I'm here to help. So join me on this journey of learning and discovery, and let's explore the exciting world of enterprise technology together!

Comments

Join the discussion

No comments yet. Be the first to comment.

Business Central 🥑

Part 2 of 2

A series about exploring & thoughts on Business Central.

Start from the beginning

Using Configuration Package in Business Central as an alternative to Bulk Batch Processing

Often reports with 'ProcessingOnly' property is used for Bulk Batch Processing of records in Business Central. In this article, as an experimental change, we are going to use Configuration Package as an alternative to this Batch Processing of records...

Change Logs:

Change logs or audit logs are a critical feature of Microsoft Dynamics 365 Business Central that allows you to track changes made to data in the system. However, these logs can also have a significant impact on system performance, especially when dealing with large volumes of data. In this article, we will discuss how to avoid performance issues of change logs or audit logs in Business Central.

Use Change Log selectively: Change logs can be enabled or disabled for individual tables. You can choose to enable the change log only for the tables that require it. This will help reduce the amount of data that needs to be processed and improve performance.
Setting up Retention Policies: After a specified period, you can delete unneeded data from logs using retention policies. Over time, a log can accumulate entries. You can focus on more recent, and probably more relevant, entries by cleaning up old entries.

Security Filtering Mode:

Security filters are handled by SQL Server just like other filters that are applied by the user. They do not adversely affect performance unless the security filtering mode is Validated. If security filters are set on a table, then setting the SecurityFiltering property to Validated on a record instance of that table causes a decrease in performance.

Security filtering mode can have an impact on performance, especially when dealing with large amounts of data. To optimize performance, you can try the following tips:

Define Permissions by Granular Level: Create User Groups by Members & Permissions. After that, with consideration, plan using Record Level Security using Security filters.
Use views instead of tables: Using Page level views can help reduce the amount of data that needs to be processed and improve performance.

Inventory Posting

Business Central Inventory Posting

An Inventory transaction such as Sales or Purchase posts two entries:

Change of Quantity
Change of Value

Inventory posting can have a significant impact on performance, especially when dealing with large volumes of data. To optimize performance, you can try the following tips:

Batch Posting: Group transactions and post them in batches. This can help reduce the load on the system and improve performance.
Automatic Cost Adjustment: Configure the Cost Adjustment posting settings to periodic. For example, you can set the system to automatically cost adjustment at certain intervals or disable automatic posting altogether.

Dimensions

Especially when dealing with large amounts of data, dimensions can have a significant impact on performance.

Use Global & Shortcut Dimensions: When it's about Dimensions in Business Central, we have Global, Shortcut and Default Dimensions concerning Master data like Customer and Vendor. Using Dimensions in the following order and trying to reduce Default Dimensions and managing with Global and Shortcut Dimensions helps in performance.

Reservations & Order Tracking

The Reservations involve the linking of a Demand Entry with a Corresponding Supply Entry either through Reservation or Order Tracking.

Use filters: Narrow down the number of items that need to be reserved by using filters. For example, you can filter by location or item.

Item Tracking & Lot or Serial Expiration Dates

Use Item Tracking selectively: Item tracking can be enabled or disabled for individual items. You can choose to enable item tracking only for the items that require it. This will help reduce the amount of data that needs to be processed and improve performance.

Conclusion:

To sum it up, making Dynamics 365 Business Central run faster and smoother is a big task. It requires a deep understanding of the application areas where improvements can be made. But fear not, with the right approach, your business can reap the benefits of a high-performing system. So, let's optimize away and make our Dynamics 365 Business Central systems fly like a well-oiled machine!

Optimizing Performance in Dynamics 365 Business Central - Application areas

Comments

Business Central 🥑

Using Configuration Package in Business Central as an alternative to Bulk Batch Processing

More from this blog

Job Module - Business Central

Using Configuration Package in Business Central as an alternative to Bulk Batch Processing

Change Logs:

Security Filtering Mode:

Inventory Posting

Dimensions

Reservations & Order Tracking

Item Tracking & Lot or Serial Expiration Dates

Conclusion:

Command Palette

Comments

Business Central 🥑

Using Configuration Package in Business Central as an alternative to Bulk Batch Processing

More from this blog

Change Logs:

Security Filtering Mode:

Inventory Posting

Dimensions

Reservations & Order Tracking

Item Tracking & Lot or Serial Expiration Dates

Conclusion: