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