Re: Need GL query

[Chris Travers <..hidden..>]

On Sat, Feb 6, 2010 at 9:00 PM, M Lubratt <..hidden..> 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 tricks here to be aware of:

1)  You can log the sql query in PostgreSQL by:
alter user foo set log_statement = 'all'; (or something like that)

Then you can run the report and pull the query out of the logs.

2)  You could modify the query to include the description.

3)  In psql, you can use \h to generate html, and \o to save as a
file.  If you name the file report.xls, it will open in Excel.


> Thanks, Chris!
> Mark
>
> On Sat, Feb 6, 2010 at 10:52 PM, Chris Travers <..hidden..>
> wrote:
>>
>> On Sat, Feb 6, 2010 at 8:44 PM, M Lubratt <..hidden..> 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
>> > ..hidden..
>> > 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
>> ..hidden..
>> 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
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
>