Hello everyone!
I’m not able to find Parent/Subaccountof field present on chart of account record while creating a saved search on Transactions in Account Fields or anywhere else!!!
Please help me here!! I want to show that Parent account value in saved search
r
RJMNS
05/11/2022, 6:14 PM
Try a SuiteAnalytics Workbook. There are many more exposed fields there on Account records.
For whatever reason, NS really skimped on exposing GL Account data on Saved Searches. There are a bunch of other missing fields too.
n
Nilesh Patil
05/12/2022, 3:38 AM
okay thanks @RJMNS
p
Paul Giese
05/12/2022, 2:55 PM
I believe this formula will work in an Account saved search: TRIM(REGEXP_SUBSTR({accountgrouped}, '[^:]+'))