Question

GI Formula If and Replace - Index Was outside the bounds of the array error.

  • 3 November 2022
  • 0 replies
  • 194 views

Userlevel 5
Badge

Good day, 

Below is a formula that i am trying to replace the Inventory ID with the line description for a specific Inventory item.  Replace part works.  I get a new field with the description but something is wrong with my IF statement.  I can an error from the system it is outside the array =

Index was outside the bounds of the array.

I would also rather then you the entire id but use the EZ start with; but can’t fine the correct formula.  In case the user decides to change the ID. 

=IIf( [POLine.InventoryID]=EX-99-ZZ-ZZ-ZZZZ06-ZZZ, Replace( [POLine.InventoryID], [POLine.InventoryID],[POLine.InventoryID_description],[POLine.InventoryID] ))


Your assistance is greatly appreciated.

Attached hew GI

Evan


0 replies

Be the first to reply!

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