By using this website, you agree to our Terms of Use (click here)
Hello!!
I need help splitting the below formula into two separate lines. one line for the INVENTORY ID, and a separate line for the descriptions.
I keep getting a message that I am missing the closing parenthesis.
Thank you!!
=IIf([SOLine.InventoryID]<>Null, Format( '{0}: {1}', [SOLine.InventoryID],[SOLine.TranDesc]),[SOLine.TranDesc])
I copied the information you supplied. Commented out the form field information supplied by Acumatica and inserted what you have. No error came up.
When I validated. Maybe retry. Matt
Thank you. The formula I posted is not the one with the error. When I tested what you wrote it did work but just repeated the Inventory ID on the second line.
I need to split my formula into two formulas. One formula that will show the Inventory ID and another one that will show the Description of the Inventory ID. I get an error when I try to split them because I don't know how to split them out.
🙂
I split the detail line. Item number on top line, Description on the second line.
On the top line you could turn off CanGrow. But you would probably leave it on the second line.
I hope this helps
Matt