Ah-ha! That does work.
The one difference they need is is the account description in addition to
the account number. So, I'm looking for acc_trans.accno || ' - ' ||
acc_trans.description instead of only acc_trans.accno.
Thanks, Chris!
Mark
On Sat, Feb 6, 2010 at 10:52 PM, Chris Travers <chris.trav...@gmail.com>wrote:
> On Sat, Feb 6, 2010 at 8:44 PM, M Lubratt <mplubr...@gmail.com> wrote:
> > Hello!
> > My company's auditor requires our GL entries over 2009 & 2010 in an Excel
> > file. We have over 7,000 entries and I'd like to do this without parsing
> > the HTML file that is output from the GL Report. Can someone please tell
> me
> > where the to find the query for the GL report? Or, if someone could
> please
> > post it here?
>
> What kind of format are you looking for?
>
> Also, you can often cut/paste into Excel from HTML, iirc.
>
> Best Wishes,
> Chris Travers
>
> > Thank you,
> > Mark Lubratt
> >
> ------------------------------------------------------------------------------
> > The Planet: dedicated and managed hosting, cloud storage, colocation
> > Stay online with enterprise data centers and the best network in the
> > business
> > Choose flexible plans and management services without long-term contracts
> > Personal 24x7 support from experience hosting pros just a phone call
> away.
> > http://p.sf.net/sfu/theplanet-com
> > _______________________________________________
> > Ledger-smb-users mailing list
> > Ledger-smb-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> >
> >
>
>
> ------------------------------------------------------------------------------
> The Planet: dedicated and managed hosting, cloud storage, colocation
> Stay online with enterprise data centers and the best network in the
> business
> Choose flexible plans and management services without long-term contracts
> Personal 24x7 support from experience hosting pros just a phone call away.
> http://p.sf.net/sfu/theplanet-com
> _______________________________________________
> Ledger-smb-users mailing list
> Ledger-smb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
