Hi there,
Is there a “Format” or “Formula” to trim a field in report designer.
ie. I want to turn C-16600-O into just 16600. I do not want to physically change the naming convention inside Acumatica, i simply just want to trim the field in the report designer.
Your help would be highly appreciated.
Thank you
On the field on the form if you click on the 3 dots to the right hand side of the value you can open the expression editor so you have access to all the edits and under Text you will see the text applicable ones.
A couple of ways of doing it using LTrim etc but substring is easiest so in case below for customer order number print from the 3th position and print next 5 characters.
=Substring([SOOrder.CustomerOrderNbr],3,5)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.