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 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 paidContinue reading “NetSuite SuiteQL A/R and Customer Deposit Fields”