sql-ledger-users — SQL-Ledger users

[SQL-Ledger-users] SQL-Ledger 1.4.2: An extremely sweet program!

[Bryan J. S. <b.j...@ie...>]

SQL-Ledger 1.4.2:  An extremely sweet program!

Didn't take much to get running under RedHat 7.1 -- which comes with
postgresql-*-7.0.3, perl-DBD-Pg-0.95 and perl-DBI 1.14 already
installed (full install).

- Extract tarball, move the "sql-ledger" directory to
  "/var/www/html" and change the ownership to
  "apache:apache"

- Su to "postgres" and create the DB

- Modify "httpd.conf" to recognize .pl as CGI, and set
  the appropriate options for the "./sql-ledger" dir
  (and restart Apache)

- Hit the setup.pl page (and setup account, with DB user
  as "postgres")

- Hit the login.pl page and have fun!
  Too easy!  Even the default templates are sweet enough!

Now I gotta learn my "bookkeeping basics" all over again.  Can
anyone recommend a good book for a small corporation (specifically,
I'm a Florida-base S-Corp if anyone is familar)?  The last time I
had any business management and bookkeeping fundamentals was 10
years ago in high school!  ;-PPP

-- TheBS

-- 
Bryan "TheBS" Smith         chat:thebs413 @AOL/MSN/Yahoo
Engineer                       mailto:b.j...@ie...
********************************************************
"Linux will do for applications what the Internet did to
 networks" -- Sam Palmisano, IBM Chief Operating Officer

Re: [SQL-Ledger-users] documentation required

[Caffeinate T. W. <moc...@ya...>]

speaking of documentations, i was looking around for some beginner's
intro into accounting terms and found them from the docs included with
gnucash http://www.gnucash.com. i think some docs like that would be
helpful for beginners wishing to use sql-ledger. 

(90% of what i learned in college i forgot, the other 10% is of no use)
accounting is one of them :)

--- adrian <ad...@sn...> wrote:
> I think that encourage new developers some documentation is required
> to
> describe the location of the various program parts, how the interact
> and
> any " programming pearls" used.
> 
> The latest version is destinctly different from the previous.
> 
> I now would like to work on an ordering module, OR has anyone already
> started?
> 
> Adrian
> 


__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/

[SQL-Ledger-users] documentation required

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

I think that encourage new developers some documentation is required to
describe the location of the various program parts, how the interact and
any " programming pearls" used.

The latest version is destinctly different from the previous.

I now would like to work on an ordering module, OR has anyone already
started?

Adrian

[SQL-Ledger-users] Swedish version

[Henrik <yj...@tn...>]

Hi all!

I wonder if there is a Swedish version of SQL-ledger. If not is it possible to get a file that I can translate.


Regards

Ingrid Lindberg
Sweden

Re: [SQL-Ledger-users] Spanish version

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

There is only one version in spanish and I don't
believe they will be separate ones for each spanish
speaking country. There may be unique transactions
associated with each country but as far as
internalization is concerned one language one version.

Solo existe una version en espanol. Es imposible de
mantener versiones en espanol para cada pais de habla
hispana. En cada pais existen transacciones unicas
pero eso no es razon para cambiar cada version.
Jerry
--- ag...@ib... wrote:
> Hi everybody!
> 
> Please excuse me for this mail written in Spanish,
> but we want to find a way to know how many spanish
> version of SQL-Ledger will exist.
> 
> Estimados usuario de SQL-Ledger en Español:
> 
> Recientemente se ha abierto una discusion acerca de
> la localizacion de SQL-Ledger (SQLL) para cada pais
> de habla hispana.
> 
> Esperando llegar a un acuerdo entre los hispano
> parlantes acerca de cuantas versiones de SQLL
> existiran, escribo este mensaje.
> 
> Actualmente existen dos opiniones:
> 
> 1- Mantener una version unica de SQL-Ledger en
> español.
> 2- Crear una version especial para cada pais.
> (Actualmente esta es la tendencia que lleva
> SQL-Ledger).
> 
> Yo estoy de acuerdo con la primera opcion porque:
> 
> 1-Aunque entiendo muy bien lo que son los
> regionalismos y particularidades de cada pais. Creo
> que es muy bueno que podamos comunicarnos todos en
> el mismo idioma.
> 
> 2-No soy un experto en contabilidad, pero creo que
> entre los contadores de todos los paises hispanos
> utilizan los mismo terminos. (Apelo a los terminos
> correctos en español, no a los anglicismos empleados
> en algunos paises).
> 
> 3-Por otro creo que la realidad lationamericana es
> un poco diferente de España, según lo planteado por
> el Eugenio en un correo enviado. Pero a nivel
> latinoamericano se usan los mismos terminos. Debido
> a esto es posible que pueda existir una version para
> España (Aunque tengo mis dudas).
> 
> 4-La ventaja de mantener un solo lenguaje ahorra
> esfuerzos. En lugar de utilizar esfuerzos en
> regionalizar para cada pais, podemos unir esfuerzos
> y mejorar la calidad de la documentacion en español.
> 
> Bueno, estos son algunos de los motivos que tengo
> ahora en mente. Espero sus comentarios y les
> agradezco de antemano su colaboracion para hacer
> mejor este sistema del que nos beneficiamos todos.
> 
> Saludos,
> 
> Ing. Antonio Gallardo
> AG Software
> Managua, NICARAGUA.
> 
> 
> 


__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/

[SQL-Ledger-users] Spanish version

[<ag...@ib...>]

Hi everybody!

Please excuse me for this mail written in Spanish, but we want to find a =
way to know how many spanish version of SQL-Ledger will exist.

Estimados usuario de SQL-Ledger en Espa=F1ol:

Recientemente se ha abierto una discusion acerca de la localizacion de SQ=
L-Ledger (SQLL) para cada pais de habla hispana.

Esperando llegar a un acuerdo entre los hispano parlantes acerca de cuant=
as versiones de SQLL existiran, escribo este mensaje.

Actualmente existen dos opiniones:

1- Mantener una version unica de SQL-Ledger en espa=F1ol.
2- Crear una version especial para cada pais. (Actualmente esta es la ten=
dencia que lleva SQL-Ledger).

Yo estoy de acuerdo con la primera opcion porque:

1-Aunque entiendo muy bien lo que son los regionalismos y particularidade=
s de cada pais. Creo que es muy bueno que podamos comunicarnos todos en e=
l mismo idioma.

2-No soy un experto en contabilidad, pero creo que entre los contadores d=
e todos los paises hispanos utilizan los mismo terminos. (Apelo a los ter=
minos correctos en espa=F1ol, no a los anglicismos empleados en algunos p=
aises).

3-Por otro creo que la realidad lationamericana es un poco diferente de E=
spa=F1a, seg=FAn lo planteado por el Eugenio en un correo enviado. Pero a=
 nivel latinoamericano se usan los mismos terminos. Debido a esto es posi=
ble que pueda existir una version para Espa=F1a (Aunque tengo mis dudas).

4-La ventaja de mantener un solo lenguaje ahorra esfuerzos. En lugar de u=
tilizar esfuerzos en regionalizar para cada pais, podemos unir esfuerzos =
y mejorar la calidad de la documentacion en espa=F1ol.

Bueno, estos son algunos de los motivos que tengo ahora en mente. Espero =
sus comentarios y les agradezco de antemano su colaboracion para hacer me=
jor este sistema del que nos beneficiamos todos.

Saludos,

Ing. Antonio Gallardo
AG Software
Managua, NICARAGUA.

Re: [SQL-Ledger-users] Internal Server Error on login

[Benjamin L. <ben...@co...>]

Dieter,

I was just about to look into this.

The error occurs when a user changes their preferences in Setup.

What it looks like is that the passwd crypt is doing the crypt again
and thus corrupting the passwords. The fix is to go and reset the
user's password (both for SL and database) in setup.pl.





On Sun, May 13, 2001 at 03:10:04PM +1000, Garrick Cobcroft wrote:
> Hi all,
> 
> DBI and DBD::Pg appear to be installed correctly, however, I am getting
> an Internal Server Error on attempting to login.  The messages from the
> apache error log are attached.
> 
> Any help would be appreciated.
> Garrick
> DBI->connect(dbname=accounts;host=localhost;port=5432) failed: PQconnec at /var/www/html/sql-ledger/login.cgi line 65
> Can't call method "prepare" on an undefined value at /var/www/html/sql-ledger/login.cgi line 78.


-- 
B.      http://makelinux.org/    "Always real."    http://realthought.net/
__________________________________________________________________________
Life is divided into the horrible and the miserable.
		-- Woody Allen, "Annie Hall"

[SQL-Ledger-users] Accounting terms

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

hello,

I'm translating sql-ledger chart and ran across following terms:

EI Expense
CPP Expense
WCB Expense

I'd appreciate if somebody could explain me what those abbreviations mean. 

--
martin

Re: [SQL-Ledger-users] apache problem

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

adrian wrote:
> 
> Just trying to upgrade to version 1.4.1  but get error
> 
> " You don't have permission to access /cgi-bin/sql-ledger/setup.pl on
> this server "
> 
> I assume that it is because it does not like the symbolic links. What is
> the line to add to the apache's httpd.conf file?
> 
> Adrian

YES,

make sure that your http.conf contains something like this:

<Directory "/var/lib/apache/cgi-bin">
        AllowOverride None
        Options FollowSymLinks
        Order allow,deny
        Allow from all
    </Directory>          

Adrian

[SQL-Ledger-users] apache problem

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

Just trying to upgrade to version 1.4.1  but get error 

" You don't have permission to access /cgi-bin/sql-ledger/setup.pl on
this server "

I assume that it is because it does not like the symbolic links. What is
the line to add to the apache's httpd.conf file?

Adrian

[SQL-Ledger-users] DBD::Pg::st execute failed: ERROR: chart: Permission denied.

[Noel K. <no...@ko...>]

Hello,

I downloaded version 1.4.1 and want to use it with postgresql 7.x.

First problem was the switch from .cgi -> .pl but its solved now.

I can use sql-ledger/login.pl?terminal=mozilla to configure new
users. When I login I get this back in the apache error log:

[Mon May 14 13:42:24 2001] [error] [client 172.26.14.10] Premature end of
script headers: /var/www/sql-ledger/login.pl
DBD::Pg::st execute failed: ERROR:  chart: Permission denied.

I made a chmod -R 777 /var/www/sql-ledger/ to reduce the possible problems
with filepermissions ( its only a testsetup ! ).

I don't know what the problem could be.:(

-- 
Noch einen schoenen Tag

	Noel

Re: [SQL-Ledger-users] PHP version of sql-ledger

[Guido B. <gd...@le...>]

Michael Diehl wrote:
> 
> > What does php offer over perl?
> >
> 
> At the end it boils down to personal preference and experience.

In the past I was start with PHP development of WEB project, but 2 next years I have change to Perl, because PHP isn't complete script language.

The opinion of single man is not sufficient to sign the future of SQL-Ledger.
Your decision to port it in PHP have the result to fragment the support to the project; I don't see problem to have PHP & Perl code on same WEB Server.

best regards
Guido Brugnara


> 
>***cut***
> 
> regards, Michael

-- 
ing. Guido Brugnara tel.+39(461)390804 fax.396028
Leader.IT S.r.l.  (Leader Information Technology)
Strada della Pozzata, 41        www.leader.it/srl
38050 Villazzano TRENTO (ITALY)    in...@le...

Re: [SQL-Ledger-users] why PHP

[Antti K. <aka...@si...>]

I think the most important reason for PHP's popularity is that it's
designed to be easily hosted for use in user space. ISPs offering
uncontrolled perl CGI are rare, but almost everyone allows PHP without
extra hassle.

---------------------------------------
Antti Kaihola
Ambitone Oy, Helsinki, Finland

Päivän palindromi:
  "Aava ratsuni, musta ravikoni Eino, kiva ratsu minusta, ravaa."

Re: [SQL-Ledger-users] PHP version of sql-ledger

[<li...@li...>]

On Sun, May 13, 2001 at 12:39:26PM -0400, Michael Diehl was heard to remark:
> 
> PHP works like ASP or JSP so that you can include PHP code in your HTML
> page,  it just has top be escaped with <?PHP ... your code... ?>. 
> So it fits more with the most popular way of doing things at the moment.
> When you are using templates, this becomes a bit meaningless, of course.
> (And you can integrate Perl into the server as well)

FYI, 'eperl' by ralf engelschall does the same thing for perl.
It was recently converted to an apache module (mod_eperl, I beleive).
I think the escape is <? but I think <: also works ... 

--------
I find the history of php peculiar ... my (warped) understanding of it
is that it was even in the begining meant to be a perl-look & work-alike
but with more database support and the <? escape from html... and then 
one day, it took on a life of its own ...  what i find stange is that
a couple of quick hacks could have added <? support, and then php would
never have happened (e.g. if eperl was created in 1995 instead of 1998
or whenever ...)


-- 
Linas Vepstas -- li...@gn... -- http://www.gnumatic.com/

Re: [SQL-Ledger-users] PHP version of sql-ledger

[Michael D. <mi...@mi...>]

> What does php offer over perl?
>

At the end it boils down to personal preference and experience.

I did a bit of perl back at the university but was never really good at it. 
The main difference from my experience is that perl has a steeper 
learning curve.

PHP works like ASP or JSP so that you can include PHP code in your HTML
page,  it just has top be escaped with <?PHP ... your code... ?>. 
So it fits more with the most popular way of doing things at the moment.
When you are using templates, this becomes a bit meaningless, of course.
(And you can integrate Perl into the server as well)

There is quite a bit code for PHP out there. The quality tends to be lower
than what perl has with CPAN but it is generally more Web centric and there 
are some libraries which are excellent (e.g. phplib, http://phplib.netuse.de)

I started my port to PHP mainly because I had allready some code written
and because with phplib you get session handling (no hidden form fields
anymore), db-abstraction and a simple authorization concept just by starting 
you HTML page with:

<?php
page_open(array("sess" => "Session",
                            "auth" => "Auth",
                            "perm" => "Perm"));
$perm->check("service");     // Checks if the user has permission "service"
$user_name = $auth->auth["uname"] ;
$language = $auth->auth["lang"] ;
?>
<HTML> ......

The ass. arrays work very similar to perl.

Some comparison PHP-Perl: 
http://php.resourceindex.com/Documentation/Reviews_and_Analysis/PHP_vs._Perl/
http://www.koehntopp.de/php/faq-phpinterpreter.html#phpinterpreter-2 
(in depth but in german)

IMHO the best book on PHP is "Web Application Development With PHP" by 
Ratschiller, Tobias, and Gerken, Till.  (http://www.phpwizard.net/book/)


For the beginnings of a PHP port look at 
http://www.michaeldiehl.com/~michael/etc/
It is not really a port, only the reporting and GL functionality is a 1:1 
port. The AR and AP part is done differently and handling of multiple 
companies is done via a key in all relevant db tables.

regards, Michael

[SQL-Ledger-users] Internal Server Error on login

[Garrick C. <cga...@bi...>]

Hi all,

DBI and DBD::Pg appear to be installed correctly, however, I am getting
an Internal Server Error on attempting to login.  The messages from the
apache error log are attached.

Any help would be appreciated.
Garrick

[SQL-Ledger-users] Problem with suEXEC

[Rodney <ro...@ra...>]

Just upgraded to 1.4.0

I had this problem in a much older version of SQL-Ledger. The problem is I
use Apache with suEXEC enable for SQL-Ledger programs. The suEXEC doesn't
like the symbolic links. I just changed the symbolic links to copies of
admin.pl, ie; rm menu.pl ; cp admin.pl menu.pl. This fixed everything but
is there an Apache setting to enable this. I already have FollowSymLinks
in the options. 

The error I get on every symbolic link is: cannot stat program (prg.name)
example: cannot stat program (menu.pl).
The error is recorded in my suexec_log file. The error in the browser is
just an internal error occurred.


     \\\|||///
     \ ~   ~ /
    | @    @ |
-oOo---(_)---oOo-----------------------------------------------

	RAM Technical
	Rodney Mosley
	Systems Administration
	E-Mail:ro...@ra...
	http://www.ramnic.com

========================================================================
	Check out http://www.setfree.org It can change your life.
========================================================================

Re: [SQL-Ledger-users] PHP version of sql-ledger

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

What does php offer over perl?


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, 11 May 2001 ag...@ib... wrote:

> I will be very glad to work on the team to port SQL-Ledger to PHP!
> 
> 
> > 
> > From: Caffeinate The World <moc...@ya...>
> > Date: 2001/05/09 Wed PM 07:42:30 CDT
> > To: sql...@li...
> > Subject: [SQL-Ledger-users] PHP version of sql-ledger
> > 
> > has anyone made any effort porting sql-ledger to PHP?
> > 
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Auctions - buy the things you want at great prices
> > http://auctions.yahoo.com/
> > 
> > 
> > 
> 
> 
> 

Re: [SQL-Ledger-users] Q. on the TO-DO list. (Payroll update)

[R. R. <ri...@me...>]

On Thu, 10 May 2001, Linas Vepstas wrote:

> On Thu, May 10, 2001 at 03:23:21PM -0400, Wayne was heard to remark:

> > One enity that is present is a "Party", a party is
> > a person or and organization. One then associates
> > a relationship to a "Party". This will help to reduce
> > data redundancy. For example, if I have an employee
> > that happens to be a vendor, then the party is in
> > my DB only once , as a person, and I only have to
> > establish the relationship this enity has. That

> Bad example.

Bad idea, too.

The typical example would be a combined vendor &
customer.  The administration and logic involved doesn't 
seem to warrant the normalization.  Think about it.
Whose "owns" the data, the A/R or the A/P people.

When you normalize this junk you end up with a useless 
entity{ id, name, canonical_address }
which may be duplicated anyway, if there are variations
in name or address.

If A/P and A/R data are purged sometime, what happens
to the empty-nested entity.  If the canonical address
is not the same as the childrens, no one may be sure
who this is.  Yes this may be eased by sharing
the "id", but this has its own problems.


> employee is paying you kickbacks, I think that may 

More usual is putting someone on a payroll
as a kickback.

rob                     Live the dream.

Re: [SQL-Ledger-users] Asset Depreciation

[<ag...@ib...>]

I think we can create some "transactions templates". For some recurrently transactions.

We just review the transaction and generate them!

For example some transactions like gas purchase are very similars. We just enter the amount and the system make the rest!

For the problem below we must to take the company inventory before we can make any depreciation.

Antonio.

> 
> From: Mark Lehrer <ma...@kn...>
> Date: 2001/05/10 Thu PM 02:33:46 CDT
> To: sql...@li...
> Subject: [SQL-Ledger-users] Asset Depreciation
> 
> 
> Hi there; I'm currently using SQL Ledger as a very basic invoice
> generator, and it is excellent.  However, the accounting dept. at
> my "real" job has asked about a way to do asset depreciation - is
> this a feature in SQL Ledger currently?  If not, how much pain
> would be involved in adding it?  We have the tax tables and know
> how to calculate it, if integrating it into the database isn't
> too agonizing, this might work.
> 
> Thanks,
> Mark
> 
> 
> 

Re: [SQL-Ledger-users] PHP version of sql-ledger

[<ag...@ib...>]

I will be very glad to work on the team to port SQL-Ledger to PHP!


> 
> From: Caffeinate The World <moc...@ya...>
> Date: 2001/05/09 Wed PM 07:42:30 CDT
> To: sql...@li...
> Subject: [SQL-Ledger-users] PHP version of sql-ledger
> 
> has anyone made any effort porting sql-ledger to PHP?
> 
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Auctions - buy the things you want at great prices
> http://auctions.yahoo.com/
> 
> 
> 

Re: [SQL-Ledger-users] Q. on the TO-DO list. (Payroll update)

[Steve D. <sd...@sw...>]

Hi Wayne.

Matt Benjamin wrote:

> I have to say, I think the "employee also your customer" notion is
> somewhat strained.  I doubt it leads to much data redundancy.
>
> Offhand, possibly "your vendor is also your customer" is more common, and
> maybe is more relevant.

I agree here, but even in a customer/employee situation, those are two
unique relationships and the data should probably be grouped together even
if redundant.  I still don't think the redundancy would be extensive. It
would only be the name, contact, and residence info anyway.  Billing terms,
sales tax, wage rates, withholdings, and all of the other data is unique to
the relationship as either customer or employee.

I have gotten burned by this situation where a company only updated a CRM
app (Siebel) for customer address changes without considering what was in
the shipping data in their accounting app.  Someone spent up to an hour a
day trying to keep them in sync across the customer base.  This was a big
problem, because when customers ordered things, they sometimes went to the
wrong address, and it made the company look like idiots.

I think this will be okay.  And since this is free software, if it presents
a problem, you can "fix" it.

Thanks for the input.
Steve

>
>
> matt
>
> Matt Benjamin President/CTO
>
> The Linux Box
> 206 South Fifth Ave. Suite 150
> Ann Arbor, MI  48104
>
> tel. 734-761-4689
> fax. 734-769-8938
> pgr. 734-431-0118
>
> On Thu, 10 May 2001, Wayne wrote:
>
> > Hi Linas,
> > I know of many companys that have employees
> > that use there sevice for other work. For example
> > I have one company that  has an employee that
> > has his own business doing lawn care. This
> > employee is a welder during the day for said
> > company. On weekend he does the out ground
> > care for this company.
> > Wayne
> >
> > Linas Vepstas wrote:
> >
> > > On Thu, May 10, 2001 at 03:23:21PM -0400, Wayne was heard to remark:
> > > > Hi  Steve,
> > > > This book has good data model for  a business.
> > > > One enity that is present is a "Party", a party is
> > > > a person or and organization. One then associates
> > > > a relationship to a "Party". This will help to reduce
> > > > data redundancy. For example, if I have an employee
> > > > that happens to be a vendor, then the party is in
> > > > my DB only once , as a person, and I only have to
> > > > establish the relationship this enity has. That
> > >
> > > Bad example.
> > >
> > > If you have employees who also act as vendors to you,
> > > you are putting yourself into a conflict of interest.
> > > If you're the sole owner, hey, that's up to you, but
> > > if you work for a larger company, that's grounds for
> > > getting yourself and your employee fired.   If the
> > > employee is paying you kickbacks, I think that may
> > > even be a felony under rico.
> > >
> > > --linas
> > >
> > > --
> > > Linas Vepstas -- li...@gn... -- http://www.gnumatic.com/
> >
> >

Re: [SQL-Ledger-users] Q. on the TO-DO list. (Payroll update)

[Matt B. <ma...@li...>]

I have to say, I think the "employee also your customer" notion is
somewhat strained.  I doubt it leads to much data redundancy.

Offhand, possibly "your vendor is also your customer" is more common, and
maybe is more relevant.


matt


Matt Benjamin President/CTO

The Linux Box
206 South Fifth Ave. Suite 150
Ann Arbor, MI  48104

tel. 734-761-4689
fax. 734-769-8938
pgr. 734-431-0118

On Thu, 10 May 2001, Wayne wrote:

> Hi Linas,
> I know of many companys that have employees
> that use there sevice for other work. For example
> I have one company that  has an employee that
> has his own business doing lawn care. This
> employee is a welder during the day for said
> company. On weekend he does the out ground
> care for this company.
> Wayne
>
> Linas Vepstas wrote:
>
> > On Thu, May 10, 2001 at 03:23:21PM -0400, Wayne was heard to remark:
> > > Hi  Steve,
> > > This book has good data model for  a business.
> > > One enity that is present is a "Party", a party is
> > > a person or and organization. One then associates
> > > a relationship to a "Party". This will help to reduce
> > > data redundancy. For example, if I have an employee
> > > that happens to be a vendor, then the party is in
> > > my DB only once , as a person, and I only have to
> > > establish the relationship this enity has. That
> >
> > Bad example.
> >
> > If you have employees who also act as vendors to you,
> > you are putting yourself into a conflict of interest.
> > If you're the sole owner, hey, that's up to you, but
> > if you work for a larger company, that's grounds for
> > getting yourself and your employee fired.   If the
> > employee is paying you kickbacks, I think that may
> > even be a felony under rico.
> >
> > --linas
> >
> > --
> > Linas Vepstas -- li...@gn... -- http://www.gnumatic.com/
>
>

Re: [SQL-Ledger-users] Q. on the TO-DO list. (Payroll update)

[<li...@li...>]

OK, this sounds innocuous enough, because there is some=20
distance, and the job functions/authorites are unrelated.

For example: Mr. X, has a job as the bolt buyer for DrillHole=20
Inc..  He always specifies bolts from Threadless Cos.  This=20
might be because Threadless Cos. makes better bolts, or because
Threadless is 25% owned by Mr. X.  (Did we mention that
Threadless's biggest customer is DrillHole, and that it would go
under if it weren't for DrillHole's juicy contracts?)

--linas


On Thu, May 10, 2001 at 06:49:36PM -0400, Wayne was heard to remark:
> Hi Linas,
> I know of many companys that have employees
> that use there sevice for other work. For example
> I have one company that  has an employee that
> has his own business doing lawn care. This
> employee is a welder during the day for said
> company. On weekend he does the out ground
> care for this company.
> Wayne
>=20
> Linas Vepstas wrote:
>=20
> > On Thu, May 10, 2001 at 03:23:21PM -0400, Wayne was heard to remark:
> > > Hi  Steve,
> > > This book has good data model for  a business.
> > > One enity that is present is a "Party", a party is
> > > a person or and organization. One then associates
> > > a relationship to a "Party". This will help to reduce
> > > data redundancy. For example, if I have an employee
> > > that happens to be a vendor, then the party is in
> > > my DB only once , as a person, and I only have to
> > > establish the relationship this enity has. That
> >
> > Bad example.
> >
> > If you have employees who also act as vendors to you,
> > you are putting yourself into a conflict of interest.
> > If you're the sole owner, hey, that's up to you, but
> > if you work for a larger company, that's grounds for
> > getting yourself and your employee fired.   If the
> > employee is paying you kickbacks, I think that may
> > even be a felony under rico.
> >
> > --linas
> >
> > --
> > Linas Vepstas -- li...@gn... -- http://www.gnumatic.com/
>=20

--=20
Linas Vepstas -- li...@gn... -- http://www.gnumatic.com/

Re: [SQL-Ledger-users] Q. on the TO-DO list. (Payroll update)

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

Hi Linas,
I know of many companys that have employees
that use there sevice for other work. For example
I have one company that  has an employee that
has his own business doing lawn care. This
employee is a welder during the day for said
company. On weekend he does the out ground
care for this company.
Wayne

Linas Vepstas wrote:

> On Thu, May 10, 2001 at 03:23:21PM -0400, Wayne was heard to remark:
> > Hi  Steve,
> > This book has good data model for  a business.
> > One enity that is present is a "Party", a party is
> > a person or and organization. One then associates
> > a relationship to a "Party". This will help to reduce
> > data redundancy. For example, if I have an employee
> > that happens to be a vendor, then the party is in
> > my DB only once , as a person, and I only have to
> > establish the relationship this enity has. That
>
> Bad example.
>
> If you have employees who also act as vendors to you,
> you are putting yourself into a conflict of interest.
> If you're the sole owner, hey, that's up to you, but
> if you work for a larger company, that's grounds for
> getting yourself and your employee fired.   If the
> employee is paying you kickbacks, I think that may
> even be a felony under rico.
>
> --linas
>
> --
> Linas Vepstas -- li...@gn... -- http://www.gnumatic.com/