UK QuickBooks Pro 2008/Visual Basic 6 and Access 2003


Hi,

I am running the "sp_report Txn List By Customer" in VB6 to create a list of
monthly statements but need to find the outstanding balance as of the end of the
previous month to show on the statement. (This shows on the menu way to create
Statements in QuickBooks so need to replicate this.) As far as I can see, this
information is not contained in any field in the columns for this sp_report.
From little knowledge and a little digging I can probably calculate the
outstanding balance from taking all (previous outstanding) Invoice's and finding
which ones have been paid by matching them to the InvoiceLineTxn. Finally to my
question: does anyone know if the outstanding balance figure is stored in the
QuickBooks tables and where? Thank you for your help.

Terry