terry,
run the previous month report and save it to get the ending figures from
that month.

Our technical support system is best staffed by those who can help with this
question, please see the FAQ search and support ticket system for help on
this issue:

http://support.FLEXquarters.com

thanks

Brad Waddell
Product Manager, QODBC the ODBC Driver for QuickBooks
www.QODBC.com


On Sat, Jun 13, 2009 at 4:08 PM, twarwick1 <Terry@...> wrote:

>
>
> 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
>
>
>



--
Brad Waddell, Managing Director
FLEXquarters.com Limited
Skype: bradwww


[Non-text portions of this message have been removed]