Ever get confused about which fields do what when creating A/R – oriented SuiteQL reports? Here’s a table that help organize the fields and their meanings:
AI Summary:
A reference table of the SuiteQL fields that expose paid, unpaid, applied, and unapplied amounts for invoices, payments, credit memos, customer deposits, and journal entries, organized by transaction type and database table.
| Transaction Types | Table | Field | Meaning |
|---|---|---|---|
| All Types | transactionLine | foreignamount | Transaction amount in transaction currency |
| All Types | transactionAccountingLine | amount | Transaction amount in GL base currency |
| Invoice | transaction | foreignAmountPaid | Total paid amount, in the transaction currency |
| Invoice | transaction | foreignAmountUnpaid | Total unpaid (open) amount, in the transaction currency |
| Customer Deposit, Payment, Credit Memo | transaction | foreignPaymentAmountUnused | Total unapplied (open) amount in the transaction currency |
| Customer Deposit, Deposit Application, Payment, Credit Memo | transaction | foreignPaymentAmountUsed | Total applied amount in the transaction currency |
| Invoice, Journal Entry | transactionLine | foreignAmountPaid | Total paid amount, in the transaction currency (note: JE only if Dr to A/R) |
| Invoice, Journal Entry | transactionLine | foreignAmountUnpaid | Total unpaid amount, in the transaction currency (note: JE only if Dr to A/R) |
| Customer Deposit, Deposit Application, Payment, Credit Memo, Journal Entry | transactionLine | foreignPaymentAmountUsed | Total applied amount in the transaction currency (note: JE only if Cr to A/R) |
| Customer Deposit, Payment, Credit Memo, Journal Entry | transactionLine | foreignPaymentAmountUnused | Total unapplied (open) amount in the transaction currency (note: JE only if Cr to A/R) |
| Invoice, Journal Entry | transactionAccountingLine | amountPaid | The amount “settled” against a Debit to A/R, in GL base currency (note: JE only if Dr to A/R) |
| Invoice, Journal Entry | transactionAccountingLine | amountUnpaid | Total unpaid amount, in GL base currency (note: JE only if Dr to A/R) |
| Customer Deposit, Deposit Application, Payment, Credit Memo, Journal Entry | transactionAccountingLine | paymentAmountUsed | Total applied amount in GL base currency (note: JE only if Cr to A/R) |
| Customer Deposit, Payment, Credit Memo, Journal Entry | transactionAccountingLine | paymentAmountUnused | Total unapplied (open) amount in GL base currency (note: JE only if Cr to A/R) |
Frequently Asked Questions
Which SuiteQL fields show an invoice’s unpaid balance?
foreignAmountUnpaid on the transaction or transactionLine table shows the open amount in the transaction currency, and amountUnpaid on the transactionAccountingLine table shows it in the GL base currency.
Do these open balance fields work for journal entries?
Only the line-level tables expose them for journal entries, and which field applies depends on whether the journal line debits or credits Accounts Receivable.
