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]/
