Solved

TRIMMING A FIELD IN REPORT DESIGNER (FORMULA ?)

  • 27 September 2023
  • 2 replies
  • 146 views

Userlevel 1

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

icon

Best answer by dcomerford 27 September 2023, 13:52

View original

2 replies

Userlevel 7
Badge +12

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)

Userlevel 1

@dcomerford thank you very much for the response, the substring works perfectly 

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