Ideas for Acumatica

Important! Please note that we do not reply to all messages, but we do read them, analyze them, and work to improve Acumatica based on the feedback we receive.
This portal is for product ideas and feedback only. If you need customer service assistance, please contact your Acumatica Support Partner or submit a support case.  You can also get assistance from community resources:  LinkedIn Group or StackOverflow
No Reliance: Information is maintained on a best-efforts basis and may be changed without notice. Acumatica cannot guarantee the accuracy of the information provided or guarantee completion of features/ideas described on this portal. 

Implement correct work of 'Equals' filter for Location field



There is an issue with filtering CustomerLocationID field (SOOrder DAC).

When we try to filter CustomerLocationID  by 'Equals' filter it works incorrectly.

To reproduce this you can add this field on Sales Orders Generic Inquiry screen. And then for example filter sales orders with 'MAIN' location, you will get sales orders only with CustomerID, which was the first in the grid.

I will attach screenshots, hope it will be clear.

We have the following lines in the grid.

GetFile.ashx (1280×470)
As you can see there are CONSTPLAZA, FDIGREEN, FDIMINN and other customers with MAIN location in the grid.
When we open the filter of Location field and choose 'Equals' and enter 'MAIN' then click 'ok'.

GetFile.ashx (1280×420)
We will have the following result in the grid.

GetFile.ashx (1280×378)
As you can see result grid contains lines only with customer CONSTPLAZA, but doesn't contain FDIGREEN, FDIMINN and other which also have MAIN location.
Filter 'Contains' works properly, but 'Equals' doesn't.

Best Regards,
Anna Ermakovich.

  • Guest
  • Feb 13 2020
  • Attach files