Skip to main content
Solved

Cannot check "Use in Quick Search" for a specific data field.

bigred1022
Jr Varsity II
Forum|alt.badge.img

Hello,

Created a GI and added all of our data fields.  Inquiry loads perfectly fine.  However, we can’t search the data field “InventoryCD_Description”.  When I try to check the box that says Use in Quick Search, it doesn’t let me.  Any idea why?  

 

 

Best answer by hkabiri

@bigred1022 Please be informed those fields which has this format DAC Name_abcd (contain underscore) usually not the real field on Database Table but using some foreign key to get info from other tables and bql fields. In this case it would be impossible for GI to run the keyword search as it can cause huge performance issues.

That being said, and in your case I suggest to use InventoryItem.Descr instead which is basically the same field and you should be able to have the use in quick search enabled on it.

 

View original
    Did this topic help you find an answer to your question?

    2 replies

    hkabiri
    Acumatica Moderator
    Forum|alt.badge.img+7
    • hkabiri
    • Acumatica Support Team
    • 230 replies
    • Answer
    • June 14, 2024

    @bigred1022 Please be informed those fields which has this format DAC Name_abcd (contain underscore) usually not the real field on Database Table but using some foreign key to get info from other tables and bql fields. In this case it would be impossible for GI to run the keyword search as it can cause huge performance issues.

    That being said, and in your case I suggest to use InventoryItem.Descr instead which is basically the same field and you should be able to have the use in quick search enabled on it.

     

    SAM KABIRI | L2 Support Engineer | hkabiri@acumatica.com | www.acumatica.com
    bigred1022
    1 person likes this
    • bigred1022
      bigred1022
    bigred1022
    Jr Varsity II
    Forum|alt.badge.img
    • bigred1022
    • Author
    • Jr Varsity II
    • 31 replies
    • June 14, 2024

    Understood, thank you @hkabiri

    Chris Hackett
    1 person likes this
    • Chris Hackett
      Chris Hackett

    Reply


    Most helpful members this week

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved