[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Need GL query



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 <..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