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.