Form Filter limitation in AX 365
Recently we stumbled upon an issue where the end user was trying to filter records using the "IS ONE OF" criteria to settle trasactions for a customer payment journal.They were selecting around 2600+ invoices at once to filter.
After clicking apply they were getting the below error
We were getting the same error when we do the same filter range in table browser of table CustInvoiceJour which is when we thought it would be a standard limitation.
Upon debugging we could see the error was coming from kernel code.
So the filter range was having a limit of 1000 characters until platform 25 which was increased to 4000 characters n platform 26.
Please be mindful on the no of selection, for us as the invoice # lenght for the invoices were ranging from 9-10 characters so we could only select 4000/10 = 400 invoices give or take at once in the filter.
Dynamics AX / Dynamics 365 FO Technical Consultant
4 年Can they use an advanced query filter and add several ranges for the same field to work around this?