sql-ledger-users — SQL-Ledger users

Re: [SQL-Ledger-users] J2EE version of Sql-Ledger looking for a home

[Hal D. <ha...@fa...>]

On Wed, 28 Feb 2001, you wrote:
> Ted Stockwell wrote:
> > 
> > Hi,
> > 
> > In a nutshell my message is this...I have an 80% complete J2EE  version of
> > SQL-Ledger and I will send the code to anyone that requests it.
> > 
> Dude:
> 
[--SNIP--]

> I'm not an accountant either, but, lack of knowledge is the only reason
> I accept
> coding projects. Hell if I know quite a bit about something, then, I
> usually
> do not want to code on it(I'm basically a middle aged
> grouchy-fuck.........)

Yea, I can vouch for that last comment. He is !! <<GRIN>>

And he is ugly besides.

--Hal. 
===========================================================
Hal Davison		     Internet Petroleum  Gateway
Davison Consulting	       Caldera 2.2.14  eServer
6850 Myakka Valley Tr    PostgreSQL 7.03 - Sun Forte - JAVA
Sarasota, Florida 34241         Phone: (941) 921-6578
http://faams.net	         eFAX: (419) 821-5999
===========================================================

Re: [SQL-Ledger-users] J2EE version of Sql-Ledger looking for a home

[Designer <wir...@ta...>]

Ted Stockwell wrote:
> 
> Hi,
> 
> In a nutshell my message is this...I have an 80% complete J2EE  version of
> SQL-Ledger and I will send the code to anyone that requests it.
> 
Dude:

Sure I'll take a tar-ball. I'll be busy for the next 3 weeks on a
project.

I have been following the SQL-ledger effort for some time, and had told
myself
that inter-operability with JAVA would be a good thing. Don't get me
wrong, I like
perl coding quite a lot, but JAVA brings the ability for all sorts of 
extra functionality.

I'm not an accountant either, but, lack of knowledge is the only reason
I accept
coding projects. Hell if I know quite a bit about something, then, I
usually
do not want to code on it(I'm basically a middle aged
grouchy-fuck.........)

ER what are your intentions/desires with the 80% intellectual property
of a PD port............? (basically I do not care, but, I'm curious to
see
what you value it at)

James



> A few months ago I started creating a J2EE version of SQL-Ledger.  At the
> time I was looking for an open-source office application with a web front
> end for which I would develop a Swing-based front-end.  This was supposed to
> be a demo project for a company that was going to build a Swing-based
> front-end for a major accounting ASP.  This demo was supposed to be used to
> convince the client that a Swing-based front-end would be superior to a
> web-based front-end.  Anyway, the demo never even got close to happening.
> 
> To achieve this my first goal was to rewrite SQL-Ledger to J2EE technology
> (to encapsulate the accounting login in EJBs and make it possible to have
> more than one kind of interface to those EJBs, like a web interface, Swing
> interface, XML interface, etc).
> 
> This first goal, of porting SQL-Ledger and its web interface to J2EE is
> mostly complete, there are still some unfinished sections in the Accounts
> Receivable and Invoices, other than that it mostly works.
> 
> I did this work on my own and hold all the property rights to this code.  I
> do not have the time, nor the inclination, to finish this project so I am
> going to give it to anyone that would like it in the hope that someone will
> be motivated to compete it.  Initially I am willing to help people get
> acquainted with the code.
> 
> I know nothing about accounting really.  I created the EJB components by
> mechanically translating SQL-Ledger's PERL code to Java, so I'm sure there
> are bugs :-).
> 
> Anyway, send me your e-mail address, or the address of somewhere where I can
> park this code, and I will send it to you.
> 
> Regards,
> ted stockwell

[SQL-Ledger-users] J2EE version of Sql-Ledger looking for a home

[Ted S. <emo...@me...>]

Hi,

In a nutshell my message is this...I have an 80% complete J2EE  version of
SQL-Ledger and I will send the code to anyone that requests it.

A few months ago I started creating a J2EE version of SQL-Ledger.  At the
time I was looking for an open-source office application with a web front
end for which I would develop a Swing-based front-end.  This was supposed to
be a demo project for a company that was going to build a Swing-based
front-end for a major accounting ASP.  This demo was supposed to be used to
convince the client that a Swing-based front-end would be superior to a
web-based front-end.  Anyway, the demo never even got close to happening.

To achieve this my first goal was to rewrite SQL-Ledger to J2EE technology
(to encapsulate the accounting login in EJBs and make it possible to have
more than one kind of interface to those EJBs, like a web interface, Swing
interface, XML interface, etc).

This first goal, of porting SQL-Ledger and its web interface to J2EE is
mostly complete, there are still some unfinished sections in the Accounts
Receivable and Invoices, other than that it mostly works.

I did this work on my own and hold all the property rights to this code.  I
do not have the time, nor the inclination, to finish this project so I am
going to give it to anyone that would like it in the hope that someone will
be motivated to compete it.  Initially I am willing to help people get
acquainted with the code.

I know nothing about accounting really.  I created the EJB components by
mechanically translating SQL-Ledger's PERL code to Java, so I'm sure there
are bugs :-).

Anyway, send me your e-mail address, or the address of somewhere where I can
park this code, and I will send it to you.

Regards,
ted stockwell

[SQL-Ledger-users] SQL-Ledger Plugins or Modules

[Sylvain D. <sdu...@we...>]

Are there any modules or plugins that can be added to SQL-Ledger ?

Particularily I would be interested in a module to enable automatic billing
using configurable interval(s) such as daily, weekly, bi-monthly, monthly, etc.

-- 
Sylvain

Re: [SQL-Ledger-users] Re: customer form date field? / date format display

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

You can set the date under Preferences.

Setup -> Preferences

enter the date format in the field "Date Format" to match your SQL
server's dateformat.

You have to do this for every user.

If you want to display/enter the dates in a different format, then the
default
i.e. dd.mm.yyyy enter "dd.mm.yyyy" in the "Date Format" field and enter
'set DateStyle to German' in the "Database Options" field.


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, 28 Feb 2001, Andre Felipe Machado wrote:

> Many Thanks!
> I wrote the code, and added a date format config dd/mm/yyyy using 
> {myconfig}.
> I got it working to ENTERING purchase dates, but when retrieving customer 
> data, it shows yyyy-dd-mm. (at least, a date format)
> What do I have to do?
> Please, a "cake recipe", as I know zero about perl....
> Thanks
> Andre Felipe 
> www.techforce.com.br
> 

[SQL-Ledger-users] Re: customer form date field? / date format display

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

Many Thanks!
I wrote the code, and added a date format config dd/mm/yyyy using=20
{myconfig}.
I got it working to ENTERING purchase dates, but when retrieving custome=
r=20
data, it shows yyyy-dd-mm. (at least, a date format)
What do I have to do?
Please, a "cake recipe", as I know zero about perl....
Thanks
Andre Felipe=20
www.techforce.com.br

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

No dia 26/02/01, 17:33:20, Dieter Simader escreveu o seguinte sobre o=20
tema Re: customer form date field?:


> Hi Andre!

> Add the field to the table
> Add the html code to the customer_form_header

> in the function save_customer at line 509 add

>   # set date to NULL if nothing entered
>   unless ($form->{date}) {
>     $form->{date} =3D "NULL";
>   }

> at line 511 add the field to @cflds


> 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

Re: [SQL-Ledger-users] customer form date field?

[Joe S. O. <jo...@sa...>]

Andre Felipe Machado

Wish I could help, but none of us know Perl here either.  One of the few
languages we don't know.
Sorry I couldn't be of more assistance!

Joe Ussia
Director of Sales
Saved Online Inc
919 Alness Street
Toronto, Ontario
M3J 2J1
CANADA

(416) 907 5314 tel
(416) 907 5325 fax
(416) 616 1363 cell
(416) 600 4703  pager

***************************************************************
"There is nothing like a dream to create the future."
                               Victor Hugo
                               1802-1885
***************************************************************
----- Original Message -----
From: "Andre Felipe Machado" <and...@te...>
To: <sql...@li...>
Cc: <dsi...@sq...>
Sent: Monday, February 26, 2001 11:07 AM
Subject: [SQL-Ledger-users] customer form date field?


Hello,:
How do I include a date field at customer form?
An error msg concerning that it (the one I added) was formatted as int4
instead of date appears....
The others added , text and int, are ok.
Please, a cook recipe, as I know zero about perl. (newbie)
Thanks.
André Felipe

[SQL-Ledger-users] customer form date field?

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

Hello,:
How do I include a date field at customer form?
An error msg concerning that it (the one I added) was formatted as int4 =

instead of date appears....
The others added , text and int, are ok.
Please, a cook recipe, as I know zero about perl. (newbie)
Thanks.
Andr=E9 Felipe=20

Re: [SQL-Ledger-users] DOCUMENTATION

[Mitterwald, H. <mit...@co...>]

Thomas Sawyer wrote:
[..]
> 
> The good news is:
> 
> You don't need this program if you have MS Access. Rather, simply install
> the Postgresql ODBC driver and use Access to File/Export your table to
> the ODBC source. Wooshh...There's your table and all its data. :)

You have to be careful with Access. I used it until I found out that
Access
added an empty row to all tables that used OIDs as primary key. Grmbl. 

Best regards,
   Holger Mitterwald

Re: [SQL-Ledger-users] Re: ODBC , Windows , Linux

[Thomas S. <ps...@on...>]

Check out http://www.postgresql.org/interfaces.html

There's a link to the ODBC driver there.

> Which ODBC driver is installed on the Windoze box for VB?
> 
> --Hal. 

-Tom

__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

Re: [SQL-Ledger-users] Re: ODBC , Windows , Linux

[Hal D. <ha...@fa...>]

On Sat, 17 Feb 2001, you wrote:
> > I noticed that you are using Visual Basic with Postgres .  Do you need
> > the ODBC driver installed on the Windows machine and the Linux
> > server ?
> 
> No. Just on the Windows machine. Install the driver and go to Settings/Control
> Panel to set up the ODBC data source. You can then Link, Import, and
> Export between Access and Postgresql. I'm sure there are limitations.
> I've ran into a couple quarks, like deleting records on a linked table,
> which required me to close and reopen the table afterwards. But it works
> farily well.

Which ODBC driver is installed on the Windoze box for VB?

--Hal. 
===========================================================
Hal Davison		     Internet Petroleum  Gateway
Davison Consulting	       Caldera 2.2.14  eServer
6850 Myakka Valley Tr    PostgreSQL 7.03 - Sun Forte - JAVA
Sarasota, Florida 34241         Phone: (941) 921-6578
http://faams.net	         eFAX: (419) 821-5999
===========================================================

Re: [SQL-Ledger-users] Accounting Links

[Hal D. <ha...@fa...>]

On Sat, 17 Feb 2001, you wrote:
> A reply to myself, if anyone has read this:
> 
> > Also it looks as if you have to use one of the two tax entires for
> > Exempt (i.e. 0%) since there are only two choices, right?
> 
> Not true, simply uncheck the tax boxes in the customers records and they're
> exempt

The way I've done this is based(US Only) on the existance of a sales tax
number. The 'ONLY' way product can be exempt if there is some non-null entry in
our sales tax field and the product being sold is marked as being subject to a
sales or use tax.

--Hal.
 
===========================================================
Hal Davison		     Internet Petroleum  Gateway
Davison Consulting	       Caldera 2.2.14  eServer
6850 Myakka Valley Tr    PostgreSQL 7.03 - Sun Forte - JAVA
Sarasota, Florida 34241         Phone: (941) 921-6578
http://faams.net	         eFAX: (419) 821-5999
===========================================================

[SQL-Ledger-users] Re: ODBC , Windows , Linux

[Thomas S. <ps...@on...>]

> I noticed that you are using Visual Basic with Postgres .  Do you need
> the ODBC driver installed on the Windows machine and the Linux
> server ?

No. Just on the Windows machine. Install the driver and go to Settings/Control
Panel to set up the ODBC data source. You can then Link, Import, and
Export between Access and Postgresql. I'm sure there are limitations.
I've ran into a couple quarks, like deleting records on a linked table,
which required me to close and reopen the table afterwards. But it works
farily well.

-Tom Sawyer

__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

[SQL-Ledger-users] ODBC , Windows , Linux

[rr <emi...@ho...>]

I noticed that you are using Visual Basic with Postgres .  Do you need the
ODBC driver installed on the Windows machine and the Linux server ?

----- Original Message -----
From: Thomas Sawyer <ps...@on...>
To: <sql...@li...>
Sent: Saturday, February 17, 2001 7:06 AM
Subject: Re: [SQL-Ledger-users] DOCUMENTATION


> Anyone interested in the following, read below, I have good news:
>
> > I wrote a Visual Basic program called SQL Post which will take a
Microsoft
> > Access Table and translate it into a set of insert statements and save
> > them to a .sql file. This makes it easy to move Access data to
Postgresql.
> > (That's how I loaded my 25,000+ inventory records!) I upload it to
> > ZDNet
> > so it should be available there is a week or so. If anyone would like
> > a copy of it sooner let me know, I can email attach it to them (it's
> > only 88k in size).
>
> The good news is:
>
> You don't need this program if you have MS Access. Rather, simply install
> the Postgresql ODBC driver and use Access to File/Export your table to
> the ODBC source. Wooshh...There's your table and all its data. :)
>
> Yet my program may be useful in other ways, and I plan to expand it to
> do more and work with other data stores.
>
> -Thomas Sawyer
>
> __________________________________________________
> FREE voicemail, email, and fax...all in one place.
> Sign Up Now! http://www.onebox.com
>
>
>

Re: [SQL-Ledger-users] DOCUMENTATION

[Thomas S. <ps...@on...>]

Anyone interested in the following, read below, I have good news:

> I wrote a Visual Basic program called SQL Post which will take a Microsoft
> Access Table and translate it into a set of insert statements and save
> them to a .sql file. This makes it easy to move Access data to Postgresql.
> (That's how I loaded my 25,000+ inventory records!) I upload it to
> ZDNet
> so it should be available there is a week or so. If anyone would like
> a copy of it sooner let me know, I can email attach it to them (it's
> only 88k in size).

The good news is:

You don't need this program if you have MS Access. Rather, simply install
the Postgresql ODBC driver and use Access to File/Export your table to
the ODBC source. Wooshh...There's your table and all its data. :)

Yet my program may be useful in other ways, and I plan to expand it to
do more and work with other data stores.

-Thomas Sawyer

__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

Re: [SQL-Ledger-users] Database Design?

[Mark T. <ma...@fr...>]

> Yea, I use PgAcess for lite stuff and .sql files for the rest. I want
> to try PHPPgAdmin, but worried about conflicts between PHP and Perl Apache
> modules. Anyone know anything about this? I've only heard some grumblings,
> no specifics.

Should be fine on at least Linux, BSD, Solaris.

On our commercial hosting servers (Linux) we use:
Apache
mod_perl
mod_php
mod_ssl
MySQL

Locally, with the box that runs SQL-Ledger, we use as above plus postgresql with phpPgAdmin 
(and phpMyAdmin).

There are no tricks involved really, just a tried and tested build sequence from clean source each 
time we compile and Apache using only static modules. A lot of problems seem to arise from 
shared libs and Apache DSO configurations. Not that it doen't work, just that there are more 
potential gotch'yas.

Mark

Mark Tiramani
FREDO Internet Services
ma...@fr...

Re: [SQL-Ledger-users] Accounting Links

[Thomas S. <ps...@on...>]

A reply to myself, if anyone has read this:

> Also it looks as if you have to use one of the two tax entires for
> Exempt (i.e. 0%) since there are only two choices, right?

Not true, simply uncheck the tax boxes in the customers records and they're
exempt.

__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

Re: [SQL-Ledger-users] Database Design?

[Jess <je...@pe...>]

I use both under Win2K with apache as cgi's no problems.

Regards Jess

----- Original Message ----- 
From: "Thomas Sawyer" <ps...@on...>
To: <sql...@li...>
Sent: Saturday, 17 February, 2001 2:52 AM
Subject: Re: [SQL-Ledger-users] Database Design?


Yea, I use PgAcess for lite stuff and .sql files for the rest. I want
to try PHPPgAdmin, but worried about conflicts between PHP and Perl Apache
modules. Anyone know anything about this? I've only heard some grumblings,
no specifics.

-- 
Thomas Sawyer
ps...@on... - email
(303) 285-3487 x1594 - voicemail/fax



---- Hal Davison <ha...@fa...> wrote:
> 
> Do many of us use pgaccess to modify and extend our PostgreSQL databases?
> If
> not? then What are you using?
> 
> Well, reading the README file answered one of my nagging question on
> how to
> 'Auto Build' my PostgreSQL database tables and preload some default
> data.
> 
> My current Progress based project has over five-hundered tables with
> only eight
> of which exceed a 35K schema size.
> 
> I was pleased to find in the PostgreSQL documentation the ability to
> create
> fields as array. Really comes in handy for inventory MTD information,
> general ledger bugetary data as well as payroll deductions and earnings
> options
> for employees.
> 
> --Hal. 
> ===========================================================
> Hal Davison      Internet Petroleum  Gateway
> Davison Consulting        Caldera 2.2.14  eServer
> 6850 Myakka Valley Tr    PostgreSQL 7.03 - Sun Forte - JAVA
> Sarasota, Florida 34241         Phone: (941) 921-6578
> http://faams.net          eFAX: (419) 821-5999
> ===========================================================
> 
> 

__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

Re: [SQL-Ledger-users] Long time lurker...

[Designer <wir...@ta...>]

cool beans dude:



James


Hal Davison wrote:
> 
> On Thu, 15 Feb 2001, you wrote:
> > Hal Davison wrote:
> > >
> >
> >
> > Dude,
> >
> > I thought you had given up on this?
> >
> 
> Well kinda, sorta. I still need the experience and the interaction with other
> PostgreSQL Gurus like yourself that have ALL the answers.
> 
> 'Member, I'm just a babe in the woods when it comes to the SQL world..<<GRIN>>
> 
> You can see what we have already done with our Progress implementation of our
> product at http://www.faams.net
> 
> The site if far from finizhed, but it will give you a rather simple overfiew of
> the current deployed product.
> 
> --Hal.
> ==========================================================
> Hal Davison                  Internet Petroleum  Gateway
> Davison Consulting             Caldera 2.2.14  eServer
> 6850 Myakka Valley Tr    PostgreSQL 7.03 - Sun Forte - JAVA
> Sarasota, Florida 34241         Phone: (941) 921-6578
> http://faams.net                 eFAX: (419) 821-5999
> ===========================================================

Re: [SQL-Ledger-users] German Chart of accounts?

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

Hi.  Maybe these English definitions of the categories will help.

Assets - economic resources that will provide future economic benefit=
.
Things that have value or worth.  They can be physical like buildings=
,
inventory (stock in German), or cash, or nonphysical like patents, ac=
counts
receivable, or investments.

Liabilities - economic obligations to give something of value to some=
one
else.  When you buy inventory, you owe someone money for it (accounts
payable).  You owe your employees money for the work they do (wages
payable).  You also owe your government money for taxes (taxes payabl=
e).  If
you borrow money, you owe it to someone else and it is a liability (n=
otes
payable or long term debt).

Equity - basically this is assets minus liabilties.  It includes
increases/decreases in assets without change in liabilities.  For ins=
tance,
if you invest cash in your company or sell stock (shares of securitie=
s, not
inventory), you increase assets but not liabilities.  The equation ab=
ove
forces equity to increase by that amount.

Income - also called revenue or einkommen as it's used here.  It's a
company's sales of goods or services.

Expense - the costs of providing the goods or services that are sold.

All accounts must have one of the five categories associated with it =
for
sql-ledger, or any other accounting software, to work.  The categorie=
s are
the same worldwide.

Usually, accountants have to adjust the chart of accounts for their n=
eeds
with any software, but some different sets of standard accounts can m=
ake
that a lot easier.

Hope that helps,
Steve

Keld J=F8rn Simonsen wrote:

> On Fri, Feb 16, 2001 at 12:59:50PM +0100, Mitterwald, Holger wrote:
> > Once upon a time....
> > ok, I like to get sql-ledger really usable in germany. There are =
some
> > chart of accounts (Kontenrahmen) around here that rather everybod=
y
> > should use.
> > I up to now know the "Industriekontenrahmen" and saw
> > the one from Datev.
> > As Datev is rather commonly used I like to convert it to the sql-=
ledger
> > structure.
> > The datev chart of accounts has a "kontoart" that I think equals =
to
> > the category in sql-ledger.
> > I sorted and counted them (well, my database did it :-) )
> > These are the categories up to now:
> >
> >               art               | count | ledger-category
> > --------------------------------+-------+-----------------
> >  Kursaufwand                    |     1 |
> >  Kursertrag                     |     1 |
> >  Summenvortrag                  |     1 |
> >  Kassenkonto                    |     3 | Q
> >  Erl=F6sschm=E4lerung               |     9 |
> >  Aufwandsschm=E4lerung            |     9 |
> >  Saldovortrag                   |    17 |
> >  Finanzkonto                    |    29 |
> >  Einkauf                        |    47 | L
> >  Eigenkapital                   |    58 | Q
> >  Neutrale Aufwendungen          |    71 |
> >  Statistikkonto (Bestandsgr=F6=DFe) |    73 |
> >  Neutrale Erl=F6se                |    80 |
> >  Verkauf                        |    94 | I
> >  Fremdkapital                   |    96 | L
> >  Anlageverm=F6gen                 |   100 | A
> >  Sonstiges Bilanzkonto          |   108 |
> >  Umlaufverm=F6gen                 |   137 | A? (if A means "Besta=
nd")
> >  Kosten                         |   146 | E
> >
> >
> > categories in sql-ledger
> >   A ... Asset        (Anlage, Bestand?)
> >   L ... Liability    (Verpflichtungen)
> >   Q ... Equity       (Eigenkapital)
> >   I ... Income       (Einkommen?, Ertrag(=3DGewinn)?)
> >   E ... Expense      (Kosten)
> >
> >
> > Comments, extensions, etc?
> > I am not really shure if I have to assign the categories to each =
konto
> > individually.
> > But as I still remember the "Kontenarten" are of the same Type he=
re.
>
> We are doing a similar work in denmark, to generate one or
> more standard charts of accounts. These are different from country
> to country, given different legislations, and also different
> between different types of organizations.
> As sql-ledger is typically good for the lower end of the market,
> we are looking into different account plans for smaller association=
s,
> like linux user groups, and smaller firms like a software company o=
r
> service consultant.
>
> I think Dieter is looking into localization support for this
> in one of the forthcoming revisions.
>
> Keld

Re: [SQL-Ledger-users] Database Design?

[Thomas S. <ps...@on...>]

Yea, I use PgAcess for lite stuff and .sql files for the rest. I want
to try PHPPgAdmin, but worried about conflicts between PHP and Perl Apache
modules. Anyone know anything about this? I've only heard some grumblings,
no specifics.

-- 
Thomas Sawyer
ps...@on... - email
(303) 285-3487 x1594 - voicemail/fax



---- Hal Davison <ha...@fa...> wrote:
> 
> Do many of us use pgaccess to modify and extend our PostgreSQL databases?
> If
> not? then What are you using?
> 
> Well, reading the README file answered one of my nagging question on
> how to
> 'Auto Build' my PostgreSQL database tables and preload some default
> data.
> 
> My current Progress based project has over five-hundered tables with
> only eight
> of which exceed a 35K schema size.
> 
> I was pleased to find in the PostgreSQL documentation the ability to
> create
> fields as array. Really comes in handy for inventory MTD information,
> general ledger bugetary data as well as payroll deductions and earnings
> options
> for employees.
> 
> --Hal. 
> ===========================================================
> Hal Davison		     Internet Petroleum  Gateway
> Davison Consulting	       Caldera 2.2.14  eServer
> 6850 Myakka Valley Tr    PostgreSQL 7.03 - Sun Forte - JAVA
> Sarasota, Florida 34241         Phone: (941) 921-6578
> http://faams.net	         eFAX: (419) 821-5999
> ===========================================================
> 
> 

__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

Re: [SQL-Ledger-users] German Chart of accounts?

[<ke...@dk...>]

On Fri, Feb 16, 2001 at 12:59:50PM +0100, Mitterwald, Holger wrote:
> Once upon a time....
> ok, I like to get sql-ledger really usable in germany. There are some
> chart of accounts (Kontenrahmen) around here that rather everybody
> should use.
> I up to now know the "Industriekontenrahmen" and saw
> the one from Datev.
> As Datev is rather commonly used I like to convert it to the sql-ledger
> structure.
> The datev chart of accounts has a "kontoart" that I think equals to
> the category in sql-ledger.
> I sorted and counted them (well, my database did it :-) )
> These are the categories up to now:
> 
>               art               | count | ledger-category
> --------------------------------+-------+-----------------
>  Kursaufwand                    |     1 |
>  Kursertrag                     |     1 |
>  Summenvortrag                  |     1 |
>  Kassenkonto                    |     3 | Q
>  Erlösschmälerung               |     9 |
>  Aufwandsschmälerung            |     9 |
>  Saldovortrag                   |    17 |
>  Finanzkonto                    |    29 |
>  Einkauf                        |    47 | L
>  Eigenkapital                   |    58 | Q
>  Neutrale Aufwendungen          |    71 |
>  Statistikkonto (Bestandsgröße) |    73 |
>  Neutrale Erlöse                |    80 |
>  Verkauf                        |    94 | I
>  Fremdkapital                   |    96 | L
>  Anlagevermögen                 |   100 | A
>  Sonstiges Bilanzkonto          |   108 |
>  Umlaufvermögen                 |   137 | A? (if A means "Bestand")
>  Kosten                         |   146 | E
> 
> 
> categories in sql-ledger
>   A ... Asset        (Anlage, Bestand?)
>   L ... Liability    (Verpflichtungen)
>   Q ... Equity       (Eigenkapital)
>   I ... Income       (Einkommen?, Ertrag(=Gewinn)?)
>   E ... Expense      (Kosten)
> 
> 
> Comments, extensions, etc?
> I am not really shure if I have to assign the categories to each konto
> individually.
> But as I still remember the "Kontenarten" are of the same Type here.

We are doing a similar work in denmark, to generate one or
more standard charts of accounts. These are different from country
to country, given different legislations, and also different
between different types of organizations. 
As sql-ledger is typically good for the lower end of the market,
we are looking into different account plans for smaller associations, 
like linux user groups, and smaller firms like a software company or
service consultant.

I think Dieter is looking into localization support for this
in one of the forthcoming revisions.

Keld

[SQL-Ledger-users] German Chart of accounts?

[Mitterwald, H. <mit...@co...>]

Once upon a time....
ok, I like to get sql-ledger really usable in germany. There are some
chart of accounts (Kontenrahmen) around here that rather everybody
should use.
I up to now know the "Industriekontenrahmen" and saw
the one from Datev.
As Datev is rather commonly used I like to convert it to the sql-ledger
structure.
The datev chart of accounts has a "kontoart" that I think equals to
the category in sql-ledger.
I sorted and counted them (well, my database did it :-) )
These are the categories up to now:

              art               | count | ledger-category
--------------------------------+-------+-----------------
 Kursaufwand                    |     1 |
 Kursertrag                     |     1 |
 Summenvortrag                  |     1 |
 Kassenkonto                    |     3 | Q
 Erl=F6sschm=E4lerung               |     9 |
 Aufwandsschm=E4lerung            |     9 |
 Saldovortrag                   |    17 |
 Finanzkonto                    |    29 |
 Einkauf                        |    47 | L
 Eigenkapital                   |    58 | Q
 Neutrale Aufwendungen          |    71 |
 Statistikkonto (Bestandsgr=F6=DFe) |    73 |
 Neutrale Erl=F6se                |    80 |
 Verkauf                        |    94 | I
 Fremdkapital                   |    96 | L
 Anlageverm=F6gen                 |   100 | A
 Sonstiges Bilanzkonto          |   108 |
 Umlaufverm=F6gen                 |   137 | A? (if A means "Bestand")
 Kosten                         |   146 | E


categories in sql-ledger
  A ... Asset        (Anlage, Bestand?)
  L ... Liability    (Verpflichtungen)
  Q ... Equity       (Eigenkapital)
  I ... Income       (Einkommen?, Ertrag(=3DGewinn)?)
  E ... Expense      (Kosten)


Comments, extensions, etc?
I am not really shure if I have to assign the categories to each konto
individually.
But as I still remember the "Kontenarten" are of the same Type here.

Best regards,
   Holger

Re: [SQL-Ledger-users] Database Design?

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

Hal Davison wrote:
> 
> Do many of us use pgaccess to modify and extend our PostgreSQL databases? If
> not? then What are you using?

I'm currently using phpPgAdmin -
http://www.greatbridge.org/project/phppgadmin/projdisplay.php
There are also several other postgres administration frontends. You'll
find most of them on http://freshmeat.net 

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

[SQL-Ledger-users] Need technical help?

[Hal D. <ha...@fa...>]

If you need technical PostgreSQL help, subscribe to one or more lists at:

  maj...@po...

--Hal.
 
===========================================================
Hal Davison		     Internet Petroleum  Gateway
Davison Consulting	       Caldera 2.2.14  eServer
6850 Myakka Valley Tr    PostgreSQL 7.03 - Sun Forte - JAVA
Sarasota, Florida 34241         Phone: (941) 921-6578
http://faams.net	         eFAX: (419) 821-5999
===========================================================