sql-ledger-users — SQL-Ledger users

Re: [SQL-Ledger-users] Tax summary

[Adrian B. <ad...@sn...>]

Leo Masciuch wrote:
> 
> This sounds rather odd.  I was under the impression
> that only the USA allows cash accounting for private
> corporations.  Everywhere else requires accrual
> accounting which means that you count the funds
> when accrued, not paid.  Canadian GST (another form
> of VAT) works this way as well.  At least in Canada,
> Dieter's suggestion will yield the correct results.
> 

Yes you are correct, but more correctly in Australia businesses can
elect to operate on cash accounting or accrual, at least as far as the
GST reporting and return to the taxation office.

Thanks for the advice.

Adrian
-- 
Adrian Blake  (MIEEE)
Smart Radio Systems Pty Ltd
26b Bombala St, Cooma, NSW 2630, Australia
Ph 61-2-64525555 Fax 61-2-64524317

Re: [SQL-Ledger-users] New User Install problems on Debian system

[John F. <jf...@au...>]

Ian wrote:
> 
> Actually,
>    Are you just running 'postmaster' or are you running 'postmaster -i'--
> that can make a lot of difference when it comes to postgres...
> 
> Ian
---------------------------------------------------------
Thanks for the tip Ian! I am up and running. I will have to study up on
Postgresql. I am not sure what the difference is. Thanks for the
pointer.
-- 

John Foster

Re: [SQL-Ledger-users] New User Install problems on Debian system

[John F. <jf...@au...>]

Steve Doerr wrote:
> 
> Hi John.
> 
> Check if you can log in through the localhost:
> 
> psql -h localhost -d template1
> 
> or if you have a network (you'll have to look at pg_hba.conf also),
> 
> psql -h "your postgres server ip" -d template1
> 
> If not, check postmaster.init and make sure PGALLOWTCPIP=yes and port=5432
> is uncommented.  If these aren't set, you'll have to restart postgres after
> you change them.
> 
> Also make sure you have the package libdbd-pg-perl installed for dbi/dbd
> (sounds like you're ok here).
> 
> That should do it.
> Steve
-----------------------------------------------------------
Thanks for the tips Steve!! I am up and running. I will have to study
Postgresql in some depth as it is administered quite differently from
MySQL. I have a current project that prohibits a detour into a learning
curve, so your pointers really saved the wear and tear on my hair :-)
-- 

John Foster

RE: [SQL-Ledger-users] Tax summary

[Leo M. <Le...@Ne...>]

This sounds rather odd.  I was under the impression
that only the USA allows cash accounting for private
corporations.  Everywhere else requires accrual 
accounting which means that you count the funds
when accrued, not paid.  Canadian GST (another form
of VAT) works this way as well.  At least in Canada,
Dieter's suggestion will yield the correct results.

Regards,
Leo R Masciuch, M.B.A., P.Eng.
Netryst Corp.
5051 Vantage Cres NW
Calgary, AB  T3A 1X6
Canada
Tel: +1-403-202-5039
Fax: +1-403-202-5038
Le...@Ne...


-----Original Message-----
From: Adrian Blake [mailto:ad...@sn...]
Sent: Wednesday, March 07, 2001 22:45
To: sql...@li...
Subject: Re: [SQL-Ledger-users] Tax summary


Dieter Simader wrote:
> 
> You can produce a report for a specified time period from the 'Accounts
> List', click on your GST account and enter the dates. If you only need a
> total, generate a balance sheet up to the end of the period.
> 
> To see how much income and expenses you have for a 3 month period run off
> an income statement for the period. If you need a detailed list you can
> produce a report for each income and expense account from the 'Accounts
> List'.

OK, this is helpful, but if a payment has not been made in either AP or
AR then it cannot be counted in the GST calculations for that period.
And in my case the numbers are considerable!

Adrian
-- 
Adrian Blake  (MIEEE)
Smart Radio Systems Pty Ltd
26b Bombala St, Cooma, NSW 2630, Australia
Ph 61-2-64525555 Fax 61-2-64524317

RE: [SQL-Ledger-users] New User Install problems on Debian system

[Ian <ia...@in...>]

Actually,
   Are you just running 'postmaster' or are you running 'postmaster -i'--
that can make a lot of difference when it comes to postgres...

Ian

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...]On Behalf Of John
Foster
Sent: Thursday, March 08, 2001 12:30 AM
To: SQL-Ledger SourceForge List
Subject: [SQL-Ledger-users] New User Install problems on Debian system


I have just installed the latest version of SQL-Ledger on my
Debian Woody/Sid system. I keep getting the error "database is offline"
however I am able to login and edit the database from the command line
using the >psql command, and also using Webmin. I noticed that you have
the "Driver=Pg" in your example. This may be correct for my system but I
am not sure. I do have gdbm, db, dbi, odbc, modules for apache, perl,
postgresql, all installed. I am at a loss as to what I am doing wrong. I
simply can not get the scripts to login to the database. I have the
sql-ledger installed in /var/www/sql-ledger. I have created a symlink
from there to /usr/lib/cgi-bin. This is working. I was able to add
myself as a user and followed your example. I must say that I have been
using MySQL for several years, but this is my first attempt to use
Postgresql. I have postgreSQL7.0 installed and boot mesg shows the
postmaster is running. Any tips or pointers would be appreciated.
--

John Foster

Re: [SQL-Ledger-users] New User Install problems on Debian system

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

Hi John.

Check if you can log in through the localhost:

psql -h localhost -d template1

or if you have a network (you'll have to look at pg_hba.conf also),

psql -h "your postgres server ip" -d template1

If not, check postmaster.init and make sure PGALLOWTCPIP=yes and port=5432
is uncommented.  If these aren't set, you'll have to restart postgres after
you change them.

Also make sure you have the package libdbd-pg-perl installed for dbi/dbd
(sounds like you're ok here).

That should do it.
Steve

John Foster wrote:

> I have just installed the latest version of SQL-Ledger on my
> Debian Woody/Sid system. I keep getting the error "database is offline"
> however I am able to login and edit the database from the command line
> using the >psql command, and also using Webmin. I noticed that you have
> the "Driver=Pg" in your example.

The driver is correct.

> This may be correct for my system but I
> am not sure. I do have gdbm, db, dbi, odbc, modules for apache, perl,
> postgresql, all installed. I am at a loss as to what I am doing wrong. I
> simply can not get the scripts to login to the database. I have the
> sql-ledger installed in /var/www/sql-ledger. I have created a symlink
> from there to /usr/lib/cgi-bin. This is working. I was able to add
> myself as a user and followed your example.

Not sure why you could add a user if you can't log in, but try the above.

> I must say that I have been
> using MySQL for several years, but this is my first attempt to use
> Postgresql. I have postgreSQL7.0 installed and boot mesg shows the
> postmaster is running. Any tips or pointers would be appreciated.
> --
>
> John Foster

Re: [SQL-Ledger-users] Tax summary

[Adrian B. <ad...@sn...>]

Dieter Simader wrote:
> 
> You can produce a report for a specified time period from the 'Accounts
> List', click on your GST account and enter the dates. If you only need a
> total, generate a balance sheet up to the end of the period.
> 
> To see how much income and expenses you have for a 3 month period run off
> an income statement for the period. If you need a detailed list you can
> produce a report for each income and expense account from the 'Accounts
> List'.

OK, this is helpful, but if a payment has not been made in either AP or
AR then it cannot be counted in the GST calculations for that period.
And in my case the numbers are considerable!

Adrian
-- 
Adrian Blake  (MIEEE)
Smart Radio Systems Pty Ltd
26b Bombala St, Cooma, NSW 2630, Australia
Ph 61-2-64525555 Fax 61-2-64524317

[SQL-Ledger-users] New User Install problems on Debian system

[John F. <jf...@au...>]

I have just installed the latest version of SQL-Ledger on my
Debian Woody/Sid system. I keep getting the error "database is offline"
however I am able to login and edit the database from the command line
using the >psql command, and also using Webmin. I noticed that you have
the "Driver=Pg" in your example. This may be correct for my system but I
am not sure. I do have gdbm, db, dbi, odbc, modules for apache, perl,
postgresql, all installed. I am at a loss as to what I am doing wrong. I
simply can not get the scripts to login to the database. I have the
sql-ledger installed in /var/www/sql-ledger. I have created a symlink
from there to /usr/lib/cgi-bin. This is working. I was able to add
myself as a user and followed your example. I must say that I have been
using MySQL for several years, but this is my first attempt to use
Postgresql. I have postgreSQL7.0 installed and boot mesg shows the
postmaster is running. Any tips or pointers would be appreciated.
-- 

John Foster

Re: [SQL-Ledger-users] Tax summary

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

You can produce a report for a specified time period from the 'Accounts
List', click on your GST account and enter the dates. If you only need a
total, generate a balance sheet up to the end of the period.

To see how much income and expenses you have for a 3 month period run off
an income statement for the period. If you need a detailed list you can
produce a report for each income and expense account from the 'Accounts
List'.


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, 8 Mar 2001, Adrian Blake wrote:

> A suggestion to create a tax summary report.  
> 
> It would be usefull if a report can be created for any specified time
> period that  details and totals tax paid and tax received. 
> 
> In Australia we have GST, like VAT etc, and businesses must lodge a
> retunt to the tax office at regular intivals, for most it is 3 monthly.
> AN abbility to produce a summary woul be invaluable.
> 
> Deiter, or someone with the skills may like to tackle this task. Need
> more information, ask me...Thanks
> 
> Adrian
> 

[SQL-Ledger-users] Tax summary

[Adrian B. <ad...@sn...>]

A suggestion to create a tax summary report.  

It would be usefull if a report can be created for any specified time
period that  details and totals tax paid and tax received. 

In Australia we have GST, like VAT etc, and businesses must lodge a
retunt to the tax office at regular intivals, for most it is 3 monthly.
AN abbility to produce a summary woul be invaluable.

Deiter, or someone with the skills may like to tackle this task. Need
more information, ask me...Thanks

Adrian
-- 
Adrian Blake  (MIEEE)
Smart Radio Systems Pty Ltd
26b Bombala St, Cooma, NSW 2630, Australia
Ph 61-2-64525555 Fax 61-2-64524317

Re: To Rick [SQL-Ledger-users] 403 Forbidden

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

I got the same problem you had, I would like to know how you
solved it
Regards 
Roland

John Cusick wrote:
> 
> Rick,
> 
> You will probably have to review your directory structure in
> http.conf
> 
> What is it?  on redhat for example, it is home/http/html/
> and all standard
> docs are here - the doc root for the web. If you have it
> located in
> /home/http/sql-ledger/ for example, it is forbidden because
> it is not in
> the document root
> 
> Go to yourconfiguration file for apache, if that's what
> you're using, read
> through it with your directory structure in mind, and you
> should be able
> to fix it.
> 
> Good luck
> 
> JC
> 
> Richard Eicher II wrote:
> 
> > I get a 403 Forbidden when I try to pull up
> > setup.cgi. I have configure the .htaccess and
> > ..htpasswd files. Any one ran into this problem?
> >
> > Thank you for your time,
> > rick
> >
> > __________________________________________________
> > Get personalized email addresses from Yahoo! Mail - only $35
> > a year!  http://personal.mail.yahoo.com/

Re: [SQL-Ledger-users] Slightly off Topic

[Roderick A. A. <raa...@ti...>]

On Mon, 5 Mar 2001, Terry Carney wrote:

Terry,

Thanks for a very excellant plan.  Us non-accountants have a pretty steep
learning curve and with tax season in the US in full swing my normal
channels are _rather_ busy.
   It will get me going in the right direction for now.  After a little
more reading and bothering the accountants I know I should even get prtty
good at this.


> If you plan to do small purchases a lot then you can:
>                  (values are examples. use your own)
> 
>   Create a G/L 'Petty Cash' Asset account.
> 
>   Write a check to 'Petty Cash' for $300.00, cash it and stick
>   the money in a cash box somewhere. 
> 
>   As you need to use it take out what you need and put the receipts
>   (indicate what they are for) and the change back in the box.
>   You should always have $300.00 in cash + receipts.
> 
>   When the actual cash gets low or the end of the month arrives -
>   whichever comes first - total the receipts and write a check for
>   the amount. At this point you should have $300.00 cash again.
> 
>   Enter a journal entry similar to the following assuming total
>   receipts of 275.75 and each expense type totaled.
> 
> 
>    DR Fuel                        60.00
>    DR Office Supplies             40.00
>    DR Misc                          .75
>    DR Casual Labour               25.00
>    DR Drawings                   150.00
> 
>         CR Bank                              275.75
> 
>         To Replenish Petty Cash fund.
> 
> 
> Note that the Petty Cash asset account always has 300.00 in it.
> 
> It's not the only way to do things but it's the one I prefer.
> 
> 
> Terry.
> 
> ---------------------------------------------------------------
> Selterra Communications                      ad...@se...
> ---------------------------------------------------------------
> 
> 

Re: [SQL-Ledger-users] Slightly off Topic

[Terry C. <tc...@se...>]

On Mon, 5 Mar 2001, Roderick A. Anderson wrote:

> 1) Anyone have a suggestion of a good general accounting book that would
> blend well with SQL-Ledger?

Self-Counsel Press used to have some practical books. I don't know
what they have these days.

> 2) (An accounting question) How do you (as in not SQL-Ledger specific)
> enter small purchases - stamps, envelopes, paper, etc.  Do you create
> vendor for each place you buy from?

If you plan to do small purchases a lot then you can:
                 (values are examples. use your own)

  Create a G/L 'Petty Cash' Asset account.

  Write a check to 'Petty Cash' for $300.00, cash it and stick
  the money in a cash box somewhere. 

  As you need to use it take out what you need and put the receipts
  (indicate what they are for) and the change back in the box.
  You should always have $300.00 in cash + receipts.

  When the actual cash gets low or the end of the month arrives -
  whichever comes first - total the receipts and write a check for
  the amount. At this point you should have $300.00 cash again.

  Enter a journal entry similar to the following assuming total
  receipts of 275.75 and each expense type totaled.


   DR Fuel                        60.00
   DR Office Supplies             40.00
   DR Misc                          .75
   DR Casual Labour               25.00
   DR Drawings                   150.00

        CR Bank                              275.75

        To Replenish Petty Cash fund.


Note that the Petty Cash asset account always has 300.00 in it.

It's not the only way to do things but it's the one I prefer.


Terry.

---------------------------------------------------------------
Selterra Communications                      ad...@se...
---------------------------------------------------------------

Re: [SQL-Ledger-users] Slightly off Topic

[Roderick A. A. <raa...@ti...>]

On Mon, 5 Mar 2001, Steve Doerr wrote:

> Hi Rod.
> 
> "Roderick A. Anderson" wrote:
> 
> There is a "for dummies" book, but I don't recommend it because it tries to
> cover too much.

Yes I tend to avoid these too.

> You might look at:
> Accounting Fundamentals by Hoffman & Flashner
> Accounting Principles: Fourth Edition by Kieso & Weygandt
> Accounting Principles by Smith, Keith, and Stephens
> Accounting Procedures by Price
> 
> These have a description and table of contents at barnesandnoble.com and
> are reasonably priced.  Check the descriptions to see which might best meet
> your needs.

Thanks I will.

> You might also check a local college to see what text they are using
> for an introductory accounting course.

I teach part time for the local college and know from experience - for the
nost part - that if it ain't MS is ain't taught.

Best marketing machine around.  And the College pays to do it too. (Down
Rod, down boy!)


Thanks for the ideas,
Rod
-- 

Re: [SQL-Ledger-users] Slightly off Topic

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

Hi Rod.

"Roderick A. Anderson" wrote:

> Two questions.
>
> 1) Anyone have a suggestion of a good general accounting book that would
> blend well with SQL-Ledger?

There is a "for dummies" book, but I don't recommend it because it tries to
cover too much.

You might look at:
Accounting Fundamentals by Hoffman & Flashner
Accounting Principles: Fourth Edition by Kieso & Weygandt
Accounting Principles by Smith, Keith, and Stephens
Accounting Procedures by Price

These have a description and table of contents at barnesandnoble.com and
are reasonably priced.  Check the descriptions to see which might best meet
your needs.  You might also check a local college to see what text they are
using for an introductory accounting course.

>
>
> 2) (An accounting question) How do you (as in not SQL-Ledger specific)
> enter small purchases - stamps, envelopes, paper, etc.  Do you create
> vendor for each place you buy from?

You can just post a journal entry to your checking account (credit) and
office supplies (debit).  Vendors are only necessary when you're booking a
payable.

>
>
> TIA,
> Rod
> --

Re: [SQL-Ledger-users] Slightly off Topic

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

On Mon, 05 Mar 2001, you wrote:
> Two questions.
> 
> 1) Anyone have a suggestion of a good general accounting book that would
> blend well with SQL-Ledger?
> 
> 2) (An accounting question) How do you (as in not SQL-Ledger specific)
> enter small purchases - stamps, envelopes, paper, etc.  Do you create
> vendor for each place you buy from?

Well,

IMHO, write a check to Petty Cash. Cash the check and buy the goodies.

The system that I wrote, not SQL-Ledger, we allow for a Misc Vendor where we
can change the name and address of the payee. We put a user definable limit on
the check. The default is $500.00(USD).

--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] Slightly off Topic

[Roderick A. A. <raa...@ti...>]

Two questions.

1) Anyone have a suggestion of a good general accounting book that would
blend well with SQL-Ledger?

2) (An accounting question) How do you (as in not SQL-Ledger specific)
enter small purchases - stamps, envelopes, paper, etc.  Do you create
vendor for each place you buy from?


TIA,
Rod
-- 

Re: [SQL-Ledger-users] Creating an invoice

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

Rod,

I added the code to the new release as well so you won't have to change
anything the next time around.


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, 1 Mar 2001, Roderick A. Anderson wrote:

> On Thu, 1 Mar 2001, Dieter Simader wrote:
> 
> Dieter,
> 
> You are the greatest.  They both work like charms!!!  And now that I see
> where they needed to go I can fiddle with the code some more.  I was just
> a little lost as to what form called what script etc.
> 
> Will you be making these part of the standard distribution?  Or will I
> need to keep them in my bag of tricks?
> 
> 
> Rod
> 

Re: [SQL-Ledger-users] Creating an invoice

[Roderick A. A. <raa...@ti...>]

On Thu, 1 Mar 2001, Dieter Simader wrote:

Dieter,

You are the greatest.  They both work like charms!!!  And now that I see
where they needed to go I can fiddle with the code some more.  I was just
a little lost as to what form called what script etc.

Will you be making these part of the standard distribution?  Or will I
need to keep them in my bag of tricks?


Rod
-- 
ps.  Once again Open Source software proves itself.  Where else could I
have posted a request like this and had a solution in less then four hours
(and probably less as I was away from the computer for the last 2-1/2
hours.)

Re: [SQL-Ledger-users] Creating an invoice

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

Here is a fix to display the number wether it is a service item or a part

edit is.cgi

change

push(@{ $form->{number} }, qq|$form->{"number_$i"}|);

to

push(@{ $form->{number} }, ($form->{"inventory_accno_$i"}) ? qq|$form->{"number_$i"}| : "");


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 ===========

Re: [SQL-Ledger-users] Creating an invoice

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

edit is.cgi, at line 792 add

push(@{ $form->{runningnumber} }, $i);

in your invoice.html template add a description in the header block and
include the new field in the <%foreach number%> loop

header ------
    <tr bgcolor=000000>
      <th align=right><font color=ffffff>No.</th>
      <th align=left><font color=ffffff>Number</th>

loop -------
<%foreach number%>
   <tr valign=top>
   <td><%runningnumber%></td>
   <td><%number%></td>


As for displaying the part number or not. I'd suggest you include the part
number in your description and remove the <%number%> label from the
invoice form.


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, 1 Mar 2001, Roderick A. Anderson wrote:

> At long last I'm REALLY using SQL-Ledger and getting to like it a lot.
> Where is used to work there was Quickbooks for a short while and the
> Peachtree.  Man what a pain.
> 
> But on to my want/need/desire!  (Isn't that what this list is about? :-)
> 
> I'd like to have a line number generated in the invoice instead of/in
> addition to the part/service number.  Is there a predefined variable for
> this?  Also is there some conditional capability available in the
> templates?  I mostly do service work so the customer isn't interested in
> the service number (I usually itemize by day and type work) but if I sell
> parts I'd like to put the part number in the description field but not if
> it's a service.  I already have to edit each description so thi isn't a
> REAL serious need line the line number is.
> 
> 
> TIA,
> Rod
> 

[SQL-Ledger-users] Creating an invoice

[Roderick A. A. <raa...@ti...>]

At long last I'm REALLY using SQL-Ledger and getting to like it a lot.
Where is used to work there was Quickbooks for a short while and the
Peachtree.  Man what a pain.

But on to my want/need/desire!  (Isn't that what this list is about? :-)

I'd like to have a line number generated in the invoice instead of/in
addition to the part/service number.  Is there a predefined variable for
this?  Also is there some conditional capability available in the
templates?  I mostly do service work so the customer isn't interested in
the service number (I usually itemize by day and type work) but if I sell
parts I'd like to put the part number in the description field but not if
it's a service.  I already have to edit each description so thi isn't a
REAL serious need line the line number is.


TIA,
Rod
-- 

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

[Nikita V. <vin...@ma...>]

Hi all!

Totally agree. This is a good practice. If there is a desire to send all
the stuff it will be more relieble to put it on SourceForge.

--
Nikita

On Thu, 1 Mar 2001, Navneet Karnani wrote:

> Hi,
> 
> I think it would be really nice if you can start a new project on
> SourceForge and check it in there. This will also allow people with the
> right expertise to contribute to making it 100 % complete.
> 
> - Navneet
>

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

[Navneet K. <na...@cy...>]

Hi,

I think it would be really nice if you can start a new project on
SourceForge and check it in there. This will also allow people with the
right expertise to contribute to making it 100 % complete.

- Navneet


> -----Original Message-----
> From: sql...@li...
> [mailto:sql...@li...]On Behalf Of Ted
> Stockwell
> Sent: Thursday, March 01, 2001 07:24
> To: sql...@li...
> Subject: [SQL-Ledger-users] J2EE version of Sql-Ledger looking for a
> home
>
>
> 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] Grouchy-Fuck?

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

Geezo bro,

Yo language skills need to cleanup a bit. LOL !!!

I sent private E-mail to Ted asking for a Tar-Ball as well.

--Hal.

On Wed, 28 Feb 2001, Designer 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:
> 
> 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