Solved

GI Parameters for Greater Than/Less Than/Between on Account Code

  • 21 July 2022
  • 5 replies
  • 101 views
P
Rank

My customer wants GI screens with “Between” on string/varchar fields.  I don’t see a way to do this in a GI.  Am I missing something?

icon

Best answer by Fernando Amadoz 21 July 2022, 17:08

View original

5 replies

Fernando Amadoz
Rank
Userlevel 5
Badge +2

@PSchirf61 

OOB, that filter option is available on DateTime and numeric controls with the native grid column properties.

It is not available in string values like AccountCD

You could try to build it with GI parameters. The users would then filter by parameters available in the header of the page, as opposed of filtering with the column filters.

P
Rank

I’ve tried to build it with header parameters, but when I use Greater Than/Less Than/Between on the conditional against string/varchar fields they do not work.

Fernando Amadoz
Rank
Userlevel 5
Badge +2

@PSchirf61 

Use this GI reference.

I just created it and does filter as expected.

 

1 Attachment
K
Rank

@Fernando Amadoz Is it possible to use a selector for Account IDs? This GI doesn't currently have a selector for Account IDs. 

Fernando Amadoz
Rank
Userlevel 5
Badge +2

@KumarDighe Certainly. That should be possible. You can filter GIs by any field that belongs to the DAC.

Use the GI from this thread as reference and expand it to include the AccountID as a parameter as well.

 

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