Hi All,
With SuiteQL I'm querying the Transaction ...
# suiteqlm
Milcho Dimkov
11/01/2021, 2:21 PMHi All,
With SuiteQL I'm querying the Transaction table but I don't see any pointers to Department or Class.
Any clues?
Thanks!
c
Clay Roper
11/01/2021, 2:33 PMHey Milcho - what I always do when I can't find a field I expect in the transaction table is check to see if that field is in transactionline or transactionaccountline -- 9 out of 9.5 times, it is.
😅 1
m
Milcho Dimkov
11/01/2021, 2:34 PMI like the statistical representation of the probability 😄
Milcho Dimkov
11/01/2021, 2:35 PMOK, @Clay Roper but this should be a header field in my case...
c
Clay Roper
11/01/2021, 2:35 PMIn that case, you could try filtering by transactionline.mainline = 'T'
Clay Roper
11/01/2021, 2:36 PM*edited above to transactionline
m
Milcho Dimkov
11/01/2021, 2:36 PMoh, this is how it works.... OK, I see - I'm new to this - got it!!!!
Milcho Dimkov
11/01/2021, 2:36 PMas in transactionline is not only lines 😄
c
Clay Roper
11/01/2021, 2:46 PMIt does include the main line, which for many (all?) transactions includes what we might consider header fields -- this is similar to how transaction saved searches function
m
Milcho Dimkov
11/01/2021, 2:47 PMyep - now I understand that - thanks a lot for your assistance!! : )
c
Clay Roper
11/01/2021, 2:50 PMAny time! Glad I could help
4 Views