sql-ledger-users

Re: Is it possible to make subaccounts in chart of accounts ?

[Peter D. <mer...@ma...>]

I don't think so. I've got the same problem.
Maybe somebody got some ideas on this subject.
Peter
----- Original Message -----
From: Alexander Govoruschenko <ga...@fo...>
Date: Thu, 14 Mar 2002 18:52:57 +0200 
To: sql...@li...
Subject: Is it possible to make subaccounts in chart of accounts ?


> Is it possible to make subj ?
> NOT accounts under headers, real subaccounts.
> -- 
> WBR, GAV.
> 
> 

-- 

_______________________________________________
Sign-up for your own FREE Personalized E-mail at Mail.com
http://www.mail.com/?sr=signup

Travelocity.com is giving away two million travel miles.
http://ad.doubleclick.net/clk;3969773;6991039;g?http://svc.travelocity.com/promos/millionmiles_main/0,,TRAVELOCITY,00.html

Re: Is it possible to make subaccounts in chart of accounts ?

[Peter D. <mer...@ma...>]

It wasn't very productive adwise.
Peter
----- Original Message -----
From: Nique Naque <ne...@ta...>
Date: Fri, 15 Mar 2002 22:42:15 +1100 
To: "Peter Dabrowski" <mer...@ma...>
Subject: Re: Is it possible to make subaccounts in chart of accounts ?


> On Fri, 15 Mar 2002, you wrote:
> > I don't think so. I've got the same problem.
> > Maybe somebody got some ideas on this subject.
> > Peter
> > ----- Original Message -----
> > From: Alexander Govoruschenko <ga...@fo...>
> > Date: Thu, 14 Mar 2002 18:52:57 +0200
> > To: sql...@li...
> > Subject: Is it possible to make subaccounts in chart of accounts ?
> >
> > > Is it possible to make subj ?
> > > NOT accounts under headers, real subaccounts.
> > > --
> > > WBR, GAV.
> 
> 
> Anything is possible - you just have to have the will to make it happen!
> 
> Nicholas Tomlin
> 
> 

-- 

_______________________________________________
Sign-up for your own FREE Personalized E-mail at Mail.com
http://www.mail.com/?sr=signup

Travelocity.com is giving away two million travel miles.
http://ad.doubleclick.net/clk;3969773;6991039;g?http://svc.travelocity.com/promos/millionmiles_main/0,,TRAVELOCITY,00.html

Re: Is it possible to make subaccounts in chart of accounts ?

[Peter D. <mer...@ma...>]

Hi Dieter'
Excelent.
My accounts are stractured in this way.
Do you recon I shuld put more digits.
below is example of my structure.
3000 (this is my header account)
 3100
  3110
  3120
 3200
  3210
   3211
   3212
  3220
   3221
   3222
   3223 etc
I would like to have them called in Balance sheet and other reports.
I've got other complications.
I follow recomended by polish laws account structures. COA was easy to setup. Problems starting with Balance Sheet report.
For example, say accounts in group 3000
have to be shown on the beginning of report before accounts group 1000.
It would be a chance in GL reports to select(code in the tamplate)certain groups of accounts to appear in chosen place?
Peter

----- Original Message -----
From: Dieter Simader <dsi...@sq...>
Date: Fri, 15 Mar 2002 09:46:49 -0700 (MST) 
To: Alexander Govoruschenko <ga...@fo...>
Subject: Re: Is it possible to make subaccounts in chart of accounts ?


> Accounts are ordered by account number. This is a number. To simulate sub
> accounts enter accounts this way.
> 
> 100010000   bank accounts
> 100010100   bank west
> 100010110   checking
> 100010120   savings
> 100010200   bank east
> 100010210   checking
> 100010220   savings
> 
> I'll be adding an account range report on the GL reports. This is about
> the same as subaccount report sans totals.
> 
> 
> 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 Thu, 14 Mar 2002, Alexander Govoruschenko wrote:
> 
> > Is it possible to make subj ?
> > NOT accounts under headers, real subaccounts.
> > 
> 
> 
> 

-- 

_______________________________________________
Sign-up for your own FREE Personalized E-mail at Mail.com
http://www.mail.com/?sr=signup

Travelocity.com is giving away two million travel miles.
http://ad.doubleclick.net/clk;3969773;6991039;g?http://svc.travelocity.com/promos/millionmiles_main/0,,TRAVELOCITY,00.html

Re: Is it possible to make subaccounts in chart of accounts ?

[Steve D. <sd...@sw...>]

Hi Peter.


This is why I wrote that csv file dump.

I find that dumping the trial balance into a csv and doing your reports in a spreadsheet let's you handle situations like
below easily.  You can automate most of it with macros.

As far as numbering goes, it's a good idea to leave yourself room for the future.

You can multiply your acct numbers by 10 with (Dieter's tip):

update chart set accno = accno * 10;

Good luck.
Steve

Peter Dabrowski wrote:

>
> I would like to have them called in Balance sheet and other reports.
> I've got other complications.
> I follow recomended by polish laws account structures. COA was easy to setup. Problems starting with Balance Sheet report.
> For example, say accounts in group 3000
> have to be shown on the beginning of report before accounts group 1000.
> It would be a chance in GL reports to select(code in the tamplate)certain groups of accounts to appear in chosen place?
> Peter
>
> ----- Original Message -----
> From: Dieter Simader <dsi...@sq...>
> Date: Fri, 15 Mar 2002 09:46:49 -0700 (MST)
> To: Alexander Govoruschenko <ga...@fo...>
> Subject: Re: Is it possible to make subaccounts in chart of accounts ?
>
> > Accounts are ordered by account number. This is a number. To simulate sub
> > accounts enter accounts this way.
> >
> > 100010000   bank accounts
> > 100010100   bank west
> > 100010110   checking
> > 100010120   savings
> > 100010200   bank east
> > 100010210   checking
> > 100010220   savings
> >
> > I'll be adding an account range report on the GL reports. This is about
> > the same as subaccount report sans totals.
> >
> >
> > 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 Thu, 14 Mar 2002, Alexander Govoruschenko wrote:
> >
> > > Is it possible to make subj ?
> > > NOT accounts under headers, real subaccounts.
> > >
> >
> >
> >
>
> --
>
> _______________________________________________
> Sign-up for your own FREE Personalized E-mail at Mail.com
> http://www.mail.com/?sr=signup
>
> Travelocity.com is giving away two million travel miles.
> http://ad.doubleclick.net/clk;3969773;6991039;g?http://svc.travelocity.com/promos/millionmiles_main/0,,TRAVELOCITY,00.html

Re: Is it possible to make subaccounts in chart of accounts ?

[Nique N. <ne...@ta...>]

On Fri, 15 Mar 2002, you wrote:
> I don't think so. I've got the same problem.
> Maybe somebody got some ideas on this subject.
> Peter
> ----- Original Message -----
> From: Alexander Govoruschenko <ga...@fo...>
> Date: Thu, 14 Mar 2002 18:52:57 +0200
> To: sql...@li...
> Subject: Is it possible to make subaccounts in chart of accounts ?
>
> > Is it possible to make subj ?
> > NOT accounts under headers, real subaccounts.
> > --
> > WBR, GAV.


Anything is possible - you just have to have the will to make it happen!

Nicholas Tomlin