sql-ledger-users — SQL-Ledger users

Install

[Mike <gu...@cc...>]

Hi users,

I just installed sql-ledger and can't pull up admin.pl to get things started.

Installed on RedHat 7.2
Postgres is running.  I followed the install readme and made the changes in 
httpd.conf

The path: /var/www/sql-ledger

Any help to get me started?

ThanX

Mike
CCAINC

Re: starting dnhttpd on login

[<gha...@fr...>]

On Tue, 20 Nov 2001, Ray Aldridge wrote:

> I've just started using sql-ledger as part of my intent to migrate all my 
> business functions to Linux, and I really like it.  It's a lot more sensibly 
> constructed than several accounting packages I've paid actual money for.

I'm sure Dieter will be really happy to hear this.  I'm
glad it's working for you.

> I seem to have everything running and now I'm trying to improve the little 
> things.  I got postgresql to run on reboot without difficulty, but as a Linux 
> ignoramus, I can't figure out how to start dnhttpd on login, so I don't have 
> to do it manually every time I reboot, which I have to do frequently, due to 
> the functions I still haven't migrated to Linux.  I'd guess there's a way to 
> do it with rc.local and I'm hoping someone has a scrap of code they'd part 
> with.  I'm running RH 7.1

Don't worry about not being familiar with Linux.  It will grow on
you.  I don't use Redhat, but if your machine has a rc.local
file, you've done well at investigating things already.  These
"rc" files are used to "run commands" we would normally type
on the command line.  So, if your dnhttpd program is in the
/usr/local/bin directory, and the options (or arguments) you
use to start it manually can be represented by $options, and
rc.local happens to be in /etc/init.d; the following should work.
It probably isn't optimal.

If you are logged in as root, you should be able to edit or append
to the rc.local file.  Assuming you are uncomfortable editing files, 
the following should work.

 echo "\n" >> /etc/init.d/rc.local
 echo "/usr/local/bin/dnhttpd $options" >> /etc/init.d/rc.local
 echo "\n" >> /etc/init.d/rc.local

Using the ">>" redirection/append operator is something to
be careful of.  If you only use a single right angle bracket ">",
you will overwrite the file, instead of appending to it.  Sometimes
these files don't have a "newline" at the end of them, so we are first
appending a newline, then adding the command to start our dnhttpd daemon,
then appending another newline.

I hope this makes some sense.

Gord

starting dnhttpd on login

[Ray A. <pbw...@fw...>]

I've just started using sql-ledger as part of my intent to migrate all my 
business functions to Linux, and I really like it.  It's a lot more sensibly 
constructed than several accounting packages I've paid actual money for.

I seem to have everything running and now I'm trying to improve the little 
things.  I got postgresql to run on reboot without difficulty, but as a Linux 
ignoramus, I can't figure out how to start dnhttpd on login, so I don't have 
to do it manually every time I reboot, which I have to do frequently, due to 
the functions I still haven't migrated to Linux.  I'd guess there's a way to 
do it with rc.local and I'm hoping someone has a scrap of code they'd part 
with.  I'm running RH 7.1

Thanks much

Ray

Re: no login for users

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

On Tue, 20 Nov 2001 ga...@es... wrote:

> Database Administrator: postgres
> Connect To: template1
> 
> postgres is the name of the user who has permissions to use the database.
> I don't know what template1 is, but I think it was created by sql-ledger.

No it isn't.  It is one of two databases used by PostgreSQL and should
not be used unless you _REALLY_ know what you're doing.  In your example
it is OK to connect to it but ***DO NOT*** create the SQL-Ledger files
in that database.  Your example/tutorial is good!


Rod
-- 
                      Let Accuracy Triumph Over Victory

                                                       Zetetic Institute
                                                        "David's Sling"
                                                         Marc Stiegler

Re: GST accounts

[Luca V. <lu...@ye...>]

Jonas Smedegaard wrote:
> 
> On Fri, 16 Nov 2001, Luca Venturini wrote:
> 
> > Ned Lukies wrote:
> > >
> > > Is it possible to seperate the single GST account into to so that I have
> > > an asset GST account for GST paid on purchases and a liability GST account
> > > for GST collected on sales? If so, how?
> 
> > in Italy we use only the two accounts solution. We have to do this way
> > because we have to write two different books, one for sales and the
> > other
> > for purchases. Just modify your accounts list and put the
> > flag AP_tax in the 'GST for purchases' account and the AR_tax in the
> > 'GST for sales' account.
> >
> > What we do is to put this together once pro month in a third account
> > called something like 'GST summary'. Then I go to pay just the
> > sum of this third account.
> 
> Similar (to Italy) in Denmark.
> 
> I have set it up similarly to you, Luca, and it works as expected using
> "Customer Invoice" and "Vendor Invoice", but semi-manual data entry using
> "Add Transaction" defaults to using both GST accounts and you'll need to
> remember deselecting the irrelevant one.

Try to flag only the purchase GST account when you create a new vendor
and only the sell GST account when you create a new customer.

This way "Add Transaction" will default to the relevant accounts.

Luca

Re: no login for users

[<ga...@es...>]

Johan,

I found creating databases confusing also.  Here is what I found.

On the Database Creation Page I have the following:

Database Administrator: postgres
Connect To: template1

postgres is the name of the user who has permissions to use the database.
I don't know what template1 is, but I think it was created by sql-ledger.

I click on Create Database.

Under Existing Databases it lists template0 and template1.  It also lists
some databases I've created outside of sql-ledger as well as inside it.  If
you aren't getting a list of databases here you can assume that sql-ledger
isn't talking to your database software.

Fill in the following

Create Database: test
Create chart of account: default

Click Continue
Click Add User

Login: testuser
Password: ******

UnderDatabase
Name: test
User: postgres

Note, the name is the name of the Database we just created.  The usre is
the user who has access to the database.  This will match the name we used
to create the database.  I assume password is the password for the user.  I
haven't assigned a password so I don't know for sure.

I hope this helps you.

	-Gary


At 10:28 AM 11/20/2001 +0100, Johan van Rijn wrote:
>I think it has something to do how i create the database:
>
>The first window asks me to connect To: (template1)
>What do i connect ??
>
>The next window will let me create database, just an name???
>
>What do i use in the userprofile teh connect name or the database name??
>
>psql keeps telling mee that user johan does not exist Hmmm (acualy nobody
>exists).
>
>
>Johan
>
>
>
>

Re: no login for users

[Johan v. R. <jv...@nl...>]

I think it has something to do how i create the database:

The first window asks me to connect To: (template1)
What do i connect ??

The next window will let me create database, just an name???

What do i use in the userprofile teh connect name or the database name??

psql keeps telling mee that user johan does not exist Hmmm (acualy nobody
exists).


Johan

Re: Vendor Invoices

[Herb R. <he...@bu...>]

On Mon, 19 Nov 2001, Dieter Simader wrote:

> There is a line missing in ir.pl
>
> edit bin/mozilla/ir.pl, after line 95 add
>
>   $form->{$key} = "$ref->{accno}--$ref->{description}";

Can you list a few lines before and after line 95 ?
...this just doesn't look right (ie $key = 'AP_paid' at line 95):

     91   foreach $key (keys %{ $form->{AP_links} }) {
     92     foreach $ref (@{ $form->{AP_links}{$key} }) {
     93       if ($form->{amount}{$ref->{accno}}) {
     94         if ($key eq 'AP_paid') {
     95           $form->{AP_paid} = $form->{amount}{$ref->{accno}};
     96           $form->{$key} = "$ref->{accno}--$ref->{description}";  # added
     97         }
     98       }
     99       $form->{"select$key"} .= "<option>$ref->{accno}--$ref->{description}\n";
    100     }
    101   }

Also is a similiar line needed in is.pl (at about line 129) ?

-- 
Herb Richter,
Toronto, Ontario
http://www.partsandservice.com

Vendor Invoices

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

There is a line missing in ir.pl

edit bin/mozilla/ir.pl, after line 95 add

  $form->{$key} = "$ref->{accno}--$ref->{description}";


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: no login for users

[Johan v. R. <jv...@nl...>]

hello Dieter,

Solved the port problem i still get this message from the httpd:

DBI->connect(dbname=johan;host=localhost;port=5432) failed: connectDBStart() --
connect() failed: Connection refused at SL/User.pm line 119Error: Database is
offline; please try again later
Compilation failed in require at /usr/local/www/sql-ledger/login.pl line 77.

How do i get the database online????

> >
> 
> > Johan van Rijn wrote:
> > -----------
> > Compilation failed in require at /usr/local/www/sql-ledger/admin.pl line 77.
> > DBI->connect(dbname=johan;port=80) failed: connectDBStart() -- connect() failed:
> 
>                            ^^^^^^^^^  wrong port
> 
> > No such file or directory at SL/User.pm line 119
> > Error: Database is offline; please try again later
> > Compilation failed in require at /usr/local/www/sql-ledger/login.pl line 77.
> >
How do i get the database online????
> >
> >

-- 
Johan

Re: Multi payment

[Jonas S. <jo...@jo...>]

On Mon, 19 Nov 2001, roosie wrote:

> Does anyone knows how to 'simulate' a multiple payment entries for
> both the AR and AP ?
>
> The current design seems to allow only 1 time payment.

...and the date of that payment is reset to delivery date if you open and
save the Invoice form, so beware!

What I do currently is avoid the payment part all together. Instead I use
the AR/AP Summary account directly (so that only payment status windows
are wrong, the rest of the accounting is calculated properly). If I want
better tracking for specific customers I use a separate account for that
customer instead.

> If it's not possible, I'm thinking about implementing it myself. ie
> modifying it.
>
> Any help is welcomed.

Please please post diffs to this mailinglist - so that others can choose
to hack their systems similarly, until something is implemented upstream.

I might be of help - pass me your ideas and hacks, and I will take a look.

 - Jonas

-- 
Jonas Smedegaard (+45 40843136)          http://dr.jones.dk/~jonas/
Spiff ApS (= IT-guide dr. Jones ApS)     http://dr.jones.dk/
Debian GNU/Linux developer               http://people.debian.org/~js/

Multi payment

[roosie <ro...@pc...>]

Hi.

Does anyone knows how to 'simulate' a multiple payment entries for both the
AR and AP ?

The current design seems to allow only 1 time payment.

Can't afford to wait for the ver. 1.8

If it's not possible, I'm thinking about implementing it myself. ie
modifying it.

Any help is welcomed.


Thanks.

Document contains no data

[cjs <cj...@pa...>]

I am still lunable to access the database - message when trying to login
is that the document contains no data. 

History - 
	I have installed posgresql 7.0, DBD-PG-0.73, DBI-1.13, and perl 5.6,
with perl modules for DBD-CSV and DBI. Unpacked sql-ledger, and followed
instructions for private installation. Set up dnhtpd, no problem. Set up
postmaster and ran it with -i -D options, no problem (after initdb).
Used createdb to setup database, and set up tables and charts by hand as
per instructions. No problem. Can accesss charts fine using psql. Using
Nestscape. 
	But when I try to login, after setting up user, get message as above.
Also get this message on the dnhttpd log - 

Processing request from 127.etc...
Executing CGI at /hom/cjs/etc..login.pl
install_driver(Pg) failed: Can't locate loadable object for module
DBD::Pg in @INC
(@INC contains: /usr/lib/perl5/5.6.0.i586-linux  /usr/lib/perl5/5.6.0
/usr/lib/per5/site_perl/5.6.0/I586-linux  /usr/lib/perl5/site_perl/5.6.0
/usr/lib/perl5/site_perl  .) at (eval 1) line 3
Compilation failed in require at (eal 1) line 3.
Perhaps a module that DBD::Pg requires hasn't been fully installed at
SL/User.pm
line 119
Compilation failed in require at /home/cjs/etc.../login.pl line 77.

What am I missing? I don't know what other modules to install. Thank
you.

Re: GST accounts

[Jonas S. <jo...@jo...>]

On Fri, 16 Nov 2001, Dieter Simader wrote:

> Tax is only calculated when both match. That is the tax for the
> part/service must be set the same as for the customer/vendor.

True, but (maybe not "wrong" according to current design), making an
account taxable is only a suggestion, not a rule. It is not included in
the above logic of "every part of the transaction has to allow taxation
for it to occur".

Danish accounting practice is to separate taxable and non-taxable
transactions in different accounts - making it possible for the accountant
to cross-check tax calculations using the sum of all taxable accounts.

 - Jonas

P.S.

Just received my accounting back from my accountant today - including my
lowest bill ever for "blessing" it to the danish authorities. Thanks for a
program that is actually working, Dieter :-)

P.P.S.

Not all was working, however, and I am preparing a bugreport and a
wishlist ;-)

-- 
Jonas Smedegaard (+45 40843136)          http://dr.jones.dk/~jonas/
Spiff ApS (= IT-guide dr. Jones ApS)     http://dr.jones.dk/
Debian GNU/Linux developer               http://people.debian.org/~js/

Re: no login for users

[Jonas S. <jo...@jo...>]

On Fri, 16 Nov 2001, Dieter Simader wrote:

> On Fri, 16 Nov 2001, Johan van Rijn wrote:
>
> > Johan van Rijn wrote:
> > -----------
> > Compilation failed in require at /usr/local/www/sql-ledger/admin.pl line 77.
> > DBI->connect(dbname=johan;port=80) failed: connectDBStart() -- connect() failed:
>
>                            ^^^^^^^^^  wrong port

> > How do i get the database online????

If using a pretty recent version of sql-ledger you can simply leave "host"
and "port" fields empty. they now default to "localhost" and that default
port of pgsql that I always forget...

Dieter - a Changelog would be much appreciated as part of the tarball :-)

 - Jonas

-- 
Jonas Smedegaard (+45 40843136)          http://dr.jones.dk/~jonas/
Spiff ApS (= IT-guide dr. Jones ApS)     http://dr.jones.dk/
Debian GNU/Linux developer               http://people.debian.org/~js/

Re: GST accounts

[Jonas S. <jo...@jo...>]

On Fri, 16 Nov 2001, Luca Venturini wrote:

> Ned Lukies wrote:
> >
> > Is it possible to seperate the single GST account into to so that I have
> > an asset GST account for GST paid on purchases and a liability GST account
> > for GST collected on sales? If so, how?

> in Italy we use only the two accounts solution. We have to do this way
> because we have to write two different books, one for sales and the
> other
> for purchases. Just modify your accounts list and put the
> flag AP_tax in the 'GST for purchases' account and the AR_tax in the
> 'GST for sales' account.
>
> What we do is to put this together once pro month in a third account
> called something like 'GST summary'. Then I go to pay just the
> sum of this third account.

Similar (to Italy) in Denmark.

I have set it up similarly to you, Luca, and it works as expected using
"Customer Invoice" and "Vendor Invoice", but semi-manual data entry using
"Add Transaction" defaults to using both GST accounts and you'll need to
remember deselecting the irrelevant one.

What IMHO would make sence was for the "Add Transaction" screen to look at
the GST accounts chosen for the selected Customer/Vendor and only enable
those GST accounts per default.

 - Jonas

-- 
Jonas Smedegaard (+45 40843136)          http://dr.jones.dk/~jonas/
Spiff ApS (= IT-guide dr. Jones ApS)     http://dr.jones.dk/
Debian GNU/Linux developer               http://people.debian.org/~js/

Re: GST accounts

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

To use a tax on invoices you also need to check the tax field for parts
and/or services and check the customer/vendor taxable.

Tax is only calculated when both match. That is the tax for the
part/service must be set the same as for the customer/vendor.


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, 16 Nov 2001, Ned Lukies wrote:

> Adrian,
> 
> Thats not really what I was after. In the default chart of accounts, the
> GST is setup as a liability. When you receive stock, a debit is recorded
> against this account. Instead i would like a debit to be recorded against
> an asset GST account (called GST on purchases). I can create another GST
> account but I have no luck getting the "add vendor invoice" function to
> record the GST in that account rather than the default "2320 - GST
> liability" account.
> 
> Ned
> 
> On Fri, 16 Nov 2001, Adrian Blake wrote:
> 
> > >Is it possible to seperate the single GST account into to so that I have
> > >an asset GST account for GST paid on purchases and a liability GST account
> > >for GST collected on sales? If so, how?
> >
> >
> > Simply create an new account probably with the next consecutative account
> > number and make it a liability.
> > I also have capital & non-capital GST accounts
> >
> > Adrian
> >
> >
> 
> 
> 
> 

Re: no login for users

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

On Fri, 16 Nov 2001, Johan van Rijn wrote:

> Johan van Rijn wrote:
> -----------
> Compilation failed in require at /usr/local/www/sql-ledger/admin.pl line 77.
> DBI->connect(dbname=johan;port=80) failed: connectDBStart() -- connect() failed:

                           ^^^^^^^^^  wrong port


> No such file or directory at SL/User.pm line 119
> Error: Database is offline; please try again later
> Compilation failed in require at /usr/local/www/sql-ledger/login.pl line 77.
> 
> How do i get the database online????
> 
> 

Re: no login for users

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

On Fri, 16 Nov 2001, Johan van Rijn wrote:

> Compilation failed in require at /usr/local/www/sql-ledger/admin.pl line 77.
> DBI->connect(dbname=johan;port=80) failed: connectDBStart() -- connect() failed:

                            ^^^^^^^
PostgreSQL uses port 5432.  Port 80 is _normally_ the web server.

Rod
-- 
                      Let Accuracy Triumph Over Victory

                                                       Zetetic Institute
                                                        "David's Sling"
                                                         Marc Stiegler

Re: GST accounts

[Luca V. <lu...@ye...>]

Ned Lukies wrote:
> 
> Is it possible to seperate the single GST account into to so that I have
> an asset GST account for GST paid on purchases and a liability GST account
> for GST collected on sales? If so, how?
> 
> I can live with the single GST account but two would be nicer.
> 
> Regards,
> 
> Ned Lukies
> Mad for IT

Hi,

in Italy we use only the two accounts solution. We have to do this way
because we have to write two different books, one for sales and the
other
for purchases. Just modify your accounts list and put the
flag AP_tax in the 'GST for purchases' account and the AR_tax in the 
'GST for sales' account.

What we do is to put this together once pro month in a third account
called something like 'GST summary'. Then I go to pay just the
sum of this third account.

Bye

Luca

Re: no login for users

[Johan v. R. <jv...@nl...>]

Johan van Rijn wrote:
> 
> Hello,
> 
> I seam to have some problems to login sql-ledger as a user.
> 
> All goes well when i connect to the "server".
> I am able to creat user and databases.
> but i can not login as a user whith login.pl
> Nothing happends and no messages when i type in the name and passwd.
> 
>  Whats wrong
> 
> --
> Johan
some addon info i found this messages in te httpd access and error-log


127.0.0.1 - - [16/Nov/2001:13:12:18 +0100] "POST /sql-ledger/admin.pl HTTP/1.1"
200 7704 "http://localhost/sql-ledger/admin.pl" "Mozilla/5.0 (compatible;
Konqueror/2.1.1; X11)"
127.0.0.1 - - [16/Nov/2001:13:12:45 +0100] "GET
/sql-ledger/admin.pl?action=edit&login=johan&path=bin/mozilla&root=root%20login&rpw=Linux2day
HTTP/1.1" 200 7923 "http://localhost/sql-ledger/admin.pl" "Mozilla/5.0
(compatible; Konqueror/2.1.1; X11)"
127.0.0.1 - - [16/Nov/2001:13:13:11 +0100] "POST /sql-ledger/admin.pl HTTP/1.1"
200 1884
"http://localhost/sql-ledger/admin.pl?action=edit&login=johan&path=bin/mozilla&root=root%20login&rpw=Linux2day"
"Mozilla/5.0 (compatible; Konqueror/2.1.1; X11)"
127.0.0.1 - - [16/Nov/2001:13:13:29 +0100] "POST /sql-ledger/login.pl HTTP/1.1"
200 140 "http://localhost/sql-ledger/login.pl" "Mozilla/5.0 (compatible;
Konqueror/2.1.1; X11)"
127.0.0.1 - - [16/Nov/2001:13:21:13 +0100] "POST /sql-ledger/login.pl HTTP/1.1"
200 1053 "http://localhost/sql-ledger/login.pl" "Mozilla/5.0 (compatible;
Konqueror/2.1.1; X11)"
-----------
Compilation failed in require at /usr/local/www/sql-ledger/admin.pl line 77.
DBI->connect(dbname=johan;port=80) failed: connectDBStart() -- connect() failed:
No such file or directory at SL/User.pm line 119
Error: Database is offline; please try again later
Compilation failed in require at /usr/local/www/sql-ledger/login.pl line 77.

How do i get the database online????

-- 
Johan van Rijn

Re: GST accounts

[Ned L. <ne...@ma...>]

Adrian,

Thats not really what I was after. In the default chart of accounts, the
GST is setup as a liability. When you receive stock, a debit is recorded
against this account. Instead i would like a debit to be recorded against
an asset GST account (called GST on purchases). I can create another GST
account but I have no luck getting the "add vendor invoice" function to
record the GST in that account rather than the default "2320 - GST
liability" account.

Ned

On Fri, 16 Nov 2001, Adrian Blake wrote:

> >Is it possible to seperate the single GST account into to so that I have
> >an asset GST account for GST paid on purchases and a liability GST account
> >for GST collected on sales? If so, how?
>
>
> Simply create an new account probably with the next consecutative account
> number and make it a liability.
> I also have capital & non-capital GST accounts
>
> Adrian
>
>

GST accounts

[Ned L. <ne...@ma...>]

Is it possible to seperate the single GST account into to so that I have
an asset GST account for GST paid on purchases and a liability GST account
for GST collected on sales? If so, how?

I can live with the single GST account but two would be nicer.


Regards,

Ned Lukies
Mad for IT

Re: Invoices working?

[Gary P. <ga...@es...>]

Hello,

I got an error that looks similiar to yours (but it could be different I
Can't remember exactly).  The problem turned out to be with the database
name.  I named my database Test, but the actual table was stored as test.
I resolved the problem by creating a new database with only lower case
letetrs in it.  I don't know if this will help you.

	-Gary



On Thu, 15 Nov 2001, Ilkka ... wrote:

> Hi,
> 
> Does the create (customer) invoice work?
> 
> When I create a customer invoice, it complains like this:
> 
> Error!
> You have an error in your SQL syntax near '' at line 1 SELECT onhand FROM 
> parts WHERE id =
> 
> And I checked the code, and in IS->post_invoice, the variable $form->id_1 is 
> empty, which is why it complains like that.
> 
> And, I checked the is.pl: display_form and display_row functions, and the 
> id_1 variable in the form is of type "hidden" but nothing is set to this 
> variable at any time, so no wonder it is empty!
> 
> So, what's wrong here? Am I the only one getting this error?
> 
> Thanks,
> Ilkka
> 
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
> 
> 
> 

Invoices working?

[Ilkka ... <gon...@ho...>]

Hi,

Does the create (customer) invoice work?

When I create a customer invoice, it complains like this:

Error!
You have an error in your SQL syntax near '' at line 1 SELECT onhand FROM 
parts WHERE id =

And I checked the code, and in IS->post_invoice, the variable $form->id_1 is 
empty, which is why it complains like that.

And, I checked the is.pl: display_form and display_row functions, and the 
id_1 variable in the form is of type "hidden" but nothing is set to this 
variable at any time, so no wonder it is empty!

So, what's wrong here? Am I the only one getting this error?

Thanks,
Ilkka

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp