<div>
<div class="content wysiwyg-content">
I am trying to find out if I can pull down invoice notes into a SQL Query, and ultimately to a Smartlist to run reports on notes on Customer and on Receivables Transactions. I expected they would be stored within the Customer Master or the Receivables Transactions, but have not had luck finding this. &nbsp;Can you help me locate where they are stored?
</div>
</div>


I am trying to find out if I can pull down invoice notes into a SQL Query, and ultimately to a Smartlist to run reports on notes on Customer and on Receivables Transactions. I expected they would be stored within the Customer Master or the Receivables Transactions, but have not had luck finding this.  Can you help me locate where they are stored?

How do I retrieve Invoice notes and Customer notes to use with Smartlist?

The tax and financial software topic covers both personal and organizational software, ranging from checkbook managers and tax calculation systems to sophisticated general ledger, accounts receivable and payable, payroll, inventory and planning packages. Two of the most common titles are Quickbooks and Microsoft Dynamics.