if I have a saved search of Journals, and my Bills...
# suiteanalytics
j
if I have a saved search of Journals, and my Bills have a custom field that links to the Journal that they are associated with, is there a way in my saved search to get data off that Bill? Bill points to Journal, Journal does not point to Bill.
m
I have found that with 'record is parent' custom fields where the parent and child records are of the same type, in searches you can only get from the parent to the child, not the other way around. It's a rather disappointing limitation, especially for transactions since that's such a broad 'type', but it seems to be consistent at least.
j
yeah
that’s what I figured
m
I think I wrote that backwards (I flipped child and parent for the limitation), but it seems like you figured out what I meant. It's rather frustrating when trying to do something like seeing all parent records with a count of their children, especially if some parents might have 0 children - starting at the child precludes seeing parents without any children.
I was hoping that SuiteAnalytics might open up options on that front but so far I haven't found anything promising. Maybe SuiteQL does, but I have yet to dig into that at all.
n
For this limitation I usually add a new custom field on the Journal and update that by script when there is a Bill linked to the journal. That allows you to report the way you want.