Hello all,
How can I display only a second segment of subaccount (AAA-BBB) in my report?
So as per the above segment I only want to display BBB in my report. Maybe I would be need to apply formatting condition?
Thanks.
Answer
How can I only display second segment of the subaccount in the report?
Best answer by nhatnghetinh
Hi
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
+11Hi
Please use the Right( str, length ) function. For example: = Right( [GLTran.SubID], 3 )
Best Regards,
NNT
Hey
+11Hi
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
I have devoted my time and deep passion to Acumatica! 🌐 https://www.linkedin.com/in/phambaotruong
To display only the second segment of the SubAccount in an Acumatica report:
- 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.
- 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.