Re: [SL] General Ledger Transaction Listing

[David J <ja...@in...>]

Roy
Thx for your suggestions.
While possible, I'm no fan of potentialy error-prone
spreadsheet solutions.
I run accounting systems for use by others, so they need to
be simple and robust.
This weekend I shall grab a copy of Dieter's 2.7 beta and
see what report options have been added.
(Being a paid-up subscriber does have advantages beyond the
user manual! /end of plug.)
Otherwise, yes it shall need a custom solution, perhaps
similar to doctor EL's suggestion.


Dr EL
And thx for those clues too.


Cheers to all
David J


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