Skip to main content

Report Designer Bugs - Formula InStr (Acumatica 2021 R2)


Hi there, I think this is a bug too that the formula of “InStr” return the different value with G.I.

 

In G.I., I use “InStr” formula to find the text position and return 0 if it dosen’t exist.  It is correct.  However when I use “InStr” formula in Report Designer, it return -1 if the value dosen’t exist.  It shouldn’t be correct.

 

Is anyone can give corrective advise or point out what is the problem?   Appreciate & thank you in advance.

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

3 replies

darylbowman
Captain II
Forum|alt.badge.img+13

I believe this is an inconsistency between the Report Designer and GIs. I can confirm having the same experience in the past.


  • Author
  • Jr Varsity II
  • 8 replies
  • October 20, 2023
darylbowman wrote:

I believe this is an inconsistency between the Report Designer and GIs. I can confirm having the same experience in the past.

Thank you so mcuh for your feedback and sharing.

 

However, it shouldn’t be correct.  It is because “InStr” is a very general function in any scripts.  It doesn’t ever have -1 result normally.  I do not know why Report Designer come to the first case with this result.  It is absolutely inconsistent with “InStr” common concept and logic.

 

Besides, G.I. and Report Designer are both under Acumatica system, the formula should be under the same concept and logic too.  Otherwise, it should be a unequal bug in my opinion.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2528 replies
  • November 29, 2023

Hi @martinma were you able to find a solution? Thank you!


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