Re: [SL] General Ledger Transaction Listing

[R P. <arc...@mt...>]

The only issue i see is sorting the GL report on both account AND on date.
You can only sort on account OR date with the current GL report.

Options:
You could easily copy the GL report into a spreadsheet and then do the double sort.
Or use a direct SQL query via psql like Eberhard's example.

According to the website, the new version will have more report options...maybe the ability to do this report sort format is part of that.

Other than that you can make a feature request at the bottom of this web page
http://www.sql-ledger.org/cgi-bin/nav.pl?page=ahead.html&title=What's%20Ahead

Cheers,
Roy

On Thursday 16 November 2006 11:55 am, Max Schneider, Image Innovation wrote:
> Have you looked at the General Ledger Report? It's "Reports" under the
> "General Ledger" menu; you can select date ranges, types of accounts, and
> details to include.
> 
> 
> Regards,
> 
> Max
> 
> ----- Original Message -----
> From: "David J" <ja...@in...>
> To: <sql...@li...>
> Sent: Thursday, November 16, 2006 1:47 AM
> Subject: [SL] General Ledger Transaction Listing
> 
> 
> > Hi List
> >
> > We're trying to produce a report that would probably be
> > called "GL Transaction list, sorted by account" or similar.
> > Sometimes simply called a "General Ledger listing".
> >
> > Company Auditors (and tax auditors) usually ask for this
> > report.  All GL transactions, within a date range, sorted by
> > account code (or range), and then sorted by date.  Presented
> > nicely, topped and tailed, and printed.
> >
> > Most accounting systems I've ever used have a way of
> > producing such a list, for a range of accounts, and/or for a
> > range of dates.  Importantly, ALL the details of each
> > transaction need to be listed, ie Date, Source, Reference,
> > Memo, Description, Notes, Amount, and account balance.
> > Such a report is fairly standard for any accountant or
> > auditor seeking to confirm entries in the GL system. But we
> > can't quite find how to do this in SQL-L.
> >
> > Can get close by using the Trial Balance (by date range),
> > then click at one account at a time.
> > That produces a list of transactions for a single account,
> > but also there's no full details, memos notes, etc. Have
> > also examined the SQL-L manual without finding how to do
> > this.
> >
> > Has anybody else mastered this ?
> >
> > TIA's
> >