sql-ledger-users — SQL-Ledger users

[SQL-Ledger-users] Open Source Enterprise Software

[Ron P. <rp...@bo...>]

Here is something that will probably interest the people on this list.
Would sql-ledger fit in there?
Ron

>...the GNU Enterprise project (www.gnue.org) A GNU project
>which aims to develop a set of tools to build programs that together will
>form a complete system to provide functionality for most business needs.

Re: [SQL-Ledger-users] evaluation of sql-ledger

[Craig J. <cr...@sm...>]

Hi Matthew

I am currently developing a seperate app to use on Wyse Terminal's as a =

frontend to SQL-Ledger. Ultimatley (The way I see it) SQL-Ledger is=20
simply a frontend to the postgresSQL database.

So writing another type of Frontend should not really pose too much of a=
=20
problem. The linux console scripts I am putting together for my own=20
business simply write to the same database and tables. The only thing=20
that's really different is the user interface.

So I don't see why you couldn't do it from another application. The test=
s=20
I've come up with on my consoles appear to work and I havn't noticed any=
=20
problems with SQL-Ledger itself after using the console app.

For those of you on this list interested in a Console application, I wil=
l=20
be releasing it as soon as I feel comfortable with it's performance.

Hope that helps out a little.

Regards
  Craig Jansen (CeeJay Computer Services)
  PH: +64 21 144 1851    FAX: 64 6 323 2060
  http://www.cjcs.yi.org

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

> 2. Can anyone, maybe Dieter, comment on integrating sql-ledger with
> front-office software. We are writing a CRM app with PHP / mySQL (but =
may
> change to PostgreSQL) and I need to integrate with an accounting packa=
ge.

> I haven't yet looked under the hood of sql-ledger as we don't have
> postgresSQL installed, but am I right in guessing that I'll be able to=
=20
write
> a function to create invoices in sql-ledger from our CRM package ... i=
e=20
from
> outside sql-ledger?

[SQL-Ledger-users] evaluation of sql-ledger

[Matthew R. <ma...@ro...>]

Hi there

I'm evaluating sql-ledger for a company I consult for based in Europe. First
looks are very promising. Providing an open-source package is a great
service. Thanks.

Questions

1. Is anyone using sql-ledger in Europe? Does it meet tax / euro
requirements?
Sorry if this is a basic question but I'm not an accountant.

[I see that there are EU language translations of sql-ledger and users
listed in EU countries so hopefully someone can comment knowledgably!]


2. Can anyone, maybe Dieter, comment on integrating sql-ledger with
front-office software. We are writing a CRM app with PHP / mySQL (but may
change to PostgreSQL) and I need to integrate with an accounting package.

I haven't yet looked under the hood of sql-ledger as we don't have
postgresSQL installed, but am I right in guessing that I'll be able to write
a function to create invoices in sql-ledger from our CRM package ... ie from
outside sql-ledger?

Thanks

- Matthew

---------------------------------------------------------
Matthew Ross
Director
Rossware Ltd
PO Box 11-753, Wellington, New Zealand

phone  +64 4 934 1420
mobile +64 21 211 5310

email    ma...@ro...
website www.netinstruments.com
---------------------------------------------------------

Re: [SQL-Ledger-users] Adding cost of parts

[<ufo...@ea...>]

Thanks so much for your response.  I have been out of town till tonight
and I just got your response.  This is the best accounting solution for
linux I have seen.  Please keep up the good work!

			Thanks,
			    Wes

On Mon, 22 Jan 2001,
Ing. Dieter Simader wrote:

> You could change the ic.cgi to allow for input of the cost.
>
> line 303
> $charge .= qq|<b> |.$locale->text('Last Cost').qq|:</b> <input name=lastcost size=10 value=$form->{lastcost} <b>$myconfig{nativecurr}</b>|;
>
> line 507
> foreach $key (qw/listprice sellprice weight lastcost/) {
>
> line 548
> number, description, listprice, lastcost,
>
> line 553
> '$uid', '$form->{description}', $form->{listprice}, $form->{lastcost},
>
> and add
> lastcost = $form->{lastcost},
> at about line 531
>
>
> 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 Sun, 21 Jan 2001 ufo...@ea... wrote:
>
> > Is there a way to add the cost of a part into the database without
> > actually purchasing it first?
> >
> > 			Thanks,
> > 			    Wes
> >
> > ________________________________________________________________________________
> > >From a different solar system, many many galaxies away...
> >
> >
>
>
>

________________________________________________________________________________
From a different solar system, many many galaxies away...

Re: [SQL-Ledger-users] Cobalt RAQ2

[Fleet T. <fl...@pa...>]

Martin, thank you very much for the advise.  The security issue is my top
priority.  I'm a one-person company; as is my bookkeeper.  SQL-Ledger
solves the issue of me using Linux and him still being under the influence
of "The Evil One."  :)

						- fleet -

At 05:20 1/23/01 +0200, you wrote:
>Fleet Teachout wrote:
>> 
>> Has anyone here set up SQL-Ledger on a Cobalt RAQ2 server for remote
>> access?  If so, any problems, lessons learned, issues, etc.?
>
>not RAQ specific, but here are few ideas for a remote server in general:
>
>- SSL is a must for data confidentiality
>- no (untrusted) users on server with any form of web scripting ability
>(cgi/perl/php/etc..) 
>- storngly consider using apache suexec feature and creating separate
>account for sql-ledger
>
>i think it would be a good idea to rewrite whole sql-ledger
>authentication system before putting it into a public server, but for
>starters even using crypt() instead of plaintext would be a good start..
>plaintext is barely suitable on for a system on small trusted network
>behind firewall but a definite no-no for server with direct Internet
>connection.
>
>--
>Martin Lillepuu | E-mail: mar...@ma... | GSM: 051 56 450
>
>

[SQL-Ledger-users] Re: how to add fields?

[Andre F. M. <and...@te...>]

Many thanks for your answer.
Please, include this very practical how-to guide at your FAQ for helping=
=20
many other newbies.

When I install a new release, does the ct.cgi will be overwritten?
Is it possible to recode the cgi to read an EXTERNAL ASCII TEXT file for=
=20
easy customization, like the language files?
A file that will not be overwritten by new releases.
I imagine a standard file customer_fields.txt (part of released sources)=
=20
and another customer_fields_extras.txt
If the second file does not exists, only the first one is used. If it=20
does exist, BOTH are used.
It will be a LOT more easy than end users tweaking source code. It will =

even open door for a gui customization front end.
For a newbie end user like me, an external and clean text file is much=20
less frightening.
Best Regards.
Andre Felipe


>>>>>>>>>>>>>>>>>> Mensagem anterior <<<<<<<<<<<<<<<<<<

No dia 23/01/01, 18:16:31, "Ing. Dieter Simader" <dsimader@sql-ledger.or=
g>=20
escreveu o seguinte sobre o tema Re: one more translated text / how to a=
dd=20
fields?:


> 1. add the field to the database
> 2. edit ct.cgi and add the field in the section customer_form_header
> i.e

>   <tr>
>     <th align=3Dright>|.$locale->text('New Field').qq|:</th>
>     <td><input name=3Dnew_field size=3D20 maxsize=3D35
> value=3D"$form->{new_field}"></td>
>   </tr>

> 3. in the function save_customer add the field as follows

> ct.cgi line 494
>   # setup array for character fields to be escaped
>   @cflds =3D ("name", "addr1", "addr2", "addr3", "contact", "notes",
>             "shiptoname", "shiptoaddr1", "shiptoaddr2", "shiptoaddr3",=

>             "shiptocontact");

> add the field to the @flds array if it is a character field

> If it is a numeric field add it at line 515

>   # setup array for numeric fields
>   @nflds =3D ("tax1", "tax2", "terms", "creditlimit", "discount");


> Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
> DWS Systems Inc.     Accounting Software       Fax: 478-5281
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D On a clear disk you can seek forever=
 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

> On Tue, 23 Jan 2001, Andre Felipe Machado wrote:

> > Sir:
> > Attached, one more translated text to Brazilian Portuguese (BR).
> >
> > How could I add more fields to , lets say, customer table? What are =
the
> > steps? Should I use PgAccess to do this? And the sql-ledger screens?=

> > Many thanks.
> > Andr=E9 Felipe Machado
> > messages not answered in 2 bussiness days were lost. Please retransm=
it.

Re: [SQL-Ledger-users] Cobalt RAQ2

[Martin L. <mar...@ma...>]

Fleet Teachout wrote:
> 
> Has anyone here set up SQL-Ledger on a Cobalt RAQ2 server for remote
> access?  If so, any problems, lessons learned, issues, etc.?

not RAQ specific, but here are few ideas for a remote server in general:

- SSL is a must for data confidentiality
- no (untrusted) users on server with any form of web scripting ability
(cgi/perl/php/etc..) 
- storngly consider using apache suexec feature and creating separate
account for sql-ledger

i think it would be a good idea to rewrite whole sql-ledger
authentication system before putting it into a public server, but for
starters even using crypt() instead of plaintext would be a good start..
plaintext is barely suitable on for a system on small trusted network
behind firewall but a definite no-no for server with direct Internet
connection.

--
Martin Lillepuu | E-mail: mar...@ma... | GSM: 051 56 450

[SQL-Ledger-users] Cobalt RAQ2

[Fleet T. <fl...@pa...>]

Has anyone here set up SQL-Ledger on a Cobalt RAQ2 server for remote
access?  If so, any problems, lessons learned, issues, etc.?  

Regards,
						- fleet -

Re: [SQL-Ledger-users] Adding cost of parts

[Ing. D. S. <dsi...@sq...>]

You could change the ic.cgi to allow for input of the cost.

line 303
$charge .= qq|<b> |.$locale->text('Last Cost').qq|:</b> <input name=lastcost size=10 value=$form->{lastcost} <b>$myconfig{nativecurr}</b>|;

line 507
foreach $key (qw/listprice sellprice weight lastcost/) {

line 548
number, description, listprice, lastcost,

line 553
'$uid', '$form->{description}', $form->{listprice}, $form->{lastcost},

and add
lastcost = $form->{lastcost},
at about line 531


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 Sun, 21 Jan 2001 ufo...@ea... wrote:

> Is there a way to add the cost of a part into the database without
> actually purchasing it first?
> 
> 			Thanks,
> 			    Wes
> 
> ________________________________________________________________________________
> >From a different solar system, many many galaxies away...
> 
> 

[SQL-Ledger-users] Adding cost of parts

[<ufo...@ea...>]

Is there a way to add the cost of a part into the database without
actually purchasing it first?

			Thanks,
			    Wes

________________________________________________________________________________
From a different solar system, many many galaxies away...

RE: [SQL-Ledger-users] Can sql-ledger work with Oracle?

[Chris L. <cl...@di...>]

It will work with any sql database with minor tweaking...

Chris Lasso
direction inc.
519.894.6514
cl...@di...
www.directionsolutions.com

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...]On Behalf Of
mp...@ma...
Sent: January 10, 2001 4:34 PM
To: sql...@li...
Subject: [SQL-Ledger-users] Can sql-ledger work with Oracle?

Found your project and am very impressed by it.
I'm wondering if anyone has tried using it with an oracle database rather
then postgres?  Should be semi close, but maybe a few things to change.

Scott

[SQL-Ledger-users] Can sql-ledger work with Oracle?

[<mp...@ma...>]

Found your project and am very impressed by it.
I'm wondering if anyone has tried using it with an oracle database rather
then postgres?  Should be semi close, but maybe a few things to change.

Scott

Re: [SQL-Ledger-users] Installation problems

[Paul A. <pau...@pa...>]

yeap,  AddHandler cgi-script .cgi .pl  was rem-out.... thanks a lot!

----- Original Message ----- 
From: OTR Comm <ot...@wi...>
To: <sql...@li...>
Sent: Thursday, January 04, 2001 2:31 AM
Subject: Re: [SQL-Ledger-users] Installation problems


> > Paul Aviles wrote:
> > 
> > Happy New Year to all!
> > 
> > I have been looking for an application like sql-ledger for months and
> > finally I found it today. After installing DBI, DBD via CPAN and Pg
> > from the RH RPMs I created the database, which I called dbtest. I was
> > also run the sql script with psql < bla, bla with out any issues. I am
> > running the plain Apache that comes with RH so I did not compiled
> > Apache nor Perl. My installation directory is
> > /var/www/html/sql-ledger. I believe the Apache user run the httpd
> > daemon in RH 7.0  All .cgi files are chmod 755 and I modified the
> > httpd.conf file to add:
> > 
> > <directory "/var/www/html/sql-ledger>
> >     Options ExecCGI Includes FollowSymLinks
> > </directory>
> 
> I have my apache config files separated into httpd.conf, access.conf,
> and srm.conf
> 
> I use:
> 
> <Directory /path/to/sql-ledger>
> AllowOverride All
> Options All
> </Directory>
> 
> in my access.conf file.
> 
> In my srm.conf file I have:
> 
> # To use CGI scripts:
> AddHandler cgi-script .cgi .pl
> ...
> # AccessFileName: The name of the file to look for in each directory
> # for access control information.
> 
> AccessFileName .htaccess
> 
> In the .htaccess file, you define where the authentication file is
> (usually a .htpasswd file).
> 
> Here is a .htaccess file that I use in my sql-ledger development area:
> 
> AuthUserFile /path/to/sql-ledger/.htpasswd
> AuthGroupFile /dev/null
> AuthName Services
> AuthType Basic
> require valid-user
> 
> These are very basic options/settings for the .htaccess file.  However,
> they are okay for getting started with sql-ledger.  On my secure servers
> and other areas, I have much more precise options/settings that are
> reflected on my httpd.conf file.
> 
> This .htaccess file lives in the /path/to/sql-ledger directory
> 
> chmod it and .htpasswd to 644
> 
> As you can see, it references a file .htpasswd that lives in the same
> directory.
> 
> When I want to add a user to the .htpasswd file, I cd to
> /path/to/sql-ledger.  Then I just give the following command:
> 
> htpasswd .htpasswd username
> 
> Then you are prompted to enter the password for username.  When you
> enter the password, you are prompted again to enter the password for
> verification.
> 
> Pretty simple!  Do a man htpasswd for more info/options on htpasswd.
> 
> Good Luck,
> Murrah Boswell
> 
> > 
> > This is actually a virtual named server, but I don't think that is an
> > issue since everything else is working OK on the server.
> > 
> > Here is the issue, when I go to
> > www.server.com/sql-ledger/admin/setup.cgi I get the plain text. I know
> > Perl is working fine and if I do a perl -c setup.cgi I get an OK.  I
> > do have some other html perl based applications that run fine and the
> > location of perl is the default /usr/bin/perl. Any ideas?
> > 
> > Also, can someone share some light as to how to protect the
> > directories in Apache using the .htaccess and passwd files? Do I need
> > to make modification to the /etc/httpd/conf/httpd.conf files or just
> > by having the files in the directory it will work?
> > 
> > Thanks a lot.
> > 
> > -pa
> 
> 
> 

Re: [SQL-Ledger-users] Installation problems

[OTR C. <ot...@wi...>]

> Paul Aviles wrote:
> 
> Happy New Year to all!
> 
> I have been looking for an application like sql-ledger for months and
> finally I found it today. After installing DBI, DBD via CPAN and Pg
> from the RH RPMs I created the database, which I called dbtest. I was
> also run the sql script with psql < bla, bla with out any issues. I am
> running the plain Apache that comes with RH so I did not compiled
> Apache nor Perl. My installation directory is
> /var/www/html/sql-ledger. I believe the Apache user run the httpd
> daemon in RH 7.0  All .cgi files are chmod 755 and I modified the
> httpd.conf file to add:
> 
> <directory "/var/www/html/sql-ledger>
>     Options ExecCGI Includes FollowSymLinks
> </directory>

I have my apache config files separated into httpd.conf, access.conf,
and srm.conf

I use:

<Directory /path/to/sql-ledger>
AllowOverride All
Options All
</Directory>

in my access.conf file.

In my srm.conf file I have:

# To use CGI scripts:
AddHandler cgi-script .cgi .pl
...
# AccessFileName: The name of the file to look for in each directory
# for access control information.

AccessFileName .htaccess

In the .htaccess file, you define where the authentication file is
(usually a .htpasswd file).

Here is a .htaccess file that I use in my sql-ledger development area:

AuthUserFile /path/to/sql-ledger/.htpasswd
AuthGroupFile /dev/null
AuthName Services
AuthType Basic
require valid-user

These are very basic options/settings for the .htaccess file.  However,
they are okay for getting started with sql-ledger.  On my secure servers
and other areas, I have much more precise options/settings that are
reflected on my httpd.conf file.

This .htaccess file lives in the /path/to/sql-ledger directory

chmod it and .htpasswd to 644

As you can see, it references a file .htpasswd that lives in the same
directory.

When I want to add a user to the .htpasswd file, I cd to
/path/to/sql-ledger.  Then I just give the following command:

htpasswd .htpasswd username

Then you are prompted to enter the password for username.  When you
enter the password, you are prompted again to enter the password for
verification.

Pretty simple!  Do a man htpasswd for more info/options on htpasswd.

Good Luck,
Murrah Boswell

> 
> This is actually a virtual named server, but I don't think that is an
> issue since everything else is working OK on the server.
> 
> Here is the issue, when I go to
> www.server.com/sql-ledger/admin/setup.cgi I get the plain text. I know
> Perl is working fine and if I do a perl -c setup.cgi I get an OK.  I
> do have some other html perl based applications that run fine and the
> location of perl is the default /usr/bin/perl. Any ideas?
> 
> Also, can someone share some light as to how to protect the
> directories in Apache using the .htaccess and passwd files? Do I need
> to make modification to the /etc/httpd/conf/httpd.conf files or just
> by having the files in the directory it will work?
> 
> Thanks a lot.
> 
> -pa

[SQL-Ledger-users] Installation problems

[Paul A. <pau...@pa...>]

Happy New Year to all!

I have been looking for an application like sql-ledger for months and =
finally I found it today. After installing DBI, DBD via CPAN and Pg from =
the RH RPMs I created the database, which I called dbtest. I was also =
run the sql script with psql < bla, bla with out any issues. I am =
running the plain Apache that comes with RH so I did not compiled Apache =
nor Perl. My installation directory is /var/www/html/sql-ledger. I =
believe the Apache user run the httpd daemon in RH 7.0  All .cgi files =
are chmod 755 and I modified the httpd.conf file to add:

<directory "/var/www/html/sql-ledger>
    Options ExecCGI Includes FollowSymLinks
</directory>

This is actually a virtual named server, but I don't think that is an =
issue since everything else is working OK on the server.

Here is the issue, when I go to =
www.server.com/sql-ledger/admin/setup.cgi I get the plain text. I know =
Perl is working fine and if I do a perl -c setup.cgi I get an OK.  I do =
have some other html perl based applications that run fine and the =
location of perl is the default /usr/bin/perl. Any ideas?=20

Also, can someone share some light as to how to protect the directories =
in Apache using the .htaccess and passwd files? Do I need to make =
modification to the /etc/httpd/conf/httpd.conf files or just by having =
the files in the directory it will work?

Thanks a lot.

-pa

Re: [SQL-Ledger-users] [Fwd: installation help !]

[Jacky F. <ja...@5s...>]

Hi Roland,

Mandrake is very similar to Redhat 7.0, Maybe you can try the following
instruction,

Redhat 7.0 Installation instructions
Thanks to Jacky Fang who provided the installation instructions.
Install apache1.3.12-25.i386.rpm
Install perl5.6.0-9.i386.rpm
Install postgresql-7.0.2-17.i386.rpm
Install postgresql-server-7.0.2-17.i386.rpm
Install postgresql-devel-7.0.2-17.i386.rpm (POSTGRES_INCLUDE)
tar xvzf DBI-1.14.tar.gz
cd DBI-1.14
perl Makefile.PL
make
make install
cd ..
tar xvzf DBD-Pg-0.95
cd DBD-Pg-0.95
export POSTGRES_LIB=/usr/lib/pgsql
export POSTGRES_INCLUDE=/usr/include/pgsql
perl Makefile.PL
make
make install
install Sql-ledger

Jacky Fang
http://www.5star.com.tw

----- Original Message -----
From: "root" <pr...@co...>
To: <sql...@sq...>
Sent: Monday, January 01, 2001 12:10 PM
Subject: [SQL-Ledger-users] [Fwd: installation help !]


>
>
> -------- Original Message --------
> Subject: installation help !
> Date: Sun, 31 Dec 2000 21:33:34 -0400
> From: root <pr...@co...>
> To: dsi...@co...
> BCC: pr...@co...
>
> Dear friend:
> I have been trying to install Sql-ledger in my Mandrake 7.2, for a while
> without success, I will appreciate if there any user out there using
> Mandrake 7.2, and could give me a hand.I did follow the readme file and
> everything it is working fine in my system.I do think if someone send me
> instructions step by step as he did in his system (7.2) I may find out
> what am doing wrong.
> Best regards
> Roland

[SQL-Ledger-users] [Fwd: installation help !]

[root <pr...@co...>]

-------- Original Message --------
Subject: installation help !
Date: Sun, 31 Dec 2000 21:33:34 -0400
From: root <pr...@co...>
To: dsi...@co...
BCC: pr...@co...

Dear friend:
I have been trying to install Sql-ledger in my Mandrake 7.2, for a while
without success, I will appreciate if there any user out there using
Mandrake 7.2, and could give me a hand.I did follow the readme file and
everything it is working fine in my system.I do think if someone send me
instructions step by step as he did in his system (7.2) I may find out
what am doing wrong.
Best regards
Roland

[SQL-Ledger-users] idsystem@frantica.com

[Javier R. <ids...@fr...>]

ids...@fr...

Re: [SQL-Ledger-users] Yet Another Chart of Accounts Question

[Wild A. S. <su...@wi...>]

Okay!  I did not know that accounting terms differed from country to
country like this, but I can live with it.

Thanks you for the work on sql-ledger.  I really do believe that it is a
great tool.

Murrah Boswell

D Simader wrote:
> 
> The chart is a sample chart only and should be changed to your preferences
> and terminology you use in your country.
> 
> I have not allowed for such things as yearend procedures or prorated half
> year rule calculations for depreciable assets because every country has
> their own rules. Use a calculator and add a GL entry.
> 
> 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 Wed, 20 Dec 2000, Wild Apache Support wrote:
> 
> > In the chart of accounts, account numbers 1825, 1845 and 5660 are
> > related to amortization.  However, amortization only applies to
> > Intangible Assets (i.e., rights, privileges, competitve advantages,
> > etc.).  Furniture, equipment, vehicles are considered long-term tangible
> > assets and are usually depreciated over the life of the asset.
> >
> > To support this, you need a depreciation expense account and an
> > accumulated depreciation account for each category of long-term tangible
> > asset.  Then the accumulated depreciation accounts are setup as contra
> > accounts.
> >
> > Then the amount recorded in the depreciation expense account for that
> > particular asset is reported in the the Income Statement.  In the
> > balance sheet, you would have an entry that shows the purchase price for
> > the tangible asset minus the accumulated depreciation for the asset.
> >
> > Just some thoughts!
> >
> > Murrah Boswell
> >
> >

Re: [SQL-Ledger-users] Yet Another Chart of Accounts Question

[D S. <dsi...@sq...>]

The chart is a sample chart only and should be changed to your preferences
and terminology you use in your country.

I have not allowed for such things as yearend procedures or prorated half
year rule calculations for depreciable assets because every country has
their own rules. Use a calculator and add a GL entry. 


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 Wed, 20 Dec 2000, Wild Apache Support wrote:

> In the chart of accounts, account numbers 1825, 1845 and 5660 are
> related to amortization.  However, amortization only applies to
> Intangible Assets (i.e., rights, privileges, competitve advantages,
> etc.).  Furniture, equipment, vehicles are considered long-term tangible
> assets and are usually depreciated over the life of the asset.
> 
> To support this, you need a depreciation expense account and an
> accumulated depreciation account for each category of long-term tangible
> asset.  Then the accumulated depreciation accounts are setup as contra
> accounts.
> 
> Then the amount recorded in the depreciation expense account for that
> particular asset is reported in the the Income Statement.  In the
> balance sheet, you would have an entry that shows the purchase price for
> the tangible asset minus the accumulated depreciation for the asset.
> 
> Just some thoughts!
> 
> Murrah Boswell
> 
> 

Re: [SQL-Ledger-users] 'gifi' field in Chart of Accounts

[D S. <dsi...@sq...>]

Yes, there are future plans to use it for financial reports.


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 Wed, 20 Dec 2000, Wild Apache Support wrote:

> Are there any future plans for it or can it be eliminated from the chart
> and code references?
> 
> Murrah Boswell
> 
> D Simader wrote:
> > 
> > GIFI = General Index of Financial Information
> > 
> > It is not used.
> > 
> > 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 Wed, 20 Dec 2000, Wild Apache Support wrote:
> > 
> > > Hello,
> > >
> > > What does the 'gifi' field in the Chart of Accounts stand for?
> > >
> > > How is it used?
> > >
> > > Thanks,
> > > Murrah Boswell
> > >
> > >
> 
> 

[SQL-Ledger-users] Yet Another Chart of Accounts Question

[Wild A. S. <su...@wi...>]

In the chart of accounts, account numbers 1825, 1845 and 5660 are
related to amortization.  However, amortization only applies to
Intangible Assets (i.e., rights, privileges, competitve advantages,
etc.).  Furniture, equipment, vehicles are considered long-term tangible
assets and are usually depreciated over the life of the asset.

To support this, you need a depreciation expense account and an
accumulated depreciation account for each category of long-term tangible
asset.  Then the accumulated depreciation accounts are setup as contra
accounts.

Then the amount recorded in the depreciation expense account for that
particular asset is reported in the the Income Statement.  In the
balance sheet, you would have an entry that shows the purchase price for
the tangible asset minus the accumulated depreciation for the asset.

Just some thoughts!

Murrah Boswell

Re: [SQL-Ledger-users] 'gifi' field in Chart of Accounts

[Wild A. S. <su...@wi...>]

Are there any future plans for it or can it be eliminated from the chart
and code references?

Murrah Boswell

D Simader wrote:
> 
> GIFI = General Index of Financial Information
> 
> It is not used.
> 
> 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 Wed, 20 Dec 2000, Wild Apache Support wrote:
> 
> > Hello,
> >
> > What does the 'gifi' field in the Chart of Accounts stand for?
> >
> > How is it used?
> >
> > Thanks,
> > Murrah Boswell
> >
> >

Re: [SQL-Ledger-users] 'gifi' field in Chart of Accounts

[D S. <dsi...@sq...>]

GIFI = General Index of Financial Information

It is not used.


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 Wed, 20 Dec 2000, Wild Apache Support wrote:

> Hello,
> 
> What does the 'gifi' field in the Chart of Accounts stand for?
> 
> How is it used?
> 
> Thanks,
> Murrah Boswell
> 
> 

Re: [SQL-Ledger-users] Another Chart of Accounts Question

[D S. <dsi...@sq...>]

A = Account
H = Header


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 Wed, 20 Dec 2000, Wild Apache Support wrote:

> Hello again,
> 
> What do the 'A's and 'H's mean under the 'type' field of the Cahrt of
> Accounts?
> 
> Thanks,
> Murrah Boswell
> 
>