Report Designer Bugs - Formula InStr (Acumatica 2021 R2)

  • 19 October 2023
  • 3 replies
  • 40 views

Userlevel 1

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.


3 replies

Badge +10

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

Userlevel 1

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.

Userlevel 7
Badge

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

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