Solved

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

  • 14 June 2024
  • 2 replies
  • 21 views

Userlevel 3
Badge

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?  

 

 

icon

Best answer by hkabiri 14 June 2024, 22:24

View original

2 replies

Userlevel 6
Badge +5

@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.

 

Userlevel 3
Badge

Understood, thank you @hkabiri

Reply


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