Hey all! I'm trying to query a customer payment and I need to get the account where the payment has already been deposited to (picture attached). I don't think we have access to it. Does anyone know if is it possible to get it? Thanks in advance

It's stored in the transactionline table, e.g.

SELECT expenseaccount FROM transactionline WHERE transaction = <Transaction Internal ID> and mainline = 'T'

I did try that before but got the

Unknown identifier 'expenseaccount'.

error

Hmm that query worked in my account. You can try looking at transactionaccountingline table

Is there any feature/preference that needs to be enabled to expose the

expenseaccount

field?