Small and medium business | Business Central, N...

Performance issue for large data set in BC Indian localization

(1) Share

Report

Posted on by riya patel

Hi Everyone,

For one of our Indian client we have to GST rate with combination of the 30 HSN/SAC, around 10 GST Groups and 27 States. These combination sums upto around 3 lakhs of Combinations of GST Rates. Our client is implementing Business Central On-Prem version.

Although we have these many combinations, we still need to create new combination for every new HSN/SAC.

Because of these many combinations, We are not able to add any new combination because system is lagging.

We would not be able to reduce the HSN number as it is required for E-Invoicing.

Kindly suggest any other way to improve performance of the system.

Thanks in advance.

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Marco Mels on at

Like (0)

Report

Hello,

Here is some general information:

docs.microsoft.com/.../performance-onprem

I suggest you contact a partner that specialized in this.

Thanks.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,597 Super User 2025 Season 2 on at

Like (0)

Report

Hi, Also, please use the latest version of BC, Microsoft will make an effort to improve performance every time.

For example, in BC20.

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Tabrez Ajaz 785 on at

Like (0)

Report

Hi riya,

It's a well known performance issue now, I have checked for 1000 GST Groups, 1000 HSN/SAC and around 23000 GST Tax Rates.

My suggestion to wait for few more Microsoft Hotfixes.

For now I can suggest wrote stored procedure directly in your client DB and import new combinations directly to tables and restart your services, you can also call the stored procedure by creating an action on page.

Call stored procedure from Dynamics NAV/Business Central On-Prem

Be connected will update soon if I receive any information about this.

Was this reply helpful? Yes No

Suggested answer

Abhishek_P 26 on at

Like (1)

Report

Hello @riya patel,

To configure GST rates, you can directly Map GST Group code, From State, Location State Code with respective dates & GST percentage.

HSN/SAC is not mandatory field.

These will reduce the No. of row items.

Now, in your case Total row item will be 7290 (10 GST Group code X 27 Location state code X 27 From state code).

Hope this answer your question.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,439 Super User 2025 Season 2 on at

Like (1)

Report

hope this helps : https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/performance/performance-work-perf-problem

Was this reply helpful? Yes No