-----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" <[EMAIL PROTECTED]> To: <[email protected]> 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 > [email protected] > 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----- ------------------------------------------------------------------------- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
