sql-ledger-users — SQL-Ledger users

help getting started ?

[Robert A. M. <rm...@nc...>]

Hi all,

   I downloaded sql-ledeger and its dependencies and got everything 
running on my RH6.2 box no real problem.  (Well I had to push the path 
/usr/local/www/sql-ledger onto @INC in the configuration file required 
by all the top level scripts, but that seemed like a small nit.)

I got the admin.pl first page up, however, when I drive down to the 
"create database" button and click on it, I get a script failed on 
require in the platform generic admin.pl.  When I trace the problem 
down, it seems that the bin/mozilla/admin.pl is failing on compile.  I 
entered the text
1;
__END__

in several places after the "uses: lines.  In some cases the script 
compiled but then called a function that (for obvious reasons) was no 
longer defined; in others it failed to compile. (perl runtime script 
compilation.)  So the problem doesn't seems to be the "uses" 
declarations. What other code could sometimes compile and sometimes not 
?   Does it conditionally load perl modules that may depend on 
LD_LIBRARY_PATH?  (I haven't worked out how to get apache to set this 
before calling a cgi.)

I'm relatively experienced with perl, but not with debugging cgi's that 
consume post events. Any hints will be appreciated.

Rob.
PS: I'm sure I made the mistake, I just want to correct it.

-- 
Quoting Steven in Illinois:
"On the side of the software box, in the 'System Requirements' section, 
 it said 'Requires Windows 95 or better'. So I installed Linux." 
 "Let the source be with you" -Tux

Re: Checkbook application

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

On Mon, 24 Sep 2001, Dieter Simader wrote:

> Multiple payments will be added for version 1.8

Type slowly I'm accounting challenged!  You do mean Payments - not
Receipts?

> This ties in with check printing, although the actual printing of
> checks has not been resolved yet, I'll probably opt for pdf to print
> checks.

My thoughts were to use pdf or - when local machine software matures -
XML with the user providing the XSLT to match their checks.

> The way it will work is that you enter payments the way you do now with
> previous entries blocked. You then enter an amount, date and optionally a
> check number or let SQL-Ledger generate the number. You can also use same
> check number for more than one open invoice.
                                      ^^^^^^^
                                      Bill? Vendor invoice?

> When you process the payments I'll generate a report for now for the
> *check run* until I find something suitable for check printing.

So we're still needing the other checkbook functionality.  Cleared
transactions - from the statement, balance to date, notes/comments, etc.

Would there be a new table to handle this check stuff?  Check number,
date, to, notes/comments (Incoming check number/Invoice number), type
(check, deposit, reconciliation - possibly handled by the sign of the
amount), amount of check or deposit.


TIA,
Rod
-- 
                      Let Accuracy Triumph Over Victory

                                                       Zetetic Institute
                                                        "David's Sling"
                                                         Marc Stiegler

Missing clauses....

[Paul S. <ps...@co...>]

First off, thanks to everyone who has made SQL-Ledger possible.  Very 
nice code set....

We are considering incorporating the SQL-Ledger accounting system into 
our Applicant Tracking System (manages resumes, contacts, jobs and what 
not).  We are very interested in the multiple payments feature slated 
for 1.8.   Hopefully, we can help at some point...


Anyhow, after using SQL-Leder for a while, I've noticed that my Postgres 
log file is filling up with the following and I wonder if it was 
something I have set incorrectly...



NOTICE:  Adding missing FROM-clause entry for table "customertax"
NOTICE:  Adding missing FROM-clause entry for table "partstax"
NOTICE:  Adding missing FROM-clause entry for table "partstax"
NOTICE:  Adding missing FROM-clause entry for table "customertax"
NOTICE:  Adding missing FROM-clause entry for table "acc_trans"
NOTICE:  Adding missing FROM-clause entry for table "acc_trans"
NOTICE:  Adding missing FROM-clause entry for table "acc_trans"
NOTICE:  Adding missing FROM-clause entry for table "acc_trans"



Regards,

-paul

Re: plaintext email invoices, link to URL

[Robert A. M. <rm...@nc...>]

Hi all,

    I downloaded sql-ledeger and its dependencies and got everything 
running on my RH6.2 box no real problem.  (Well I had to push the path 
/usr/local/www/sql-ledger onto @INC in the configuration file required 
by all the top level scripts, but that seemed like a small nit.)

I got the admin.pl first page up, however, when I drive down to the 
"create database" button and click on it, I get a script failed on 
require in the platform generic admin.pl.  When I trace the problem 
down, it seems that the bin/mozilla/admin.pl is failing on compile.  I 
entered the text
1;
__END__

in several places after the "uses: lines.  In some cases the script 
compiled but then called a function that (for obvious reasons) was no 
longer defined; in others it failed to compile. (perl runtime script 
compilation.)  So the problem doesn't seems to be the "uses" 
declarations. What other code could sometimes compile and sometimes not ?

I'm relatively experienced with perl, but not with debugging cgi's that 
consume post events. Any hints will be appreciated.

Rob.
PS: I'm sure I made the mistake, I just want to correct it.


-- 
Quoting Steven in Illinois:
"On the side of the software box, in the 'System Requirements' section, 
 it said 'Requires Windows 95 or better'. So I installed Linux." 
 "Let the source be with you" -Tux

Re: Checkbook application

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

Multiple payments will be added for version 1.8 This ties in with check
printing, although the actual printing of checks has not been resolved
yet, I'll probably opt for pdf to print checks.

The way it will work is that you enter payments the way you do now with
previous entries blocked. You then enter an amount, date and optionally a
check number or let SQL-Ledger generate the number. You can also use same
check number for more than one open invoice. When you process the payments
I'll generate a report for now for the *check run* until I find something
suitable for check printing.


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

> Several months ago I asked about web-based checkbook applications.  I
> got several good suggestions but then got busy and had to put it aside
> for awhile.
> 
> Well now I'm back and after my many-hour fiasco with guncash (Redhat 7.1
> and Ximian updates broke it totally) I'm ready to roll my own.  Since I
> will mostly be using it with SQL-Ledger I'm looking at how to make it
> play nicely with SQL-Ledger.
>    The two options I'd find useful is to pull a list of Invoices
> outstanding when making a deposit slip and pulling Vendor names etc.
> when writing checks.
> 
> Anything else I can add to the want/wish list?
> 
> 
> Cheers,
> Rod
> 

Checkbook application

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

Several months ago I asked about web-based checkbook applications.  I
got several good suggestions but then got busy and had to put it aside
for awhile.

Well now I'm back and after my many-hour fiasco with guncash (Redhat 7.1
and Ximian updates broke it totally) I'm ready to roll my own.  Since I
will mostly be using it with SQL-Ledger I'm looking at how to make it
play nicely with SQL-Ledger.
   The two options I'd find useful is to pull a list of Invoices
outstanding when making a deposit slip and pulling Vendor names etc.
when writing checks.

Anything else I can add to the want/wish list?


Cheers,
Rod
-- 
                      Let Accuracy Triumph Over Victory

                                                       Zetetic Institute
                                                        "David's Sling"
                                                         Marc Stiegler

Re: plaintext email invoices, link to URL

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

You can add a new sub in the is.pl file. Add a button "E-mail Text
Invoice" then add the sub

sub e_mail_text_invoice {

}

use the other email sub and substitute the filename and remove all the
formatting codes. There is no need to introduce new variables just add a
new sub.


You can do the same for saving the invoice to a file.


The long term goal is to move to a XML interface and produce forms in a
variety of formats, based on a filename extension variable.


I believe your assumptions are correct, the majority of people are using
html aware email clients. Your email is the first in three years asking
for a text version. That should tell you that there isn't much call for
it.


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, 24 Sep 2001, peter green wrote:

> * Dieter Simader <dsi...@sq...> [010924 10:57]:
> > You can save the invoice from your browser.
> 
> Hrm, I was hoping for something a little more automatic. Like just
> automatically saving the HTML version to the fs from e_mail_invoice() (in
> SL::Form::parse_template()?). Or adding another button that does the email
> and web page (so as not to pollute e_mail_invoice() with stuff that isn't
> strictly email). Or to build a wrapper function send_invoice() that checks a
> configuration variable in sql-ledger.conf and determines what exactly should
> happen.
> 
> Thoughts on any of those?
> 
> > To use plain text invoices copy the invoice.html to invoice.txt and edit
> > the file. Then edit email_invoice.html and <%include invoice.txt%>
> > instead.
> 
> Fair enough. To get the link in the text email, though, I would need to base
> it on the variables already available to me (in the hashref $form). In
> addition, some of the variables in $form (e.g., address, signature) have
> ``<BR>'' in them after e_mail_invoice() transforms them, so I would need to
> introduce add'l variables that really have ``\n''.
> 
> Are people really sending HTML-only email invoices? Is the assumption that
> the percentage of people that use text-only email is insignificant enough
> not to worry about?
> 
> Just FYI, my *real* intent was to send the email as multipart/alternative
> with both the text and HTML versions. However, Microsoft, in all of its
> brilliance, equipped Exchange with the ``feature'' of overwriting the text
> part of a multipart/alternative email with a (POORLY!) rendered version of
> the HTML. Forget what the *user* wants to see (text v. html), Bill Knows
> What's Best. >:-(
> 
> Anyway, thanks for the help!
> 
> /pg
> 

Re: plaintext email invoices, link to URL

[peter g. <pc...@ai...>]

* Dieter Simader <dsi...@sq...> [010924 10:57]:
> You can save the invoice from your browser.

Hrm, I was hoping for something a little more automatic. Like just
automatically saving the HTML version to the fs from e_mail_invoice() (in
SL::Form::parse_template()?). Or adding another button that does the email
and web page (so as not to pollute e_mail_invoice() with stuff that isn't
strictly email). Or to build a wrapper function send_invoice() that checks a
configuration variable in sql-ledger.conf and determines what exactly should
happen.

Thoughts on any of those?

> To use plain text invoices copy the invoice.html to invoice.txt and edit
> the file. Then edit email_invoice.html and <%include invoice.txt%>
> instead.

Fair enough. To get the link in the text email, though, I would need to base
it on the variables already available to me (in the hashref $form). In
addition, some of the variables in $form (e.g., address, signature) have
``<BR>'' in them after e_mail_invoice() transforms them, so I would need to
introduce add'l variables that really have ``\n''.

Are people really sending HTML-only email invoices? Is the assumption that
the percentage of people that use text-only email is insignificant enough
not to worry about?

Just FYI, my *real* intent was to send the email as multipart/alternative
with both the text and HTML versions. However, Microsoft, in all of its
brilliance, equipped Exchange with the ``feature'' of overwriting the text
part of a multipart/alternative email with a (POORLY!) rendered version of
the HTML. Forget what the *user* wants to see (text v. html), Bill Knows
What's Best. >:-(

Anyway, thanks for the help!

/pg
-- 
Peter Green : Architekton Internet Services, LLC : pc...@ai...
-------------------------------------------------------------
chmod a+x /bin/laden

Re: plaintext email invoices, link to URL

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

You can save the invoice from your browser.

To use plain text invoices copy the invoice.html to invoice.txt and edit
the file. Then edit email_invoice.html and <%include invoice.txt%>
instead.

If you want to keep these when you setup new templates add the template
in the master directory (that is the templates directory)

To add the template to the Default set call the file
Default_invoice.txt


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

On Sun, 23 Sep 2001, peter green wrote:

> I'd like to be able to send a plaintext email, simultaneously exporting the
> HTML invoice to a file on the filesystem, and point a link to the URL in the
> text email. Is anyone else doing this? Does it make sense to do it this way?
> Or am I missing something about the way users work in sql-ledger that would
> make this kind of web access to invoices easier?
> 
> Sorry if this appears in the archive; the searching is turning up 0 hits for
> all queries. (As is the alternate engine someone posted a while back...)
> 
> Thanks,
> 
> /pg
> 

Taxes payd for the supplier

[Paolo B. <p.b...@ic...>]

Hi everyone,

I would like to know if it is possible to configure SQL-ledger for the 
following thing.

In Italy we have a special kind of taxes, that are payd on certain services. 
These taxes are paid by the customer for the supplier.

Here is an example: 

I order to Marco a program for 1 dollar.

Marco receives 0.8 dollars, while I have 0.2 dollars I have to pay as taxes 
for Marco. This is done monthly, so I need an account to accrue all these 
taxes.

Can someone help me on this ?

Regards

Paolo

-- 
Paolo Bizzarri - Presidente - Icube S.r.l.
Sede:   Via Ridolfi 15 - 56124 Pisa (PI), Italia 
E-mail: p.b...@ic...		WWW: www.icube.it	
Tel: 	(+39) 050 97 02 07		Fax: (+39) 050 31 36 588	

plaintext email invoices, link to URL

[peter g. <pc...@ai...>]

I'd like to be able to send a plaintext email, simultaneously exporting the
HTML invoice to a file on the filesystem, and point a link to the URL in the
text email. Is anyone else doing this? Does it make sense to do it this way?
Or am I missing something about the way users work in sql-ledger that would
make this kind of web access to invoices easier?

Sorry if this appears in the archive; the searching is turning up 0 hits for
all queries. (As is the alternate engine someone posted a while back...)

Thanks,

/pg
-- 
Peter Green : Architekton Internet Services, LLC : pc...@ai...
-------------------------------------------------------------
chmod a+x /bin/laden

Re: Decimal-calculation problem/error

[Kenneth V. S. <kv...@bi...>]

On Sun, Sep 23, 2001 at 03:27:56AM +0200, Kenneth Vestergaard Schmidt wrote:
> However, I always get the same error, that debit and credit are out of
> balance. If I remove the decimal part, everything works out nicely.

I just noticed the other post about the same problem, and tried the sprintf
solution. It worked. Sorry for not checking better :-(

/Kenneth

-- 
"Ah? Well, maths," said Death dismissively. "Generally I never
get much further than subtraction."

Bug when edit the user[version-1.6.5]

[Lau W. <ech...@ho...>]

Hi,

When I try to edit the user using admin.pl. The strang things happen... The 
old database password is missing (just first character of the old password 
appear)

Please Help!

William


_________________________________________________________________
您可以在 MSN Hotmail 站点 http://www.hotmail.com/cn 免费收发电子邮件

Decimal-calculation problem/error

[Kenneth V. S. <kv...@bi...>]

Mjello.

Just started using sql-ledger today, and have been impressed with it so far.
However, two hours ago, I stumbled on a problem I have since been trying to
solve to no avail.

In the GL, I try to enter a transaction with three rows.

Account 1061, credit 115.05 (Asset, Account, AR_paid, AP_paid)
Account 2310, debit 23.01 (Asset, Account, AP_tax, IC_taxservice, CT_tax)
Account 5700, debit 92.04 (Expense, Account, AP_amount)

However, I always get the same error, that debit and credit are out of
balance. If I remove the decimal part, everything works out nicely.

Normally, I use the system in "1.000,00" mode, but I tried resetting it to
"1000.00" mode, and making special care of placing the correct commas or dots.
Nothing worked. I have tried tinkering a bit with the Perl-code, but I'm too
inexperienced to find the problem (I thought I could manipulate parse_amount,
but it didn't help). Can anybody tell me if I've found a bug (and how to solve
it), or if I'm the bug?

I'm using version 1.6.5, Apache 1.3.20, dbd-pg-perl 1.01, dbi v1.19 and
perl v6.2.

Thank you very much in advance
Kenneth Vestergaard Schmidt

-- 
"Ah? Well, maths," said Death dismissively. "Generally I never
get much further than subtraction."

Re: [Fwd: date error]

[adrian <ad...@sn...>]

Dieter Simader wrote:
> 
> Perhaps you highlighted the date and pressed the spacebar to erase it.
> This will assign a single space to the date which causes a bad date error.

 Tried that, and made sure there were no extra spaces. I installed 1.6.4
this morning. I am using konqueror...... and that is the problem,
Netscape works well.   BUT WHY ?? 

I will enter a few more transactions to verify and inform you of the
result.

Adrian
-- 
Adrian Blake
Snowy Technology Pty Ltd
26b Bombala St
Cooma, NSW 2630
Ph 2-64-524338 mobile 0407 232 978

INSTALL PROBLEM:

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

 When I unpack sql-ledger into my cgi-bin directory and run admin.pl I get a
"No such file or directory" error. $memberfile seems not to be set. Also can
you use other databases besides PostgresQL or Orcale. For Instance MSAccess
or SQL-Server. I notice that you seem to filter out the ODBC drivers in the
SL::Form module. Note I am using windows98 with Apache 1.3.20 and SQL-Ledger
1-6-1.

	If any one with can help with these issues that would be greate

	regards Douglas McNamara, Dogleg Systems, Inc.

Re: [Fwd: date error]

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

Perhaps you highlighted the date and pressed the spacebar to erase it.
This will assign a single space to the date which causes a bad date error.


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, 18 Sep 2001, adrian wrote:

> 
> Firstly,
> 
> Thanks for the solution to the calculation error
> 
> NOW
> 
> A date error in entering accounts payable. see attached. The date format
> has worked in the past and in other modules
> 
> Adrian
> 

Mozilla and SQL-Ledger

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

I've run into a slight problem but haven't had time to sort it out.  I'm
hoping it isn't 'just me'.

When using Mozilla to access SQL-Ledger (1.6.4) I noticed several of the
modules never complete receiving the document.  I looked at teh frame
source and see that there is no ending tags for body or html.
   To make sure it wasn't a Mozilla problem I tried netscape but in this
case the document seems to finish but the frame source still has no
closing body or html tags.
   I'm pretty sure it isn't a server problem because all my other
scripts work fine.

I'll be looking over the code in the next few days to find why this is
happening.  I didn't find a developer's mailing list so I'm
semi-spamming this one.  Dieter, should I contact you directly?


Cheers,
Rod
-- 
                      A small clue and no money
                      will get you further than
                      lots of money and no clue.

[Fwd: date error]

[adrian <ad...@sn...>]

Firstly,

Thanks for the solution to the calculation error

NOW

A date error in entering accounts payable. see attached. The date format
has worked in the past and in other modules

Adrian
-- 
Adrian Blake
Snowy Technology Pty Ltd
26b Bombala St
Cooma, NSW 2630
Ph 2-64-524338 mobile 0407 232 978

Re: error!

[Alan H. <aho...@si...>]

On Mon, Sep 17, 2001 at 03:22:49PM -0600, Dieter Simader wrote:
> The connect string was revised in version 1.6.2
> 
> If nothing is entered in the host and port field then the connect string
> is built without it.

Yeah I thought I remembered seeing that posted.  Sorry, haven't upgraded to
1.6.x yet.  However, I was just pointing out a better solution to the network
connection problem - clearing the host and port fields I guess should be
sufficient.

-- 
Capital punishment turns the state into a murderer.  But imprisonment turns
the state into a gay dungeon-master. -- Rev. Jesse Jackson

Re: error!

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

The connect string was revised in version 1.6.2

If nothing is entered in the host and port field then the connect string
is built without it.


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, 17 Sep 2001, Alan Hodgson wrote:

> On Mon, Sep 17, 2001 at 12:44:13PM -0700, Don Wellington wrote:
> > I am running the same software, and it works.  I think
> > you need to change the postgres startup, so that
> > TCP/IP connections are enabled.  I can't remember the
> > command line switch off the top of my head, but it is
> > in the postgres documentation.
> 
> It's -i
> 
> However, a better method is to remove the host and port information from
> the DBI connect string.  If you do so, DBI will use the UNIX domain socket
> to connect instead of TCP/IP.
> 
> 

Re: error!

[Alan H. <aho...@si...>]

On Mon, Sep 17, 2001 at 12:44:13PM -0700, Don Wellington wrote:
> I am running the same software, and it works.  I think
> you need to change the postgres startup, so that
> TCP/IP connections are enabled.  I can't remember the
> command line switch off the top of my head, but it is
> in the postgres documentation.

It's -i

However, a better method is to remove the host and port information from
the DBI connect string.  If you do so, DBI will use the UNIX domain socket
to connect instead of TCP/IP.

-- 
"Give me your four year-olds and in a generation I will build a socialist
state ... destroy the family and the society will collapse." 
 -- Vladimir Lenin

Re: error!

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

I am running the same software, and it works.  I think
you need to change the postgres startup, so that
TCP/IP connections are enabled.  I can't remember the
command line switch off the top of my head, but it is
in the postgres documentation.

Don

--- Pedro Torres <pet...@ya...> wrote:
> hi, 
>  i am new in this stuff, i have mandrake 8.0 and
> sql-ledger v. 1.6.0.
> 
> i tried to install several times, follow all the
> instructions and now i am reciving this message:
> 
> "Error! PQconnectPoll() -- Connect() failed:
> conection
> refused"
> 
> what i am doing wrong. i will apreciate any help.
> 
> thanks...
> 
> __________________________________________________
> Terrorist Attacks on U.S. - How can you help?
> Donate cash, emergency relief information
>
http://dailynews.yahoo.com/fc/US/Emergency_Information/
> 


__________________________________________________
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/

Re: entering starting amounts into accounts

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

Hi Greg-

You will also need to create a sort of dummy account
to make the double entry bookkeeping balance. For
example:

Your checking account has $1000 in it to start. (Now,
I  will probably get which is debit and which is
credit wrong.)

1) Create an account called say Initial Account.
2) Make a General Ledger entry where you debit
checking $1000 and credit Initial Account $1000.
3) Do something similar for all other initial amounts.

Inventory is a little trickier.  Dieter and others
discussed it with me when I asked earlier, and what I
got was this.

1) Create an account to pay for the inventory.
2) Create a vendor that is basically yourself.
3) Create vendor invoices for all of your initial
inventory and pay for it from the account in step 1.

I hope that helps.

Don


--- Dieter Simader <dsi...@sq...> wrote:
> Use the GL and make an entry for the balance.
> 
> 
> Dieter Simader    http://www.sql-ledger.org   (780)
> 472-8161
> DWS Systems Inc.     Accounting Software       Fax:
> 478-5281
> =========== On a clear disk you can seek forever
> ===========
> 
> On Sun, 16 Sep 2001, Greg Jetter wrote:
> 
> > I can't seem to find any way of entering initaia
> values into accounts created 
> > by the install process ,  any hints ?
> > 
> > 
> > Greg
> > 
> > 
> 
> 


__________________________________________________
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/

error!

[Pedro T. <pet...@ya...>]

hi, 
 i am new in this stuff, i have mandrake 8.0 and
sql-ledger v. 1.6.0.

i tried to install several times, follow all the
instructions and now i am reciving this message:

"Error! PQconnectPoll() -- Connect() failed: conection
refused"

what i am doing wrong. i will apreciate any help.

thanks...

__________________________________________________
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/