Thanks..... BTW - What does GIFI stand for?
At 01:14 PM 10/14/2002 -0600, you 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]/ 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]/

