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.

No alt text provided for this image

After clicking apply they were getting the below error

No alt text provided for this image

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.

No alt text provided for this image

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.

Denis Trunin

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?

回复

要查看或添加评论,请登录

Krishnendu Sinha的更多文章

  • Memoization and it's use in AX365

    Memoization and it's use in AX365

    Let us see the definition of memoization in wiki. "Memoization or memoisation is an optimization technique used…

    9 条评论
  • If value exists check

    If value exists check

    This check could look very trivial but it could definitely help us save from getting future bugs. If we are writing any…

    4 条评论
  • Job History cleanup -Data Management

    Job History cleanup -Data Management

    Recently we faced an issue where the data comes through Recurring Integration and some of the data din't make it to…

    1 条评论
  • Post data to D365F&O with OData using Postman tool

    Post data to D365F&O with OData using Postman tool

    In this post we will see how to POST data using Odata to D365 and few caveats. Before proceeding please go through…

    4 条评论
  • Customize Open in Excel Menu in D365F&O

    Customize Open in Excel Menu in D365F&O

    We are cognizant that the open in office (open in excel ) menu brings the data entities based on the root data source…

    4 条评论
  • Use Postman tool in D365 without registering in Azure ADD for testing Data Entities(Odata) Rest APIs.

    Use Postman tool in D365 without registering in Azure ADD for testing Data Entities(Odata) Rest APIs.

    Postman is handy tool when you want to test restful API’s. You can simply create entity in D365 finance and operations,…

社区洞察

其他会员也浏览了