sql-ledger-users — SQL-Ledger users

Re: editing "On Hand" quantity of inventory

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

OnHand quantity in inventory is controlled by "Customer Invoice" and
"Vendor Invoice" When you sell and purchase the part the quantity is
updated.

The "Add Part" function is only to setup the part in inventory, how it is
linked, selling price, etc.


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, 14 Jul 2001, Robert A. Mathison II wrote:

> Is there a way to edit the "on  hand" quantity of an inventory part in
> the  edit part screen?  Or, a way to set the current "on hand" quanitity
> when using the "add part" page for a new inventory part?   Is there a
> different page to set the "on hand" quantity for an inventory part?
> 
> I am using SQL-Ledger v1.4.8 on RH7.1 and it runs excellent.
> 
> Thanks for the help,
> 
> Bob Mathison
> Mathison Supply Co, Inc
> 31535 Ford Rd
> Garden City, MI 48135
> 734.422.3858
> rma...@tw...
> 
> 
> 
> 
> 

editing "On Hand" quantity of inventory

[Robert A. M. I. <rma...@tw...>]

Is there a way to edit the "on  hand" quantity of an inventory part in
the  edit part screen?  Or, a way to set the current "on hand" quanitity
when using the "add part" page for a new inventory part?   Is there a
different page to set the "on hand" quantity for an inventory part?

I am using SQL-Ledger v1.4.8 on RH7.1 and it runs excellent.

Thanks for the help,

Bob Mathison
Mathison Supply Co, Inc
31535 Ford Rd
Garden City, MI 48135
734.422.3858
rma...@tw...

Re: Errors in sql-ledger 1.4.11 version

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

Perhaps it may be better to upgrade to the newest version... 1.4.12
...;-)
-- 
     /) John Clark Naldoza y Lopez                           (\
    / )    Software Design Engineer II                       ( \
  _( (_    _  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...                        \   \

Errors in sql-ledger 1.4.11 version

[Wong L. W. <won...@ya...>]

I upgraded my sql-ledger version1.4.5 to 1.4.11. I have no problem in login 
but with problem in the report part of the program. When I click on Balance 
Sheet, Income Statement and trial balance report I get this message below :

Error!

ERROR: No such attribute or function 'chart_id' SELECT chart.accno,
 description, type, SUM(CASE WHEN amount < 0 THEN -amount ELSE 0 END) AS
 debit, SUM(CASE WHEN amount > 0 THEN amount ELSE 0 END) AS credit FROM
 chart, acc_trans WHERE chart.id = acc_trans.chart_id AND true GROUP BY
 chart.accno, description, type UNION SELECT chart.accno, description, type,
 0.0 as debit, 0.0 as credit FROM chart, acc_trans WHERE chart.type = 'H'
 ORDER BY chart.accno

In my httpd directory's log file, the error log show this message :

[Sat Jul 14 08:55:17 2001] [notice] Apache-AdvancedExtranetServer/1.3.19
 (Linux-Mandrake/3mdk) mod_ssl/2.8.2 OpenSSL/0.9.6 configured -- resuming
 normal operations [Sat Jul 14 09:04:29 2001] [error] [client 127.0.0.1] File
 does not exist: /var/www/html/favicon.ico [Sat Jul 14 09:04:30 2001] [error]
 [client 127.0.0.1] file permissions deny server execution:
 /var/www/cgi-bin/sql-ledger/sql-ledger.gif DBD::Pg::st execute failed:
 ERROR:  No such attribute or function 'chart_id' Died at SL/Form.pm line
 107.
Compilation failed in require at /var/www/cgi-bin/sql-ledger/rp.pl line 65.
DBD::Pg::st execute failed: ERROR:  No such attribute or function 'chart_id'
Died at SL/Form.pm line 107.
Compilation failed in require at /var/www/cgi-bin/sql-ledger/rp.pl line 65.
Database handle destroyed without explicit disconnect.

Is that something wrong in my setting?

Please help.

Thank You.

User docs

[Brian J. <bjo...@je...>]

Is there user documentation anywhere?

I have Version 1.4.7 and only found some brief documentation with it and on the site

I have difficulty tellingwhat some of the form boxes are.

eg. 
Edit Service -> Unit of measure, List, Sell
use of Vendor Invoice vs Add Transaction
-----
Brian Johnson, P. Eng.
Johnson Engineering Consultants
www.jecinc.on.ca

Re: Advice on Apache

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

> Obviously there is an advantage to mod_perl's persistence, speeding 
> up response processing significatively (I've seen claims of 
> improvements in the order of 10 to 100 times!, depending on code) in 
> exchange for a bit more RAM. This is clearly a usable benefit!
> 
> Where do you all think mod_perl can fit into sql-ledger's scheme of things?

It probably doesn't need to for the vast majority of SQL-Ledger users:

We do virtual-hosting and have offered mod_perl on our servers for several years now. Our own e-commerce stuff 
and anything else that will generate large numbers of hits is built in Perl/mod_perl. mod_perl is probably one of the 
single most powerful technologies available to web developers using Perl.

mod_perl integrates the Perl language interpreter into the Apache web server. This has two main advantages:

1. the developer gets access to the Apache API via Perl, allowing Apache modules (or handlers) to be written in Perl
2. Perl scripts can run as Apache::Registry scripts, meaning they are parsed, compiled and executed in the         
Apache process itself.

Once a script has been parsed and compiled into the Apache parent process (preferably at Apache start-up) the 
next request that calls the script is answered from the compiled version cached by Apache. This means the 
overhead of starting a Perl process, parsing and compiling the script for each request is avoided. The result is 
performance that comes close to that of compiled C-code in many cases.

So, mod_perl is used for speed and power by folks that use Perl. But, for applications like SQL-Ledger its benefits 
are likely to be minimal at best (unless the same system is being used by many users simultaneously).

There are a couple of caveats when using mod_perl. But they do help enforce good coding practices. Because the 
Perl scripts/handlers/Apache-modules are persistent name-spaces and variable-scoping become critical. A global 
variable will be shared by all Apache processes that handle requests for a particular script. mod_perl Apache 
processes can be pretty large. On modern systems this is usually not a problem. On a busy server it is generally 
preferable to have an Apache child process using 10MB-RAM (a lot is shared memory on OS's like Linux) than to 
fork and exec a new Perl process for every hit to a frequently requested resource.

There is no harm in using a mod_perl capable server to run SQL-Ledger since Perl scripts can always be run as 
standard CGI processes. The Apache configuration can control the use of mod_perl on a per-file/script basis.

For more info see:
http://perl.apache.org/guide/

Mark

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

Re: Advice on Apache

[John S. <js...@im...>]

>Thanks for all the replys. After doing further reading
>I came to the conculsion that I didn't need mod_perl.
>I have Apache now installed. now for DBI.
>Wayne
>
>"Roderick A. Anderson" wrote:
>
>>  On Thu, 12 Jul 2001, Jonas Smedegaard wrote:
>>
>>  > On Thu, 12 Jul 2001, Wayne wrote:
>>  >
>>  >  > Thanks for the input John. I download Apache 1.3.20 and after reading
>>  >  > the INSTALL instruction I'm not sure whether I should install mod_perl
>>  >  > first or if I can do it after installing Apache.
>>
>>  You might look for the apache-heavy package - statically linked in
>>  mod_perl (and other modules if you want). There are RPMs (which is what
>>  I use) but I'm not sure about a tarball or other package managers.
>>
>>  > Forget about mod_perl. For SQL-Ledger you need Apache and perl, not
>>  > apache+perl.
>>  >
>>  > mod_perl is for embedding perl commands in html - like server side
>>  > includes or php. SQL-Ledger is perl CGI-scripts, not embedded perl.
>>
>>  Actually I think you're thinking of embperl.  Mod_perl loads a perl
>>  interpreter into Apache.  The main benefit being quicker startup of perl
>>  scripts.  Instead of Apache making a system call to the script which
>>  starts perl which reads the rest of the script file to execute; mod_perl
>>  gets reads the script to execute (or it will already be there from a
>>  previous call).  Things happen faster.
>>
>>     For a lightly loaded server (hardware and software wise) it isn't
>>  really needed but on a system running multiple companies which may have
>>  multiple users connected at the same time the response times would be
>>  much better.
>>
>>  I'm not sure if the SQL-Ledger code supports Apache::DBI but it is my
>>  understanding that this in conjunction with mod_perl will make a
>>  significant response time difference.
>>
>  > The short of it is mod_perl isn't needed for light/normal usage.

This thread has raised an interesting point regarding Doug 
MacEachern's mod_perl, a truly powerful resource. Apparently, it's so 
popular that many CGI developers have switched to circumnavigate 
mod_cgi's shortcomings. Statistics at 
http://perl.apache.org/netcraft/ show it in use on over 2 million 
server installations.

Obviously there is an advantage to mod_perl's persistence, speeding 
up response processing significatively (I've seen claims of 
improvements in the order of 10 to 100 times!, depending on code) in 
exchange for a bit more RAM. This is clearly a usable benefit!

Where do you all think mod_perl can fit into sql-ledger's scheme of things?



John

Re: Advice on Apache

[John S. <js...@im...>]

>On Thu, 12 Jul 2001, Wayne wrote:
>
>>  Thanks for the input John. I download Apache 1.3.20 and after reading
>>  the INSTALL instruction I'm not sure whether I should install mod_perl
>>  first or if I can do it after installing Apache.
>
>Forget about mod_perl. For SQL-Ledger you need Apache and perl, not
>apache+perl.

You're totally right of course, sql-ledger wants a web server and the 
perl language.

mod_perl is an apache loadable module that implements the perl 
language. I don't know how it fits into Wayne's general plan, which 
is why I didn't comment.

Thanks for clearing up that omission!




John

Re: Advice on Apache

[Wayne <inf...@pi...>]

Thanks for all the replys. After doing further reading
I came to the conculsion that I didn't need mod_perl.
I have Apache now installed. now for DBI.
Wayne

"Roderick A. Anderson" wrote:

> On Thu, 12 Jul 2001, Jonas Smedegaard wrote:
>
> > On Thu, 12 Jul 2001, Wayne wrote:
> >
> >  > Thanks for the input John. I download Apache 1.3.20 and after reading
> >  > the INSTALL instruction I'm not sure whether I should install mod_perl
> >  > first or if I can do it after installing Apache.
>
> You might look for the apache-heavy package - statically linked in
> mod_perl (and other modules if you want). There are RPMs (which is what
> I use) but I'm not sure about a tarball or other package managers.
>
> > Forget about mod_perl. For SQL-Ledger you need Apache and perl, not
> > apache+perl.
> >
> > mod_perl is for embedding perl commands in html - like server side
> > includes or php. SQL-Ledger is perl CGI-scripts, not embedded perl.
>
> Actually I think you're thinking of embperl.  Mod_perl loads a perl
> interpreter into Apache.  The main benefit being quicker startup of perl
> scripts.  Instead of Apache making a system call to the script which
> starts perl which reads the rest of the script file to execute; mod_perl
> gets reads the script to execute (or it will already be there from a
> previous call).  Things happen faster.
>
>    For a lightly loaded server (hardware and software wise) it isn't
> really needed but on a system running multiple companies which may have
> multiple users connected at the same time the response times would be
> much better.
>
> I'm not sure if the SQL-Ledger code supports Apache::DBI but it is my
> understanding that this in conjunction with mod_perl will make a
> significant response time difference.
>
> The short of it is mod_perl isn't needed for light/normal usage.
>
> Rod
> --
>                  Remove the word 'try' from your vocabulary ...
>                      Don't try.  Do it or don't do it ...
>                                 Steers try!
>
>                                                             Don Aslett

Re: Advice on Apache

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

On Thu, 12 Jul 2001, Jonas Smedegaard wrote:

> On Thu, 12 Jul 2001, Wayne wrote:
> 
>  > Thanks for the input John. I download Apache 1.3.20 and after reading
>  > the INSTALL instruction I'm not sure whether I should install mod_perl
>  > first or if I can do it after installing Apache.

You might look for the apache-heavy package - statically linked in
mod_perl (and other modules if you want). There are RPMs (which is what
I use) but I'm not sure about a tarball or other package managers.

> Forget about mod_perl. For SQL-Ledger you need Apache and perl, not
> apache+perl.
> 
> mod_perl is for embedding perl commands in html - like server side
> includes or php. SQL-Ledger is perl CGI-scripts, not embedded perl.

Actually I think you're thinking of embperl.  Mod_perl loads a perl
interpreter into Apache.  The main benefit being quicker startup of perl
scripts.  Instead of Apache making a system call to the script which
starts perl which reads the rest of the script file to execute; mod_perl
gets reads the script to execute (or it will already be there from a
previous call).  Things happen faster.

   For a lightly loaded server (hardware and software wise) it isn't
really needed but on a system running multiple companies which may have
multiple users connected at the same time the response times would be
much better.

I'm not sure if the SQL-Ledger code supports Apache::DBI but it is my
understanding that this in conjunction with mod_perl will make a
significant response time difference.

The short of it is mod_perl isn't needed for light/normal usage.


Rod
-- 
                 Remove the word 'try' from your vocabulary ... 
                     Don't try.  Do it or don't do it ...
                                Steers try!

                                                            Don Aslett

Re: Advice on Apache

[Jose R. A. <jos...@ho...>]

Hi guys.

I've been following this thread and i think noone has told you about
www.apachetoolbox.com, it might be the best approach for your needs, take a
look at the site and smile for a while as you see all your troubles vanish away.

Have a nce day.

-- 

Jose Rodriguez Alarcon
http://hostinglabs.com
jos...@ho...

On Thu, 12 Jul 2001, you wrote:
> >I download Apache 1.3.20 and after reading the INSTALL instruction 
> >I'm not sure whether I should install mod_perl first or if I can do 
> >it after installing Apache.
> 
> If my memory serves me rightly, you should have apache installed 
> first. You can find latest mod_perl at 
> http://perl.apache.org/dist/mod_perl-1.26.tar.gz
> 
> When you untar, locate the INSTALL.simple file, which will give you 
> an overview of the whole process. The INSTALL file goes through the 
> process thoroughly.
> 
> Good luck
> 
> 
> John

Re: Advice on Apache

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

On Thu, 12 Jul 2001, Wayne wrote:

 > Thanks for the input John. I download Apache 1.3.20 and after reading
 > the INSTALL instruction I'm not sure whether I should install mod_perl
 > first or if I can do it after installing Apache.

Forget about mod_perl. For SQL-Ledger you need Apache and perl, not
apache+perl.

mod_perl is for embedding perl commands in html - like server side
includes or php. SQL-Ledger is perl CGI-scripts, not embedded perl.

Hope that clears up the confusion a bit :-)

  - Jonas

--
Jonas Smedegaard <jo...@jo...> http://dr.jones.dk/~jonas/ +45 40843136
Spiff ApS (aka. IT-guide dr. Jones ApS) <dr...@jo...> http://dr.jones.dk/
Debian GNU/Linux <js...@de...> http://www.debian.org/ fngrprn: C02440B8

GNU GPL: "The source will be with you... always."

Re: Advice on Apache

[John S. <js...@im...>]

>I download Apache 1.3.20 and after reading the INSTALL instruction 
>I'm not sure whether I should install mod_perl first or if I can do 
>it after installing Apache.

If my memory serves me rightly, you should have apache installed 
first. You can find latest mod_perl at 
http://perl.apache.org/dist/mod_perl-1.26.tar.gz

When you untar, locate the INSTALL.simple file, which will give you 
an overview of the whole process. The INSTALL file goes through the 
process thoroughly.

Good luck


John

Re: Advice on Apache

[Wayne <inf...@pi...>]

Thanks for the input John. I download Apache 1.3.20 and
after reading the INSTALL instruction I'm not sure
whether I should install mod_perl first or if I can do it
after installing Apache.
Wayne

John Stoddart wrote:

> >Hi All,
> >I'm getting ready to download Apache and
> >wasn't sure what I should download. Do
> >I download the httpd or the one in the perl
> >tree? I never installed Apache before.
> >Thanks.
> >Wayne
>
> Hi there,
>
> Downloading apache is no problem at all, no matter what os. It's not
> a really big download either. Just saunter over to
> http://httpd.apache.org/dist/httpd/ and download source for 1.3.19 or
> 1.3.20 (latest).
>
> Untar, check out the README files, ./configure, make and make
> install; that's all there is to it, your set to go!
>
> Although I think its more fun to roll your own, there is a binaries
> directory too, where most oss are represented. Just name your poison.
>
> However, if you're running a particular linux or bsd distribution,
> look for the apache package, deb, rpm on your os vendor's website.
> It's probably less painful that way.
>
> Enjoy ...
>
> John Stoddart
> Caracas - Venezuela

Re: Advice on Apache

[German D. <g_d...@ya...>]

Download the apache server version 1.3.39 and then go
to the perl site and download the perl-dbi and DB.
Jerry
--- John Stoddart <js...@im...> wrote:
> >Hi All,
> >I'm getting ready to download Apache and
> >wasn't sure what I should download. Do
> >I download the httpd or the one in the perl
> >tree? I never installed Apache before.
> >Thanks.
> >Wayne
> 
> Hi there,
> 
> Downloading apache is no problem at all, no matter
> what os. It's not 
> a really big download either. Just saunter over to 
> http://httpd.apache.org/dist/httpd/ and download
> source for 1.3.19 or 
> 1.3.20 (latest).
> 
> Untar, check out the README files, ./configure, make
> and make 
> install; that's all there is to it, your set to go!
> 
> Although I think its more fun to roll your own,
> there is a binaries 
> directory too, where most oss are represented. Just
> name your poison.
> 
> However, if you're running a particular linux or bsd
> distribution, 
> look for the apache package, deb, rpm on your os
> vendor's website. 
> It's probably less painful that way.
> 
> Enjoy ...
> 
> 
> 
> 
> John Stoddart
> Caracas - Venezuela
> 


__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/

Re: User's name in a template

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

On Wed, 11 Jul 2001, Dieter Simader wrote:

> The name escaped me, it is already used.
> 
> You can add this instead
> 
>   $form->{uname} = $myconfig->{name};
> 
> and then use <%uname%> in the invoice form.

Why can't I be this smart.  It is so obvious.

I spent a bit of time last night chasing down all the places 'name' for
the user is, changing them to uname. Well back they go and I'll add
these lines.  Much better solution.


Rod
-- 
                 Remove the word 'try' from your vocabulary ... 
                     Don't try.  Do it or don't do it ...
                                Steers try!

                                                            Don Aslett

Re: Advice on Apache

[John S. <js...@im...>]

>Hi All,
>I'm getting ready to download Apache and
>wasn't sure what I should download. Do
>I download the httpd or the one in the perl
>tree? I never installed Apache before.
>Thanks.
>Wayne

Hi there,

Downloading apache is no problem at all, no matter what os. It's not 
a really big download either. Just saunter over to 
http://httpd.apache.org/dist/httpd/ and download source for 1.3.19 or 
1.3.20 (latest).

Untar, check out the README files, ./configure, make and make 
install; that's all there is to it, your set to go!

Although I think its more fun to roll your own, there is a binaries 
directory too, where most oss are represented. Just name your poison.

However, if you're running a particular linux or bsd distribution, 
look for the apache package, deb, rpm on your os vendor's website. 
It's probably less painful that way.

Enjoy ...




John Stoddart
Caracas - Venezuela

Re: Advice on Apache

[Rod R. <ro...@su...>]

What OS?  Most Linux distributions come with Apache included.
You might find it easier to upgrade to something like Red Hat
7.1 than try to figure out installation of Postgres, DBI, DBD,
Apache, etc.

Or if you like I'll sell you a Linux box with sql-ledger ready
to go.  :-)

-- Rod
    http://www.sunsetsystems.com/

Wayne wrote:

> Hi All,
> I'm getting ready to download Apache and
> wasn't sure what I should download. Do
> I download the httpd or the one in the perl
> tree? I never installed Apache before.
> Thanks.
> Wayne

Advice on Apache

[Wayne <inf...@pi...>]

Hi All,
I'm getting ready to download Apache and
wasn't sure what I should download. Do
I download the httpd or the one in the perl
tree? I never installed Apache before.
Thanks.
Wayne

Re: User's name in a template

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

The name escaped me, it is already used.

You can add this instead

  $form->{uname} = $myconfig->{name};

and then use <%uname%> in 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 Tue, 10 Jul 2001, Roderick A. Anderson wrote:

> On Tue, 10 Jul 2001, Dieter Simader wrote:
> 
> > You can add the name in SL/IS.pm line 151
> > 
> >   map { $form->{$_} = $myconfig->{$_} } (qw(name company address tel fax
> > signature));
> > 
> > then use <%name%> on the invoice form.
> 
> One slight problem.  Name is the same for both the user and the company
> being billed.  So when I do this I get the user's name in the bill to
> block.
>    I'm chasing down all the changes that need to be done to change the
> entry in the members file from name to uname (Would you prefer a
> different value?).  Got some of them but not all ... yet!
>  
> 
> Rod
> 

Receipting payments at the account level

[Tony G. <to...@go...>]

We have what seems to be a unique requirement not handled by the common
entry-level business accounting software, so we thought we'd check the
response from the major  open source packages.

We have no trouble CREATING invoices with amounts against multiple
receivable accounts.  However, the payment receipt process ends at the
invoice level, not the account level.  So, for example, we know that
Customer X has an outstanding balances on invoices 109 and 234, but we don't
know their balance on the "Hardware sales" and "Billable services" accounts
which each of those invoices included.

Can SQL-Ledger do this?  If not, does anyone else see this as useful?

Re: User's name in a template

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

On Tue, 10 Jul 2001, Dieter Simader wrote:

> You can add the name in SL/IS.pm line 151
> 
>   map { $form->{$_} = $myconfig->{$_} } (qw(name company address tel fax
> signature));
> 
> then use <%name%> on the invoice form.

One slight problem.  Name is the same for both the user and the company
being billed.  So when I do this I get the user's name in the bill to
block.
   I'm chasing down all the changes that need to be done to change the
entry in the members file from name to uname (Would you prefer a
different value?).  Got some of them but not all ... yet!
 

Rod
-- 
                 Remove the word 'try' from your vocabulary ... 
                     Don't try.  Do it or don't do it ...
                                Steers try!

                                                            Don Aslett

Re: User's name in a template

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

You can add the name in SL/IS.pm line 151

  map { $form->{$_} = $myconfig->{$_} } (qw(name company address tel fax
signature));

then use <%name%> on 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 Tue, 10 Jul 2001, Roderick A. Anderson wrote:

> I have a need to be able to put the SQL-Ledger user's name in an
> invoice.  Based on the entries in the users/members file I tried
> <%name%> but got the invoiced company's name instead.  Where would I add
> this capability or what value do I use? I couldn't figure out where
> parse_template was pulling the other values from.
> 
> 
> Thanks,
> Rod
> 

User's name in a template

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

I have a need to be able to put the SQL-Ledger user's name in an
invoice.  Based on the entries in the users/members file I tried
<%name%> but got the invoiced company's name instead.  Where would I add
this capability or what value do I use? I couldn't figure out where
parse_template was pulling the other values from.


Thanks,
Rod
-- 
                 Remove the word 'try' from your vocabulary ... 
                     Don't try.  Do it or don't do it ...
                                Steers try!

                                                            Don Aslett

Re: Prorated Credit Issue

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

change the following lines to allow for negative values

bin/mozilla/is.pl line 491
  if ($taxtotal != 0) {

bin/mozilla/ir.pl line 443
  if ($taxtotal != 0) {

SL/IS.pm line 122 and 237
  if ($taxamount != 0) {

SL/IR.pm line 167 and 288
  if ($taxamount != 0) {


I'll post a patch version later today.


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, 9 Jul 2001, Michael Bush wrote:

> Hi Everyone:
> 
> I am using SQL Ledger Version 1.4.6 and noticed when applying prorated 
> credit (i.e. 9 days @ -1.33 = $-11.97) on the entry screen it calculates it 
> properly.  However, when printing the invoice, the line for the prorated 
> item does not show the calculated total for it.  Therefore, the invoice 
> total is incorrect.
> 
> Is anyone else experiencing this issue?  If so, what would you recommend 
> solving the issue?
> 
> Regards,
> 
> Mike Bush
>