Ideas for Acumatica

Feedback processing: 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. Ideas and comments may not appear immediately. Some legitimate ideas are flagged as spam and will be added when we review the spam folders.
Content: This portal is for product ideas and feedback only. If you need customer service assistance, contact your Acumatica Support Partner, submit a support case, or 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.

Search doesn't work in the lookups on primary screens (Items, Customers, Vendors, etc.)

Normally, when you type into a lookup (magnifying glass) field, Acumatica automatically does a contains search across the data in the ID and Description fields. However, this doesn't work on the primary screen for that lookup. For example, if you start typing an ID or Description into the Inventory ID field on the Sales Orders (SO301000) screen, the search will be performed, but it doesn't work on the Inventory ID field on the Stock Items (IN202500) screen because that is the defining screen for Inventory ID. The same is true for the Vendor ID and Customer ID fields. Is there a way to get the search to work on the defining screens for a lookup?

  • Tim Rodman
  • Feb 7 2016
  • Shipped
  • Attach files
  • Tim Rodman commented
    8 Jun, 2018 11:26am

    I just tried it on the Vendors (AP303000) screen in 18.103.0022 and it still doesn't work.

    I type in "GOTO" and it doesn't search on Vendor Name:


    But, the more I think about it, I don't think that this is possible because the field where you create the ID has to function differently than the lookup fields everywhere else in the system. The field in the screenshot above has to validate against the Segmented Keys, not do a search.

    If this is indeed the case, it makes sense to me from a technical perspective. But I can see how users get confused when the search function isn't performed.

  • Vladimir Panchenko commented
    8 Jun, 2018 08:22am

    Sorry for the late answer. This functionality was implemented some time ago.

    I've checked it on 2018R1 Update 3 on the following screens, and it seems to be working fine:

    • Customer Entry (works both by Customer ID and Customer Name)
    • Vendor Entry (Vendor ID, Vendor Name)
    • Stock / Non-Stock Items (Inventory ID, Description)
    • Sales Prices (searches by Price Code / Customer ID, doesn't search by Description - this is a bug, fix will be shipped in 2018R1 Updates)
  • dan_00 commented
    21 Sep, 2017 02:48am

    Absolutly. This would be a great feature in the screens mentioned, including the price list as mentioned by russ.

    Seeing it is already installed on some screens as Tim notes, wouldnt it be quite straightforward to extend this functionality to the rest of the screens?

  • russ williams commented
    26 Jul, 2017 03:13pm

    Add Price List.  If you enter Customer as the price type, you have to know the customer code, can't search for it.  Even if you go to the look up/search icon.