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
