Solved

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

Forum|Forum|2 years ago
June 14, 2024
2 replies
115 views

bigred1022
Jr Varsity II

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.

+8

hkabiri
Acumatica Support Team
Answer
Forum|Forum|2 years ago
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.