How can I only display second segment of the subaccount in the report?

Hi ​@Harry 

Please use the Right( str, length ) function. For example: = Right( [GLTran.SubID], 3 )

Best Regards,

NNT

Hey ​@nhatnghetinh , thanks for your prompt response. Similarly I also have project tasks with 2 divisions/segments. The first segment - 10 chars & the second - 4 chars. So in order to print only 1st segment it would be: Left([PMTask.TaskCD],10)?

Hi ​@Harry 

That's right. You use the Left( str, length ) & Right( str, length ) functions to get the left or right character strings from the position you want to get.

Best Regards,

NNT

To display only the second segment of the SubAccount in an Acumatica report:

1. Modify the Report Data Source:
   Use the SplitSegment function in the report’s field expression:

Copy

=SplitSegment(SubAccountID, 1)

Replace SubAccountID with your actual field name.

2. Adjust the Index:
   • Segments are zero-indexed (e.g., SplitSegment(SubAccountID, 1) returns the second segment).
   • Verify the delimiter and segment count in SubAccount Settings (GL > Setup > Segments).

This extracts the desired segment dynamically based on your configuration.