sql-ledger-users — SQL-Ledger users

RE: problem adding parts

[Don W. <das...@ya...>]

I was thinking the same thing, until I realized that
it would screw up the double entry bookkeeping.  Which
then begs the question how do you put in initial
inventory without messing up the books balanced?  

> Hello

> should the add part form in sql-ledger have boxes >
for LastCost and OnHand?
> currently it does not.

> regards Douglas McNamara



__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/

problem with adding parts

[Dogleg S. <dog...@wo...>]

Hello

	should the add part form in sql-ledger have boxes for LastCost and OnHand?
currently it does not.

	regards Douglas McNamara

another po question

[Dogleg S. <dog...@wo...>]

Hello

	how do I create a purchase order in sql-ledger when the vendor ships
products to the customer for me?

	regards Douglas McNamara

Re: Can i use miniserv

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

Any web server capable of running perl scripts should work.

here is a fix for the zombie processes.

edit dnhttpd.pl

after $SIG{HUP} = \&recompile;

add

$SIG{CHLD} = IGNORE;


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 Mon, 13 Aug 2001, Nicolas Lafferty wrote:

> I was wondering if i can use miniserv to run sql-ledger? I have had numerous
> problems installing sql-ledger and have yet to get it working. dnhttpd.pl
> creates many zombie processes and it was suggested by the admin to look into
> using miniserv.
> 
> Thanks,
> 
> Nick
> 
> 
> 

Can i use miniserv

[Nicolas L. <nla...@pe...>]

I was wondering if i can use miniserv to run sql-ledger? I have had numerous
problems installing sql-ledger and have yet to get it working. dnhttpd.pl
creates many zombie processes and it was suggested by the admin to look into
using miniserv.

Thanks,

Nick

Re: Cash based GST accounting

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

There is nothing for Cash based accounting yet.

It will be an option in version 1.8 to generate reports on a cash basies
or accrual method.


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 Sat, 11 Aug 2001, Mark Williamson wrote:

> Hi,
> 
> I am not sure if I am on the right track, here in Australia we have elected 
> to use a cash based GST accounting.  Is there a way to stop the GST showing 
> up on the current liabilities immediately when a invoice is entered..     the 
> same happens when entering a vendors invoice, is there any simple way of 
> changing this so that the GST only show in the current liabilities when a 
> payment is made or received.
> 
> Cheers
> Mark
> 

Re: newbie question

[Noel C. <NO...@mi...>]

well... that worked ..  I printed the readme off the website which is a
little different to the one in ./sql-ledger/docs

Thanks for the quick response Dieter.

----- Original Message -----
From: "Dieter Simader" <dsi...@sq...>
To: <sql...@li...>
Sent: Saturday, August 11, 2001 10:09 AM
Subject: Re: newbie question


> The README file in the doc section has the right info.
>
> schema scripts are in the sql directory.
>
> to setup the tables
>
> $ psql dbname < acc-Pg.sql
>
>
> 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 Sat, 11 Aug 2001, Noel Cordell wrote:
>
> > Hi,
> >
> > I think I have successfully installed sql ledger and required
> > components.
> >
> > In the readme under SETUP A DATABASE AND THE TABLES there is an
> > instruction to select the Database Administration link.. I don't see
> > that link. I created a user and filled in the relevant information,
> > dbname port etc,  I manually created a database at the command line
that
> > I referenced here.
> >
> > Regarding the tables in the database, do I need to create these
manually
> > too, or does the script do this?
> >
> > Apologies if I am missing something obvious here.
> >
> > Thanks
> >
> > Noel Running Redhat Linux 7.0
> >
> > P.S. Login works fine, but selecting links on the left results in
> > errors.  There are no tables in the database to query, so this is
> > predictable I guess.
> >
> > eg
> > ERROR: Relation 'chart' does not exist SELECT accno, description
FROM
> > chart WHERE link LIKE '%CT_tax%' AND chart.id = tax.chart_id ORDER
BY
> > accno
> >
> >
> >
> >
> >
> >
> >
>
>

Cash based GST accounting

[Mark W. <ma...@ma...>]

Hi,

I am not sure if I am on the right track, here in Australia we have elected 
to use a cash based GST accounting.  Is there a way to stop the GST showing 
up on the current liabilities immediately when a invoice is entered..     the 
same happens when entering a vendors invoice, is there any simple way of 
changing this so that the GST only show in the current liabilities when a 
payment is made or received.

Cheers
Mark
-- 
Cyber Essentials http://cyber.ebbs.com.au
Linux Support and Software
32 Edithvale Rd, Edithvale, Vic 3196
Ph (03) 9774-2657 Fax (03) 9774-2651

Having trouble with pg_password

[Computer S. C. <cs...@fo...>]

Hi

I have been having trouble getting postgress to create the pg_password
entry. each time I try to log in as the user postgress complains of not
finding the pg_-password file or entry. I have tryed the postgress docs and
it is definatly not as clear as creating a MySQl yser.

How do I create this file? any help here would be apreciated.

Shanta McBain
Computer System Consulting
http://webcthelpdesk.com/cgi-bin/CSC/csc.cgi

Re: newbie question

[Kal K. <lan...@cy...>]

Kal Kolberg wrote:

> Instead of login.pl use admin.pl to set up your users, reply back if you
> are
> still having problems.
>
> Lando
>
> Noel Cordell wrote:
>
> > Hi,
> >
> > I think I have successfully installed sql ledger and required
> > components.
> >
> > In the readme under SETUP A DATABASE AND THE TABLES there is an
> > instruction to select the Database Administration link.. I don't see
> > that link. I created a user and filled in the relevant information,
> > dbname port etc,  I manually created a database at the command line that
> > I referenced here.
> >
> > Regarding the tables in the database, do I need to create these manually
> > too, or does the script do this?
> >
> > Apologies if I am missing something obvious here.
> >
> > Thanks
> >
> > Noel Running Redhat Linux 7.0
> >
> > P.S. Login works fine, but selecting links on the left results in
> > errors.  There are no tables in the database to query, so this is
> > predictable I guess.
> >
> > eg
> > ERROR: Relation 'chart' does not exist SELECT accno, description FROM
> > chart WHERE link LIKE '%CT_tax%' AND chart.id = tax.chart_id ORDER BY
> > accno

Re: newbie question

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

The README file in the doc section has the right info.

schema scripts are in the sql directory.

to setup the tables

$ psql dbname < acc-Pg.sql


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 Sat, 11 Aug 2001, Noel Cordell wrote:

> Hi,
> 
> I think I have successfully installed sql ledger and required
> components.
> 
> In the readme under SETUP A DATABASE AND THE TABLES there is an
> instruction to select the Database Administration link.. I don't see
> that link. I created a user and filled in the relevant information,
> dbname port etc,  I manually created a database at the command line that
> I referenced here.
> 
> Regarding the tables in the database, do I need to create these manually
> too, or does the script do this?
> 
> Apologies if I am missing something obvious here.
> 
> Thanks
> 
> Noel Running Redhat Linux 7.0
> 
> P.S. Login works fine, but selecting links on the left results in
> errors.  There are no tables in the database to query, so this is
> predictable I guess.
> 
> eg
> ERROR: Relation 'chart' does not exist SELECT accno, description FROM
> chart WHERE link LIKE '%CT_tax%' AND chart.id = tax.chart_id ORDER BY
> accno
> 
> 
> 
> 
> 
> 
> 

newbie question

[Noel C. <NO...@mi...>]

Hi,

I think I have successfully installed sql ledger and required
components.

In the readme under SETUP A DATABASE AND THE TABLES there is an
instruction to select the Database Administration link.. I don't see
that link. I created a user and filled in the relevant information,
dbname port etc,  I manually created a database at the command line that
I referenced here.

Regarding the tables in the database, do I need to create these manually
too, or does the script do this?

Apologies if I am missing something obvious here.

Thanks

Noel Running Redhat Linux 7.0

P.S. Login works fine, but selecting links on the left results in
errors.  There are no tables in the database to query, so this is
predictable I guess.

eg
ERROR: Relation 'chart' does not exist SELECT accno, description FROM
chart WHERE link LIKE '%CT_tax%' AND chart.id = tax.chart_id ORDER BY
accno

Re: What is $form->{rop} ?

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

Re-Order Point.


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 Fri, 10 Aug 2001, Jim McLaughlin wrote:

> What is the	$form->{rop} ?
> 
> 

What is $form->{rop} ?

[Jim M. <jim...@wo...>]

What is the	$form->{rop} ?

Re: Downloading SQL-Ledger ...

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

John Clark Naldoza y Lopez wrote:

> Try to click on the source code link...;-)

May I suggest that "source code" link would be renamed to "download". I
had to look twice too before I found it. 

--
Martin Lillepuu | E-mail: ma...@li... | GSM: +372 51 56 450

Re: Downloading SQL-Ledger ...

[John C. N. y L. <nj...@nt...>]

"Gregory L. Marx" wrote:
> 
> Hello,
> 
> How does one download SQL-Ledger ???
> On the homepage all I see is a DEMO ...
> 
> I'm supposing since it's GPL'd that it is free for personal use or something like that ...
> All in all I'm very excited to install and test SQL-Ledger ...
> 
> Thanks,
> Greg


Try to click on the source code link...;-)

Or this link if you want to download it right away...;-)

http://www.sql-ledger.org/source/sql-ledger.1.4.13.tgz

It's GPL'd so the source is open for your perusal and comments, and if
you suggests some improvements to the code, you can always contact
dieter


Cheers,


John Clark

-- 
     /) John Clark Naldoza y Lopez                           (\
    / )    Software Design Engineer III                      ( \
  _( (_    _  Web-Application Development                    _) )_
 (((\ \>  /_>    Cable Modem Network Management System <_\  </ /)))
 (\\\\ \_/ /         NEC Telecom Software Phils., Inc.  \ \_/ ////)
  \       /                                              \       /
   \    _/  phone: (+63 32) 233-9142 loc. 3112            \_    /
   /   /  cellphone: (+63 919) 399-4742                     \   \
  /   / email: nj...@nt...                        \   \


"Intelligence is the ability to avoid doing work, yet getting the work
done"
--Linus Torvalds

Downloading SQL-Ledger ...

[Gregory L. M. <Gre...@ve...>]

Hello,

How does one download SQL-Ledger ???
On the homepage all I see is a DEMO ...

I'm supposing since it's GPL'd that it is free for personal use or something like that ...
All in all I'm very excited to install and test SQL-Ledger ...

Thanks,
Greg

Re: SQL errors on Trial Balance

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

The only ORDER BY which doesn't work in 7.1 is the one in a UNION. The
rest work as expected.


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, 9 Aug 2001, Federico Sevilla III wrote:

> On Mon, 6 Aug 2001 at 09:33, Dieter Simader wrote:
> > There are a few more of this type of statement in IR, IS and RP.pm
> 
> I noticed. I didn't change any of them, though (except the one that
> generates the trial balance) because I am not confident with the code
> (yet).
> 
> > The code works on PostgreSQL 7.0 Looks like 7.1 is a bit more picky
> > and doesn't like table identifiers. It's logical though, there can
> > only be one column with one name so the table identifier is redundant,
> > BUT, .......
> 
> You lost me. But? What problems do you foresee if we change all "ORDER BY
> chart.accno" to "ORDER BY accno"? I have not run SQL Ledger in a
> production environment yet: we're still evaluating it and will hopefully
> migrate soon. So I am not familiar with the system yet. Not enough to know
> what changes will open pandora's box, and what will open the gates of
> heaven. ;>
> 
>  --> Jijo
> 
> --
> Federico Sevilla III  :: ji...@le...
> Network Administrator :: The Leather Collection, Inc.
> GnuPG Key: <http://www.leathercollection.ph/jijo.gpg>
> 
> 
> 

Re: Fixing Inventory/Invoicing error

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

You have to remove the item from the invoice setting the qty to zero and
then add the new item. Changing the number alone does not change the
account numbers where to post the item or the ID.


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 Tue, 7 Aug 2001, Ray wrote:

> I managed to enter the wrong part # on a customer invoice and didn't notice
> until after I had posted it.  I then went back to that invoice number and
> changed the part to the correct one and posted it again however my inventory
> didn't get adjusted acordingly.  What do I do now and how do I avoid this in
> the future?
> 
> 

Re: DBD::Pg...what I need?

[Thomas G. <to...@ad...>]

On Wed, 8 Aug 2001, Nicolas Lafferty wrote:

> What if authentication is required by postgres?

Is Pg using host based authentication?  Postgres doesn't require
authentication out of the box, even on redhat where install is
done using canned RPMs.  So if you have it turned on we can
temporarily turn it off and see if this is the snag.

In your data directory (/var/lib/pgsql on redhat) look at your
pg_hba.conf file.  If the only uncommented lines are the last
two then you don't need pg's host based user authentication.
(See man pg_passwd for more info on hba)

BTW, what web browser are you using?  Let's see if you can trap any
error messages.  I'm basically working blind...it would help if we
got one of the players to complain a little bit.

check out /var/lib/pgsql/pg_hba.conf and if it is not using
hba, edit your users/nick.config:

You can use admin.pl to do the same thing, if you prefer.

> > >   dbpasswd => '\'87)T-&%L;```',     #### remove btwn '' 
> > >   dbport => '5432',
> > >   dbtty => '',
> > >   dbuser => 'nick',                 #### same here

--------------------------------------------------------------------
               SVCMC - Center for Behavioral Health                  
--------------------------------------------------------------------
Thomas Good                          tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst                              Phone:  718-354-5528 
Residential Services                            Mobile: 917-282-7359  
--------------------------------------------------------------------
/*           Die Wahrheit Ist Irgendwo Da Draussen...             */
--------------------------------------------------------------------

Re: DBD::Pg...what I need?

[Nicolas L. <nla...@pe...>]

What if authentication is required by postgres?


----- Original Message ----- 
From: "Thomas Good" <to...@ad...>
To: <sql...@li...>
Cc: "Nicolas Lafferty" <nla...@pe...>
Sent: Wednesday, August 08, 2001 11:29 AM
Subject: Re: DBD::Pg...what I need?


> On Wed, 8 Aug 2001, Nicolas Lafferty wrote:
> 
> > This is perl, v5.6.0 built for i386-linux
> 
> Right, so this looks good.  As you're using redhat (I'd guess 7.0 or
> 7.1?) going by the shell prompt, I installed sql-ledger on a redhat 6.1
> box.  dnhttpd ran no problem.  So I looked at your conf file for ledger
> and this is what stuck out:
> 
> >   dbpasswd => '\'87)T-&%L;```',
> >   dbport => '5432',
> >   dbtty => '',
> >   dbuser => 'nick',
> 
> If you don't need to authenticate yourself with Postgres (the 
> default is no) I would try zeroing out these two strings in nick.config. 
> 
> >   dbpasswd => '',
> ...
> ...
> >   dbuser => '',
> 
> run this in char mode on tty1 or in an xterm:
> ./dnhttpd.pl
> 
> This way you can see the stderr...and send me any complaints
> from the server.
> 
> If you have lynx installed on your RH box ---
> Flip to another terminal or start another xterm and run this:
> lynx http://localhost:8000/login.pl
> 
> Else, use netscape to dial up this address.
> (Then flip back to the xterm to see any stderr it spews out.)
> 
> Let's hope this minor hack to nick.config turns the key...
> Good luck!
> 
> --------------------------------------------------------------------
>                SVCMC - Center for Behavioral Health                  
> --------------------------------------------------------------------
> Thomas Good                          tomg@ { admin | q8 } .nrnet.org
> Programmer/Analyst                              Phone:  718-354-5528 
> Residential Services                            Mobile: 917-282-7359  
> --------------------------------------------------------------------
> /*           Die Wahrheit Ist Irgendwo Da Draussen...             */
> --------------------------------------------------------------------
> 
> 
> 

Re: SQL errors on Trial Balance

[Federico S. I. <ji...@le...>]

On Mon, 6 Aug 2001 at 09:33, Dieter Simader wrote:
> There are a few more of this type of statement in IR, IS and RP.pm

I noticed. I didn't change any of them, though (except the one that
generates the trial balance) because I am not confident with the code
(yet).

> The code works on PostgreSQL 7.0 Looks like 7.1 is a bit more picky
> and doesn't like table identifiers. It's logical though, there can
> only be one column with one name so the table identifier is redundant,
> BUT, .......

You lost me. But? What problems do you foresee if we change all "ORDER BY
chart.accno" to "ORDER BY accno"? I have not run SQL Ledger in a
production environment yet: we're still evaluating it and will hopefully
migrate soon. So I am not familiar with the system yet. Not enough to know
what changes will open pandora's box, and what will open the gates of
heaven. ;>

 --> Jijo

--
Federico Sevilla III  :: ji...@le...
Network Administrator :: The Leather Collection, Inc.
GnuPG Key: <http://www.leathercollection.ph/jijo.gpg>

Re: DBD::Pg...what I need?

[Thomas G. <to...@ad...>]

On Wed, 8 Aug 2001, Nicolas Lafferty wrote:

> This is perl, v5.6.0 built for i386-linux

Right, so this looks good.  As you're using redhat (I'd guess 7.0 or
7.1?) going by the shell prompt, I installed sql-ledger on a redhat 6.1
box.  dnhttpd ran no problem.  So I looked at your conf file for ledger
and this is what stuck out:

>   dbpasswd => '\'87)T-&%L;```',
>   dbport => '5432',
>   dbtty => '',
>   dbuser => 'nick',

If you don't need to authenticate yourself with Postgres (the 
default is no) I would try zeroing out these two strings in nick.config. 

>   dbpasswd => '',
...
...
>   dbuser => '',

run this in char mode on tty1 or in an xterm:
./dnhttpd.pl

This way you can see the stderr...and send me any complaints
from the server.

If you have lynx installed on your RH box ---
Flip to another terminal or start another xterm and run this:
lynx http://localhost:8000/login.pl

Else, use netscape to dial up this address.
(Then flip back to the xterm to see any stderr it spews out.)

Let's hope this minor hack to nick.config turns the key...
Good luck!

--------------------------------------------------------------------
               SVCMC - Center for Behavioral Health                  
--------------------------------------------------------------------
Thomas Good                          tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst                              Phone:  718-354-5528 
Residential Services                            Mobile: 917-282-7359  
--------------------------------------------------------------------
/*           Die Wahrheit Ist Irgendwo Da Draussen...             */
--------------------------------------------------------------------

Re: DBD::Pg...what I need?

[Nicolas L. <nla...@pe...>]

##### BEGIN PERL-V OUTPUT #######
[nick@storm nick]$ perl -v

This is perl, v5.6.0 built for i386-linux

Copyright 1987-2000, Larry Wall

Perl may be copied only under the terms of either the Artistic License or
the
GNU General Public License, which may be found in the Perl 5.0 source kit.

Complete documentation for Perl, including FAQ lists, should be found on
this system using `man perl' or `perldoc perl'.  If you have access to the
Internet, point your browser at http://www.perl.com/, the Perl Home Page.

[nick@storm nick]$
#### END PERL -V OUTPUT #######


####### nick.config ########
# configuration file for nick

%myconfig = (
  address => '1 Barnard Street\nFrostburg, MD  21532',
  admin => '',
  company => 'Mindset Ventures, Inc.',
  countrycode => '',
  dateformat => '',
  dbconnect => 'dbi:Pg:dbname=nick;host=localhost;port=5432',
  dbdriver => 'Pg',
  dbhost => 'localhost',
  dbname => 'nick',
  dboptions => '',
  dbpasswd => '\'87)T-&%L;```',
  dbport => '5432',
  dbtty => '',
  dbuser => 'nick',
  email => 'ni...@mi...',
  fax => '',
  name => 'Nick Lafferty',
  password => 'nirg6ha6I/5GA',
  printer => '',
  shippingpoint => '',
  signature => '',
  tel => '',
  templates => 'templates/nick',
);

########end



----- Original Message -----
From: "Thomas Good" <to...@ad...>
To: "Nicolas Lafferty" <nla...@pe...>
Cc: <sql...@li...>
Sent: Wednesday, August 08, 2001 8:31 AM
Subject: Re: DBD::Pg...what I need?


> On Tue, 7 Aug 2001, Nicolas Lafferty wrote:
>
> > The Zombie processes is exactly what happens. You seem to know a little
more
> > about describing this problem than I. Could you let Dieter know of this
> > problem?
> >
> > Thanks,
> > Nick
>
> Hey Nick -  Sorry for the delays...Dieter and I are working overtime
> on an oracle port of sql-ledger and I am swamped to begin with...but:
> I think you and I have this licked.  Did you see my second post?
> If you send me your nick.config (mainly the fields you completed in
> admin.pl) I think we can get you going today.  I can also send my
> conf files and hacked version of dnhttpd.pl to get you going if need be.
>
> BTW, please send output of 'perl -v' too...this problem appears specific
> to which perl version one is running.  I had problems with 5.004 but
> 5.6.1 ran fine.  (Incidentally, there isn't that big of a disparity btwn
> versions, they changed the version string at 5.006 just to keep things
> interesting.  ;-)
>
> Cheers,
> Tom
>
> --------------------------------------------------------------------
>                SVCMC - Center for Behavioral Health
> --------------------------------------------------------------------
> Thomas Good                          tomg@ { admin | q8 } .nrnet.org
> Programmer/Analyst                              Phone:  718-354-5528
> Residential Services                            Mobile: 917-282-7359
> --------------------------------------------------------------------
> /*           Die Wahrheit Ist Irgendwo Da Draussen...             */
> --------------------------------------------------------------------
>
>

Re: DBD::Pg...what I need?

[Thomas G. <to...@ad...>]

On Tue, 7 Aug 2001, Nicolas Lafferty wrote:

> The Zombie processes is exactly what happens. You seem to know a little more
> about describing this problem than I. Could you let Dieter know of this
> problem?
> 
> Thanks,
> Nick

Hey Nick -  Sorry for the delays...Dieter and I are working overtime 
on an oracle port of sql-ledger and I am swamped to begin with...but:
I think you and I have this licked.  Did you see my second post?  
If you send me your nick.config (mainly the fields you completed in 
admin.pl) I think we can get you going today.  I can also send my
conf files and hacked version of dnhttpd.pl to get you going if need be.

BTW, please send output of 'perl -v' too...this problem appears specific
to which perl version one is running.  I had problems with 5.004 but
5.6.1 ran fine.  (Incidentally, there isn't that big of a disparity btwn
versions, they changed the version string at 5.006 just to keep things
interesting.  ;-)

Cheers,
Tom

--------------------------------------------------------------------
               SVCMC - Center for Behavioral Health                  
--------------------------------------------------------------------
Thomas Good                          tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst                              Phone:  718-354-5528 
Residential Services                            Mobile: 917-282-7359  
--------------------------------------------------------------------
/*           Die Wahrheit Ist Irgendwo Da Draussen...             */
--------------------------------------------------------------------