Hello! I was wondering how I can access the lineFi...
# suiteqli
Isis Herrero
11/26/2021, 10:55 AMHello! I was wondering how I can access the lineFields of Transaction? For instance, in a Bill Credit, I’d like to access the grossamt field of a expense line.
j
jen
11/26/2021, 10:57 PMYou need to join to the
transactionlinejen
11/26/2021, 10:58 PMe.g.
SELECT * FROM transactionline WHERE transaction = <id_of_your_bill_credit>m
Mattias Uppström
11/27/2021, 10:37 PMgood to know there is a transactionaccountingline table as well that is needed sometimes
👍 1
i
Isis Herrero
11/29/2021, 6:16 AMThanks! I’ll try that 🙂
2 Views