No problem at all, maybe it will help someone in the future. 

There are a few DACs that contain the subaccounts as segments however if you already have Sub in your structure try this:

=Substring( gSub.SubCD], START POS, LENGTH )

Good grief.  I should have caught that.  It was originally red and would not save but I hade fixed that problem so the yellow one threw me off.  I appreciate your help with this.  Sorry I didn’t figure it out myself.

Just in case you might now, is there a table in Acumatica that contains the subaccount with each segment as a column.  They used to have one in Dynamics SL and I was hoping Acumatica had done something similar but I have been unable to find it.

Hi Stephanie, 

The yellow icon in Acumatica is a warning to provide possible issues with the field indicated.  If the warning was a red X then you would not be able to save and run the generic inquiry.  You will receive similar warnings when running any calculation in a Generic Inquiry for grouping. 

Here you go.

Strange can you send me the GI in xml format will plug it in to my pack and check it

Thanks for your help!

Hi

Can you send me the screenshot of the Tables on the GI as i have used something like this before and it works fine. I just did a quick test and it works fine on 23R1 for your example. Just check that the Alias is Sub for this Table on the GI