Skip to main content
Solved

"Does not start with" equivalent for Generic Inquiry condition

  • 3 September 2024
  • 2 replies
  • 101 views

I cannot figure out an elegant way to create the equivalent of “does not start with” in a Generic Inquiry. I’ve tried these things which I would have thought might work but couldn’t for one reason or another:

  • Create a Condition to pull the Substring of the field I was looking for and say it does not equal the value I’m looking to exclude, however I cannot use a function in the ‘Data Field’ of a GI Condition.
  • Still use “starts with” but find a way to create the negative of that, but nowhere in Acumatica do I see that as an option.
  • Use wildcards to compare with the % character, however it seems like it will never satisfy the start of the string and only compare to the entire string (for example, when I tested making a condition where the value does not contain T% it works as if I entered %T% and will also filter out something that has text in front of the T like “ABCT1234” which is not what I want).
  • Add it to the relation instead of a condition and compare a substring of the parent field so it does not equal the string I hope to exclude, but I cannot seem to use a string in the child field since it keeps searching for a field.

At this point the only clean solution I can think of would be to extend a DAC to include the substring of a field which is an incredible amount of overkill.

Instead I’m thinking of going with this solution. It works, which is great, but I just think there should be an easier option that doesn’t use sorting to figure it out (the character after CR is the Greek capital letter XI which I would hope comes after Z).

 


Does anyone else have any other ideas that I’m not thinking of? Or maybe I’m missing something that’s incredibly obvious, that’s possible!

Best answer by lauraj46

Hi @mmarklow44 ,

Even though the formula editor for the Value 1 does not show the fieldnames, you can use them in the formula.  You could try a formula like this, see screenshot below:

=iif(left([BAccount.AcctName],3)=’ABC’,[BAccount.AcctCD], ‘’)

Hope this helps!

Laura

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

2 replies

lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 503 replies
  • Answer
  • September 3, 2024

Hi @mmarklow44 ,

Even though the formula editor for the Value 1 does not show the fieldnames, you can use them in the formula.  You could try a formula like this, see screenshot below:

=iif(left([BAccount.AcctName],3)=’ABC’,[BAccount.AcctCD], ‘’)

Hope this helps!

Laura


  • Author
  • Freshman I
  • 5 replies
  • September 4, 2024

Yup, I missed something incredibly obvious. I was too busy trying to grab the substring from the data field directly or use a specific condition to compare when I could just literally add the comparison in the condition value. I still do think it’s a little goofy and it would be helpful for Acumatica to have a ‘does not start with’ or the ability to add a negative option for any condition, but that’s still a better solution than I came up with.

 

Thanks!


Reply


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