Hello everyone! I’m not able to find Parent/Subacc...
# general
n
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
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
okay thanks @RJMNS
p
I believe this formula will work in an Account saved search: TRIM(REGEXP_SUBSTR({accountgrouped}, '[^:]+'))