Re: [SL] General Ledger Transaction Listing

[Max S. I. I. <ma...@im...>]

-----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
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share 
> your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
> 


-----BEGIN PGP SIGNATURE-----
Version: PGP Desktop 9.0.6 (Build 6060)

iQA/AwUBRVymMqo/0JNz1jAsEQJZGgCg3lld18khOzHThoGRunEt7saJTDgAn2FQ
OHT3HAbc+vwRWBW7e9ck782K
=jj8d
-----END PGP SIGNATURE-----