Skip to main content
Question

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

  • November 2, 2022
  • 0 replies
  • 233 views
E
Varsity I
Forum|alt.badge.img

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

1 Attachments

    0 replies

    Be the first to reply!

    Reply


    Most helpful members this week

    Terms & ConditionsCookie settings

    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
    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