From: David J <ja...@in...> - 2006-11-16 21:28:50
|
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 > > > |