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

Non-responsive Dynamics365BusinessCentral custom query

(1) Share

Report

Posted on by GB-24011145-0

The custom query is joining two tables:

21 (Cust. Ledger Entry)

254 (VAT Entry)

using documentNo in a left join condition, the purpose is to get the VAT amount for relevant transactions.

It has worked fine for a number of different companies but with one particular company it is non-responsive. The company has a lot of data, I know it has around 330K customers.

Is there anything I can do to extract the data for this company?
I am filtering by postingDate.

Categories:

Dynamics 365 Business Central

All responses (3)

Answers (0)

Suggested answer

YUN ZHU 76,532 Super User 2024 Season 2 on at

Like (0)

Report

Non-responsive Dynamics365BusinessCentral custom query

It is recommended to add some filters in Query.

For example,

Filtering in Query objects

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-query-filters?wt.mc_id=DX-MVP-5004336

Hope this helps.

Thanks.

ZHU
Suggested answer

Khushbu Rajvi. 7,281 on at

Like (1)

Report

Non-responsive Dynamics365BusinessCentral custom query

Hope this helps: https://community.dynamics.com/forums/thread/details/?threadid=58cbc138-72ac-4312-b47e-154ea70f63bf
Suggested answer

Mustafa Omerbegović 1,182 on at

Like (1)

Report

Non-responsive Dynamics365BusinessCentral custom query

Hello,

Try to set some additional filters and run query few times to get your data.

If you paste your code we could give you better answer for sure.

Also, you have all that data in the GL entries and you can filter by source type and source no for more specific customer no so you would not have a need for joining tables.

Greetings