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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: