Dieter, I think what those people want is a called Kolommenbalans here in Holland. Probably the same or very similar in German. Gives account nr, acount name and six columns:
GL#;GL Name;Opening balance Debet;Opening Balance Credit;Total of Transactions Debet;Total of Transactions Credit ;Ending Balance Debit; Ending Balance Credit. Optional is the idea to flag the ending balance as either P/L (profit and loss) or BS (Balance Sheet). Would be very nice but no REAL hurry: A little work based on the existing reports in any spreadsheet is all it takes. Never killed a bookkeeper yet ;-) By the way, just did a re-install on Redhat 8.0 using your setup.pl and was amazed! This is even bettert than RPM distro and I for one caal SQL-Ledger foolproof: works for me! One glitch: I had to edit pg_hba.conf by hand, any chances of fixing that as well via setup.pl (find, rename to _old and put it the way it works)? Grtz, Paul -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Elizabeth Ziph Sent: Monday, October 14, 2002 9:27 PM To: [EMAIL PROTECTED] Subject: Re: [SL] general comments Dieter, Our accountant was also looking for beginning , ending and running balances for the full g/l report -- complete chart of accounts in one fell swoop for a particular period, too, so i am glad that it is coming later.. i hope sooner than later:) thanks elizabeth On Mon, 2002-10-14 at 15:14, Dieter Simader wrote: > You can drill down into the account which will show you all the > transactions for the account. You can also use the GIFI account to > group accounts into ledgers if you use GIFI codes. You can do the > same through the trial balance. If you also enter dates, the > trasnactions will be limited to the same date range when you drill > down. > > The General Ledger report is a catch-all reporting facility. I realize > it is hard to see all the possibilities at first. i.e check the Income > radio button and include the Account field and your report will be > limited to income accounts. Then you click on the income account and > you got a Sales Journal. You are right, though, there is no beginning > and ending balance and a running balance. These are things which will > come later. > > > Dieter Simader http://www.sql-ledger.org (780) 472-8161 > DWS Systems Inc. Accounting Software Fax: 478-5281 > =========== On a clear disk you can seek forever =========== > > On Mon, 14 Oct 2002, Joseph A. Maffia wrote: > > > > > Dieter, > > > > When you check the "include in report" box for account. It doesn't > > group by account. It merely includes the account number on the > > report. A general ledger would show the beg balance, transactions > > during the period and ending balance - by account in account number > > order. Dieter - I like the program - no need to get snippy. If > > there is some combination of "include in" boxes to check - please > > let me know. We are a small ( 16 people ) accounting firm and would > > love to move to this program but it needs to get up to speed. > > > > > > Thanks, > > > > Joe > > > > > > > > At 11:50 AM 10/14/2002 -0600, Dieter Simader wrote: > > >I guess then you don't know what 'Include in Report' means. > > >Checkmark the 'Account' field and you will all of a sudden have the > > >ability to generate ledgers based on account numbers. BTW, there is > > >other ways to generate this data too, from the COA and from the > > >Trail Balance. > > > > > > > > >Dieter Simader http://www.sql-ledger.org (780) 472-8161 > > >DWS Systems Inc. Accounting Software Fax: 478-5281 > > >=========== On a clear disk you can seek forever =========== > > > > > >On Mon, 14 Oct 2002, Joseph A. Maffia wrote: > > > > > > > > > > > > > > > I am very excited about the potential of SQL-ledger and look > > > > forward to replacing existing acctg packages. As an accountant > > > > familiar with several U.S. accounting packages - I wanted to > > > > throw out some general comments. While I am still new to the > > > > program - I was surprised how poor the general ledger report is. > > > > That is our bible - and it is really a meaningless report. The > > > > general ledger is supposed to report transactions grouped by > > > > account not grouped by transaction source or date. > > > > > > > > Also, the program needs a cash disbursement and cash receipt > > > > journal to enter transactions not tied to a/p and a/r. > > > > > > > > We will continue to use it and look forward to continually > > > > improvements.. > > > > > > > > Thanks, > > > > > > > > Joe > > > > > > > > > > > > > > > > Mr. Joseph A. Maffia, CPA > > > > Rosenzweig & Maffia LLP > > > > 845 Third Ave. #1300 > > > > New York, NY 10022 > > > > 212-980-2470 x16 > > > > 212-980-2177 fax > > > > www.rm-cpa.com > > > > > > > > > > > > > > > > ------------------------------------------------------- > > > > This sf.net email is sponsored by:ThinkGeek > > > > Welcome to geek heaven. > > > > http://thinkgeek.com/sf > > > > ------------------------------------------------------- > > > > (un)subscribe: > > > > http://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > > > Archive: http://www.mail-archive.com/[email protected]/ > > > > > > > > > > > > > > > >------------------------------------------------------- > > >This sf.net email is sponsored by:ThinkGeek > > >Welcome to geek heaven. > > >http://thinkgeek.com/sf > > >------------------------------------------------------- > > >(un)subscribe: > > >http://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > >Archive: http://www.mail-archive.com/[email protected]/ > > > > Mr. Joseph A. Maffia, CPA > > Rosenzweig & Maffia LLP > > 845 Third Ave. #1300 > > New York, NY 10022 > > 212-980-2470 x16 > > 212-980-2177 fax > > www.rm-cpa.com > > > > > > > > ------------------------------------------------------- > > This sf.net email is sponsored by:ThinkGeek > > Welcome to geek heaven. > > http://thinkgeek.com/sf > > ------------------------------------------------------- > > (un)subscribe: > > http://lists.sourceforge.net/lists/listinfo/sql-ledger-users > > Archive: http://www.mail-archive.com/[email protected]/ > > > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > ------------------------------------------------------- > (un)subscribe: > http://lists.sourceforge.net/lists/listinfo/sql-ledger-users > Archive: http://www.mail-archive.com/[email protected]/ -- elizabeth ziph 734.761.4689 www.linuxbox.nu ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf ------------------------------------------------------- (un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users Archive: http://www.mail-archive.com/[email protected]/ ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf ------------------------------------------------------- (un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users Archive: http://www.mail-archive.com/[email protected]/
