Re: [SL] General Ledger Transaction Listing

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

Max
Thx for your suggestion.
Regretably, that existing report is not quite adequate. 
David J


> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> 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
> >
> > -David J
> >
> >