Solved

Prevent Lookup Table on GI Parameter

rcreasy
Rank
Userlevel 4
Badge

I am attempting to add a parameter to the Sales Order GI. I need to search the field for any that contain the contents of the parameter.

I have it set like this:
 

This results in:
 

How do I prevent the <NEW> and, if possible, the lookup table? I want the users to have the ability to enter text without the system trying to lookup an SO

icon

Best answer by darylbowman 9 May 2024, 16:33

View original

7 replies

miguel80
Rank
Userlevel 5
Badge +1

Hi!

 

I think that you shouldn’t use the schema field. Just leave it as an open field and the user will be able to write anything. This, however, will prevent any sugestions from the system.

 

Hope this helps

Miguel Q
Laura02
Rank
Badge +18

Hello @rcreasy ,

I’m confused by your question, because Sales Order - Order Number field already appears in the Sales Order preview list and it’s already searchable (in full, and using partial) using the Search field as shown here:

 

Any field you add to the Preview List, or to any Generic Inquiry becomes searchable as shown above when the following Use in Quick Search box is selected, checked ON, for each line:

Laura

Laura ~ Klear Systems, Inc. Irvine, CA. ~ AUG Forums Episode130 ~
rcreasy
Rank
Userlevel 4
Badge

@miguel80 Thanks for the response. I did try that. I get an error stating that the field cannot be empty.
 

 

rcreasy
Rank
Userlevel 4
Badge

@Laura02 You are correct. However, we have so much data that the quick search is anything but quick. I know that column search is faster. But, that requires the user to take several steps. I am trying to speed things up.

rcreasy
Rank
Userlevel 4
Badge

@Laura02 Your response gave me the idea to remove OrderNbr from the quick search. That change gave me the result I want.

I am going to wait for any other input before I call this the solution. 
Any other thoughts from the hive mind?

darylbowman
Rank
Badge +11

Set the schema field to a free form text field, something like SOOrder.description

Daryl ⚡Contract Acumatica Developer (MVP🏆) for hire ⏩ linkedin.com/in/darylbowman
rcreasy
Rank
Userlevel 4
Badge

@darylbowman You Rock! Thanks for coming through again. 
For others that come across this issue - I used the field SOOrder.OrderDesc

Reply


Terms & ConditionsCookie 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