sql-ledger-users

[SQL-Ledger-users] Adding cost of parts

[<ufo...@ea...>]

Is there a way to add the cost of a part into the database without
actually purchasing it first?

			Thanks,
			    Wes

________________________________________________________________________________
From a different solar system, many many galaxies away...

Re: [SQL-Ledger-users] Adding cost of parts

[Ing. D. S. <dsi...@sq...>]

You could change the ic.cgi to allow for input of the cost.

line 303
$charge .= qq|<b> |.$locale->text('Last Cost').qq|:</b> <input name=lastcost size=10 value=$form->{lastcost} <b>$myconfig{nativecurr}</b>|;

line 507
foreach $key (qw/listprice sellprice weight lastcost/) {

line 548
number, description, listprice, lastcost,

line 553
'$uid', '$form->{description}', $form->{listprice}, $form->{lastcost},

and add
lastcost = $form->{lastcost},
at about line 531


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, 21 Jan 2001 ufo...@ea... wrote:

> Is there a way to add the cost of a part into the database without
> actually purchasing it first?
> 
> 			Thanks,
> 			    Wes
> 
> ________________________________________________________________________________
> >From a different solar system, many many galaxies away...
> 
> 

Re: [SQL-Ledger-users] Adding cost of parts

[<ufo...@ea...>]

Thanks so much for your response.  I have been out of town till tonight
and I just got your response.  This is the best accounting solution for
linux I have seen.  Please keep up the good work!

			Thanks,
			    Wes

On Mon, 22 Jan 2001,
Ing. Dieter Simader wrote:

> You could change the ic.cgi to allow for input of the cost.
>
> line 303
> $charge .= qq|<b> |.$locale->text('Last Cost').qq|:</b> <input name=lastcost size=10 value=$form->{lastcost} <b>$myconfig{nativecurr}</b>|;
>
> line 507
> foreach $key (qw/listprice sellprice weight lastcost/) {
>
> line 548
> number, description, listprice, lastcost,
>
> line 553
> '$uid', '$form->{description}', $form->{listprice}, $form->{lastcost},
>
> and add
> lastcost = $form->{lastcost},
> at about line 531
>
>
> 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, 21 Jan 2001 ufo...@ea... wrote:
>
> > Is there a way to add the cost of a part into the database without
> > actually purchasing it first?
> >
> > 			Thanks,
> > 			    Wes
> >
> > ________________________________________________________________________________
> > >From a different solar system, many many galaxies away...
> >
> >
>
>
>

________________________________________________________________________________
From a different solar system, many many galaxies away...

[SQL-Ledger-users] Cobalt RAQ2

[Fleet T. <fl...@pa...>]

Has anyone here set up SQL-Ledger on a Cobalt RAQ2 server for remote
access?  If so, any problems, lessons learned, issues, etc.?  

Regards,
						- fleet -

Re: [SQL-Ledger-users] Cobalt RAQ2

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

Fleet Teachout wrote:
> 
> Has anyone here set up SQL-Ledger on a Cobalt RAQ2 server for remote
> access?  If so, any problems, lessons learned, issues, etc.?

not RAQ specific, but here are few ideas for a remote server in general:

- SSL is a must for data confidentiality
- no (untrusted) users on server with any form of web scripting ability
(cgi/perl/php/etc..) 
- storngly consider using apache suexec feature and creating separate
account for sql-ledger

i think it would be a good idea to rewrite whole sql-ledger
authentication system before putting it into a public server, but for
starters even using crypt() instead of plaintext would be a good start..
plaintext is barely suitable on for a system on small trusted network
behind firewall but a definite no-no for server with direct Internet
connection.

--
Martin Lillepuu | E-mail: mar...@ma... | GSM: 051 56 450

Re: [SQL-Ledger-users] Cobalt RAQ2

[Fleet T. <fl...@pa...>]

Martin, thank you very much for the advise.  The security issue is my top
priority.  I'm a one-person company; as is my bookkeeper.  SQL-Ledger
solves the issue of me using Linux and him still being under the influence
of "The Evil One."  :)

						- fleet -

At 05:20 1/23/01 +0200, you wrote:
>Fleet Teachout wrote:
>> 
>> Has anyone here set up SQL-Ledger on a Cobalt RAQ2 server for remote
>> access?  If so, any problems, lessons learned, issues, etc.?
>
>not RAQ specific, but here are few ideas for a remote server in general:
>
>- SSL is a must for data confidentiality
>- no (untrusted) users on server with any form of web scripting ability
>(cgi/perl/php/etc..) 
>- storngly consider using apache suexec feature and creating separate
>account for sql-ledger
>
>i think it would be a good idea to rewrite whole sql-ledger
>authentication system before putting it into a public server, but for
>starters even using crypt() instead of plaintext would be a good start..
>plaintext is barely suitable on for a system on small trusted network
>behind firewall but a definite no-no for server with direct Internet
>connection.
>
>--
>Martin Lillepuu | E-mail: mar...@ma... | GSM: 051 56 450
>
>