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

[Ledger-smb-users] Need GL query

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