NetSuite SuiteQL A/R and Customer Deposit Fields

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:

Transaction TypesTableFieldMeaning
All TypestransactionLineforeignamountTransaction amount in transaction currency
All TypestransactionAccountingLineamountTransaction amount in GL base currency
InvoicetransactionforeignAmountPaidTotal paid amount, in the transaction currency
InvoicetransactionforeignAmountUnpaidTotal unpaid (open) amount, in the transaction currency
Customer Deposit, Payment, Credit MemotransactionforeignPaymentAmountUnusedTotal unapplied (open) amount in the transaction currency
Customer Deposit, Deposit Application, Payment, Credit MemotransactionforeignPaymentAmountUsedTotal applied amount in the transaction currency
Invoice, Journal EntrytransactionLineforeignAmountPaidTotal paid amount, in the transaction currency (note: JE only if Dr to A/R)
Invoice, Journal EntrytransactionLineforeignAmountUnpaidTotal unpaid amount, in the transaction currency (note: JE only if Dr to A/R)
Customer Deposit, Deposit Application, Payment, Credit Memo, Journal EntrytransactionLineforeignPaymentAmountUsedTotal applied amount in the transaction currency (note: JE only if Cr to A/R)
Customer Deposit, Payment, Credit Memo, Journal EntrytransactionLineforeignPaymentAmountUnusedTotal unapplied (open) amount in the transaction currency (note: JE only if Cr to A/R)
Invoice, Journal EntrytransactionAccountingLineamountPaidThe amount “settled” against a Debit to A/R, in GL base currency (note: JE only if Dr to A/R)
Invoice, Journal EntrytransactionAccountingLineamountUnpaidTotal unpaid amount, in GL base currency (note: JE only if Dr to A/R)
Customer Deposit, Deposit Application, Payment, Credit Memo, Journal EntrytransactionAccountingLinepaymentAmountUsedTotal applied amount in GL base currency (note: JE only if Cr to A/R)
Customer Deposit, Payment, Credit Memo, Journal EntrytransactionAccountingLinepaymentAmountUnusedTotal unapplied (open) amount in GL base currency (note: JE only if Cr to A/R)

Leave a Reply

%d bloggers like this: