yes - we included the sp_reports, and although they are somewhat difficult
to reformat, being report images instead of tables, often they include
information calculated by QuickBooks and not available in the database.
brad

On Sat, Jun 13, 2009 at 10:29 PM, sheaschultze <Shea@...>wrote:

>
>
> I've never seen that figure in a table.
> Perhaps you can run the Aging sp_report as of your end date and capture the
> customers from those results.
> (I have found duplicating the Aging report in SQL and/or VB to be
> surprisingly involved. )
>
> --- In qodbc@yahoogroups.com <qodbc%40yahoogroups.com>, "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]