Re: [Ledger-smb-users] Need GL query

2010-02-08 Thread Jos Geluk
> From: M Lubratt [Mark Lubratt] > > > 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 f

Re: [Ledger-smb-users] Need GL query

2010-02-06 Thread Chris Travers
On Sat, Feb 6, 2010 at 9:00 PM, M Lubratt wrote: > 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. There are a couple

Re: [Ledger-smb-users] Need GL query

2010-02-06 Thread M Lubratt
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 wrote:

Re: [Ledger-smb-users] Need GL query

2010-02-06 Thread Chris Travers
On Sat, Feb 6, 2010 at 8:44 PM, M Lubratt 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 t