Does anyone know how to pull the amountremaining field from a record with a query as well as a join to installments from transactions? I have a saved search that uses a join.

search.createColumn({ name: "installmentnumber",join: "installment",})

It's called Amount Unpaid / Unused. On the transaction table and transactionline table you can only get the transaction currency amounts (

foreign*amountunpaid

/*

foreignpaymentamountunused

), If you want the GL amount you need to join to

transactionAccountingLine.

I am late replying, but thanks!