hi all! does anyone have experience with multi-book accounting transaction searches? i'm trying to pull in the "Payee" for a check but am at a loss
r
RJMNS
10/11/2024, 9:28 PM
If you're starting with a MB Accounting search, join to the Transaction node and one of Name or Main Line Name should work.
a
automation_nation10
10/14/2024, 2:37 PM
thank you! main line name worked
automation_nation10
10/14/2024, 2:40 PM
is there any way to get the internal id of the main line name?
automation_nation10
10/14/2024, 2:40 PM
mainname.id didn't work
r
RJMNS
10/15/2024, 4:37 PM
you need to include the original join so it would be (probably) {transaction.mainname.id}. If that doesn't work, then you might be stuck. Not everything works that way.