sql-ledger-users — SQL-Ledger users

Re: [SQL-Ledger-users] LARGE INVENTORY

[Thomas S. <ps...@on...>]

Yes to #3!

After some more thought #3 is what I came up with too. That is to say:
It would be most convinent I think to simply put a limit on the number
of records returned.  There could be a criteria field adjusted from the
search page for maximum flexiblity where 0 or blank could mean return
all records and it could default to say 1000 or default from a new field
added to the user record(or where?) For now I'm just going to see if
I can hardcode a LIMIT of 1000 in the SQL statment. That is if Postgres
supports the LIMIT clause like MySQL does. Otherwise I'll have to put
a limit on the loop that generates the HTML. Either way, but the SQL
way would be more efficient.

 
Thomas Sawyer
ps...@on... - email


-- 
Thomas Sawyer
ps...@on... - email
(303) 285-3487 x1594 - voicemail/fax



---- Martin Lillepuu <ma...@li...> wrote:
> Thomas Sawyer wrote:
> 
> > I have to get this working with this a large inventory. So I'm looking
> > at adding some selection criteria limitations to the ic.cgi script.
> I'm
> > thinking of adding limiting criteria where one has to select the
> first
> > and second letter of the search. (i.e. Aa, Ab, Ac...Zx, Zy, Zz) How
> does
> > this sound to you all? Any other ideas?
> 
> maybe you should create a new parameter (eq. min_search_str_length)
> in
> configuration page, so people with small inventories (like me) can
> set
> it to 0 and in your case, it can be set to 2, 3 or whatever. then add
> code to ic.cgi that displays error message if search string is shorter
> than value specified in config. does this make any sense or am I
> over-complicating things again? :)
> 
> another idea to consider is grouping inventory items, so that you first
> select group and then only products belonging to specified group are
> displayed.
> 
> idea #3 - limit displaying inventory items on one page (does PostgreSQL
> have equivalent to MySQL LIMIT?). Maybe implement this throughout the
> program + another option to config page?
> 
> --
> Martin Lillepuu | E-mail: ma...@li... | GSM: 051 56 450
> 
> 

__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

Re: [SQL-Ledger-users] Documentation?

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

Accounts are linked with keywords. You see them listed when you go to
setup and list the accounts. In a prior message I explained what these
keywords mean. The messages are archived at sourceforge. A link to the
archive can be found at http://www.sql-ledger.org/misc/support.html

Also checkout the screenshots page. It gives a bit of an explaination
what you can do and how some things work.


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, 6 Feb 2001, Mark Tiramani wrote:

> Is there any documentation available (appart from the homepage FAQ) for SQL-Ledger, basically 
> for a bit of a beginner, that explains some of the interfaces? Although I've been doing my own 
> very-small-business accounts for 20+ years I obviously don't get the way accounts are linked 
> here.
> 
> I'd love to get to grips with SQL-Ledger since I use perl and postgres in our web business and 
> it's the first package I've seen that fits the way we do most things via a browser and web/db back-
> end. It also appears to offer everything we need, but without the crazy overbloat that off-the-shelf 
> commercial packages bewilder us with.
> 
> Appologies if this is just too dumb a question here.... go ahead and scream at me :)
> 
> Mark
> 
> Mark Tiramani
> FREDO Internet Services
> ma...@fr...
> 
> 

[SQL-Ledger-users] Documentation?

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

Is there any documentation available (appart from the homepage FAQ) for SQL-Ledger, basically 
for a bit of a beginner, that explains some of the interfaces? Although I've been doing my own 
very-small-business accounts for 20+ years I obviously don't get the way accounts are linked 
here.

I'd love to get to grips with SQL-Ledger since I use perl and postgres in our web business and 
it's the first package I've seen that fits the way we do most things via a browser and web/db back-
end. It also appears to offer everything we need, but without the crazy overbloat that off-the-shelf 
commercial packages bewilder us with.

Appologies if this is just too dumb a question here.... go ahead and scream at me :)

Mark

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

Re: [SQL-Ledger-users] 403 Forbidden

[Richard E. II <win...@ya...>]

I got past that but now when I try to log in I
get an internal error. Any guess on that one?

Thanks 
rick

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

Re: [SQL-Ledger-users] LARGE INVENTORY

[John C. <jcu...@ho...>]

Thomas,

I just fired up the system and so I have not retrieved an
inventory of items yet, but if it puts them into a large 
html table
then you could get a count first and the set the size of the
table first. The will speed up the loading of the page if 
the browser
knows the size of the table first (it fills at it goes 
instead of waiting
for the complete download and then putting the table on the 
screen)

Or you could set up a cursor to fetch 20 at a time. I don't 
have these
solutions directly in front of me and am doing from memory 
on some
inventory issues from a previous job.  There are examples in 
PHP postgres
on how to do this and there is some CPAN stuff for postgres 
on how to do this.

I'll look around and see what I can come up with.

John C.

Thomas Sawyer wrote:

> Hi again... 
> 
> The bigger thing is that I just loaded up the database with 25,000+ inventory
> records! Postgresql handled it nicely, loading them from an .sql file
> of insert staements in about 5 minutes.
> 
> But when I went to my windows client machine and did an inventory search
> on all the items it took nearly 30 minutes to load the page! It worked
> though so that's good! The slow down apparently comes from building such
> a large page --not so much the transfer via the network. CGI Perl isn't
> all that fast. Is there any way to speed this up?
> 
> One thing that happened during the course of this load is that Windows
> 2000 reported that it needed to increase Virtual memory to complete the
> operation I bet it did! That's one big .html file!
> 
> I have to get this working with this a large inventory. So I'm looking
> at adding some selection criteria limitations to the ic.cgi script. I'm
> thinking of adding limiting criteria where one has to select the first
> and second letter of the search. (i.e. Aa, Ab, Ac...Zx, Zy, Zz) How does
> this sound to you all? Any other ideas?

Re: [SQL-Ledger-users] 403 Forbidden

[John C. <jcu...@ho...>]

Rick,

You will probably have to review your directory structure in 
http.conf

What is it?  on redhat for example, it is home/http/html/ 
and all standard
docs are here - the doc root for the web. If you have it 
located in
/home/http/sql-ledger/ for example, it is forbidden because 
it is not in
the document root

Go to yourconfiguration file for apache, if that's what 
you're using, read
through it with your directory structure in mind, and you 
should be able
to fix it.

Good luck

JC

Richard Eicher II wrote:

> I get a 403 Forbidden when I try to pull up
> setup.cgi. I have configure the .htaccess and
> ..htpasswd files. Any one ran into this problem?
> 
> Thank you for your time,
> rick
> 
> __________________________________________________
> Get personalized email addresses from Yahoo! Mail - only $35 
> a year!  http://personal.mail.yahoo.com/

Re: [SQL-Ledger-users] tracking Payments, Bills in Sql-Ledger

[Adrian B. <ad...@sn...>]

Mark Williamson wrote:
> 
> Hi All,
> 
> I have been working through the issues of SQL-Ledger, to see if it is
> possible to run my business off it.
> 
> At this moment it does not look like that I will be able to use the
> Sql-ledger for my business as the tracking of payments from customers and
> bill paying does not seem to be there.  The tracking that seems to be
> missing, is the tracking of cheque numbers, payment type (cash or cheque
> etc), and the dates of part payments.
> 
> Things that I really liked about the software, is the way the chart of
> accounts works, and the links idea is great.  Networking of the package
> is excellent, with in just over a slow Internet connection, sql-ledger
> is quite useful.
> 
> --------------------------------
> Some suggestions for the future.
> --------------------------------
> 
> Have the dates field fill in with a suggested date of todays date..
> Important if you about to make an invoice to hand to someone..  of
> course one can change the before finishing the invoice.
> 
> Just wondering if a invoice is printed should it be posted at the same
> time? as a invoice can printed from the browser, but if one hits one of
> the menu items from the frame the invoice would have disappeared forever
> from the system, even through the invoice was printed.
> 
> The recording of part payments, cheque numbers, payment type.
> 
> The show of what a customer owes when listing the customers
> 
> Purchase orders,  it would be great to trace your inventory right from
> the time of ordering items.
> 
> ---------------------------------------------------------------
> Some problems that I can see as the sql-ledger fills up with
> Transactions
> ---------------------------------------------------------------
> 
> There could be a problem with Netscape with large drop down lists to
> select a customer to bill etc..  that if a business has quite a few
> hundred customers.
> 
> The recording of payment details on the original receipts..  it's in
> fact changing the invoice after it has been posted.  Not sure but it
> could be better if the payment s should up on a separate Statement, or a
> printable receipt
> 

The suggestions are excellent. I am using it for my business at present
and hope that some or all of the improvements will be available in time.

Adrian
-- 
Adrian Blake  (MIEEE)
Smart Radio Systems Pty Ltd
26b Bombala St, Cooma, NSW 2630, Australia
Ph 61-2-64525555 Fax 61-2-64524317

Re: [SQL-Ledger-users] LARGE INVENTORY

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

Thomas Sawyer wrote:

> I have to get this working with this a large inventory. So I'm looking
> at adding some selection criteria limitations to the ic.cgi script. I'm
> thinking of adding limiting criteria where one has to select the first
> and second letter of the search. (i.e. Aa, Ab, Ac...Zx, Zy, Zz) How does
> this sound to you all? Any other ideas?

maybe you should create a new parameter (eq. min_search_str_length) in
configuration page, so people with small inventories (like me) can set
it to 0 and in your case, it can be set to 2, 3 or whatever. then add
code to ic.cgi that displays error message if search string is shorter
than value specified in config. does this make any sense or am I
over-complicating things again? :)

another idea to consider is grouping inventory items, so that you first
select group and then only products belonging to specified group are
displayed.

idea #3 - limit displaying inventory items on one page (does PostgreSQL
have equivalent to MySQL LIMIT?). Maybe implement this throughout the
program + another option to config page?

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

RE: [SQL-Ledger-users] DOCUMENTATION

[Ing. A. A. G. <ag...@ma...>]

Good job!

We have currently enhanced an Upsizing Tool from MS Access to =
PostgresSQL
7.0.3 the Tool in question will be posted in the next days after
confirmation from his author to them them on a sourgeforce project.

The tool transfer structure an d data from Access to Postgres.

Regads,

Antonio Gallardo.



-----Mensaje original-----
De: sql...@li...
[mailto:sql...@li...]En nombre de =
Thomas
Sawyer
Enviado el: S=E1bado, 03 de Febrero de 2001 05:49 p.m.
Para: sql...@li...
Asunto: Re: [SQL-Ledger-users] DOCUMENTATION


Finally but not least...

I wrote a Visual Basic program called SQL Post which will take a =
Microsoft
Access Table and translate it into a set of insert statements and save
them to a .sql file. This makes it easy to move Access data to =
Postgresql.
(That's how I loaded my 25,000+ inventory records!) I upload it to =
ZDNet
so it should be available there is a week or so. If anyone would like
a copy of it sooner let me know, I can email attach it to them (it's
only 88k in size).

--=20
Thomas Sawyer
ps...@on... - email


__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

[SQL-Ledger-users] 403 Forbidden

[Richard E. II <win...@ya...>]

I get a 403 Forbidden when I try to pull up
setup.cgi. I have configure the .htaccess and
.htpasswd files. Any one ran into this problem?

Thank you for your time,
rick

__________________________________________________
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/

Re: [SQL-Ledger-users] DOCUMENTATION

[Thomas S. <ps...@on...>]

Finally but not least...

I wrote a Visual Basic program called SQL Post which will take a Microsoft
Access Table and translate it into a set of insert statements and save
them to a .sql file. This makes it easy to move Access data to Postgresql.
(That's how I loaded my 25,000+ inventory records!) I upload it to ZDNet
so it should be available there is a week or so. If anyone would like
a copy of it sooner let me know, I can email attach it to them (it's
only 88k in size).

-- 
Thomas Sawyer
ps...@on... - email


__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

[SQL-Ledger-users] LARGE INVENTORY

[Thomas S. <ps...@on...>]

Hi again... 

The bigger thing is that I just loaded up the database with 25,000+ inventory
records! Postgresql handled it nicely, loading them from an .sql file
of insert staements in about 5 minutes.

But when I went to my windows client machine and did an inventory search
on all the items it took nearly 30 minutes to load the page! It worked
though so that's good! The slow down apparently comes from building such
a large page --not so much the transfer via the network. CGI Perl isn't
all that fast. Is there any way to speed this up?

One thing that happened during the course of this load is that Windows
2000 reported that it needed to increase Virtual memory to complete the
operation I bet it did! That's one big .html file!

I have to get this working with this a large inventory. So I'm looking
at adding some selection criteria limitations to the ic.cgi script. I'm
thinking of adding limiting criteria where one has to select the first
and second letter of the search. (i.e. Aa, Ab, Ac...Zx, Zy, Zz) How does
this sound to you all? Any other ideas?




-- 
Thomas Sawyer
ps...@on... - email


__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

[SQL-Ledger-users] DOCUMENTATION

[Thomas S. <ps...@on...>]

Well I'll be!

Since the emails are all stored in a central place I guess I'll begin
the process of putting together some documentation. All right with you
all? If there are any other documents I need to include let me know or
email me at ps...@on....

I have a good bit of experience here so I think I can throw together
a rough in short order.

But right now I'm working on some bigger things...so give me time...

-- 
Thomas Sawyer
ps...@on... - email




---- Martin Lillepuu <ma...@li...> wrote:
> Keld Jørn Simonsen wrote:
> > 
> > On Sat, Feb 03, 2001 at 10:30:50AM -0700, Dieter Simader wrote:
> > > The messages are all archived at sourceforge.
> > 
> > Where? Is there an URL?
> 
> http://www.geocrawler.com/lists/3/SourceForge/7966/0/
> 
> Not difficult at all to find, btw..
> 
> --
> Martin Lillepuu | E-mail: ma...@li... | GSM: 051 56 450
> 
> 

__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

Re: [SQL-Ledger-users] Accounting Links

[Thomas S. <ps...@on...>]

A nice summary! Thank you. I'll save this email. Looks like I'll be putting
together some documentation based on these emails. I played with sql-ledger
some more and it all makes sense now, expect for one thing.

The taxes for customer invoices and vendor invoices should not be the
same should they? I mean a customer may pay in-state taxes to you while
you may pay varying taxes in-state or out-of-state or what-not to your
vendors. How does one deal with this? I suppose in most cases it will
be either an in-state GRT (general receipts tax) or Exempt, but I imagine
there could be other cases. Also it looks as if you have to use one of
the two tax entires for Exempt (i.e. 0%) since there are only two choices,
right?

-- 
Thomas Sawyer
ps...@on... - email
(303) 285-3487 x1594 - voicemail/fax



---- Dieter Simader <dsi...@sq...> wrote:
> The links tie everything together. They also indicate which accounts
> are
> to be included in the drop down lists.
> 
> 
> --- Edit Account ---
> Account type:
> Type of account (Asset, Liability, ....)
> 
> Heading -> this is a header only
> Account -> regular account
> 
> 
> Is this a summary account to record [ AR | AP | IC ] ->
> check either AR, AP, IC if it is a collection account for receivables,
> payables or inventory
> 
> 
> In the Link account to: section the boxes indicate
> 
> Receivables:
> Income -> use this account to record income
> Tax 1 -> tax you collect
> Tax 2 -> ditto for second level tax
> Deposit -> where you put the money you receive from your customers
> 
> Payables:
> Expense/Asset -> record expenses and assets you purchase
> Tax 1 -> tax you pay when you purchase goods or services
> Tax 2 -> ditto
> Payment -> account you use to pay for purchases
> 
> Parts Inventory:
> Sales -> record sales for items sold
> COGS -> record expense for sold items
> 
> Service Items:
> Income -> record sales for services sold
> Expense -> record expense when you purchase a service
> 
> 
> The "Link" setup is another way of linking accounts by entering the
> account numbers. It is quicker to link the accounts but you have to
> know
> the account numbers beforehand.
> 
> 
> 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, 2 Feb 2001, Thomas Sawyer wrote:
> 
> > TO WHOMEVER KNOWS :)
> > 
> > I do not fully understand the accounting links. Currently I am putting
> > together a Chart of Accounts. Do the links simply indicate in more
> detail
> > what an account is, or do they actually effect the activities of
> the
> > system? And the seperate Link Setup Screen, what is it all about?
> > 
> > Aside, but related, is anyone working on documentation?
> > 
> > -- 
> > Thomas Sawyer
> > ps...@on... - email
> > (303) 285-3487 x1594 - voicemail/fax
> > 
> > 
> > 
> > __________________________________________________
> > FREE voicemail, email, and fax...all in one place.
> > Sign Up Now! http://www.onebox.com
> > 
> > 
> > 
> 
> 
> 

__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

Re: [SQL-Ledger-users] permision?g

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

Keld Jørn Simonsen wrote:
> 
> On Sat, Feb 03, 2001 at 10:30:50AM -0700, Dieter Simader wrote:
> > The messages are all archived at sourceforge.
> 
> Where? Is there an URL?

http://www.geocrawler.com/lists/3/SourceForge/7966/0/

Not difficult at all to find, btw..

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

Re: [SQL-Ledger-users] Accounting Links

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

The links tie everything together. They also indicate which accounts are
to be included in the drop down lists.


--- Edit Account ---
Account type:
Type of account (Asset, Liability, ....)

Heading -> this is a header only
Account -> regular account


Is this a summary account to record [ AR | AP | IC ] ->
check either AR, AP, IC if it is a collection account for receivables,
payables or inventory


In the Link account to: section the boxes indicate

Receivables:
Income -> use this account to record income
Tax 1 -> tax you collect
Tax 2 -> ditto for second level tax
Deposit -> where you put the money you receive from your customers

Payables:
Expense/Asset -> record expenses and assets you purchase
Tax 1 -> tax you pay when you purchase goods or services
Tax 2 -> ditto
Payment -> account you use to pay for purchases

Parts Inventory:
Sales -> record sales for items sold
COGS -> record expense for sold items

Service Items:
Income -> record sales for services sold
Expense -> record expense when you purchase a service


The "Link" setup is another way of linking accounts by entering the
account numbers. It is quicker to link the accounts but you have to know
the account numbers beforehand.


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, 2 Feb 2001, Thomas Sawyer wrote:

> TO WHOMEVER KNOWS :)
> 
> I do not fully understand the accounting links. Currently I am putting
> together a Chart of Accounts. Do the links simply indicate in more detail
> what an account is, or do they actually effect the activities of the
> system? And the seperate Link Setup Screen, what is it all about?
> 
> Aside, but related, is anyone working on documentation?
> 
> -- 
> Thomas Sawyer
> ps...@on... - email
> (303) 285-3487 x1594 - voicemail/fax
> 
> 
> 
> __________________________________________________
> FREE voicemail, email, and fax...all in one place.
> Sign Up Now! http://www.onebox.com
> 
> 
> 

Re: [SQL-Ledger-users] permision?g

[<ke...@dk...>]

On Sat, Feb 03, 2001 at 10:30:50AM -0700, Dieter Simader wrote:
> The messages are all archived at sourceforge.

Where? Is there an URL?

Yes, I think it would be a good idea to write some better documentation,
including updating the faq. I am not into it at this point.

Keld
> 
> 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, 3 Feb 2001, Keld Jørn Simonsen wrote:
> 
> > On Fri, Feb 02, 2001 at 10:28:32PM -0800, Thomas Sawyer wrote:
> > > Been through this.
> > > 
> > > Someone should start compiling these emials for documentation. Is anyone
> > > out there saving them all?
> > 
> > Are they not all archived at sourceforge?
> > 
> > Keld
> > 
> > 
> 
> 

[SQL-Ledger-users] Thanks

[Richard E. II <win...@ya...>]

Thanks I will keep looking around for the
.htaccess file or will write it.

rick

__________________________________________________
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/

Re: [SQL-Ledger-users] permision?

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

he messages are all archived at sourceforge.


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

On Sat, 3 Feb 2001, Keld J=F8rn Simonsen wrote:

> On Fri, Feb 02, 2001 at 10:28:32PM -0800, Thomas Sawyer wrote:
> > Been through this.
> >=20
> > Someone should start compiling these emials for documentation. Is any=
one
> > out there saving them all?
>=20
> Are they not all archived at sourceforge?
>=20
> Keld
>=20
>=20

Re: [SQL-Ledger-users] permision?

[<ke...@dk...>]

On Fri, Feb 02, 2001 at 10:28:32PM -0800, Thomas Sawyer wrote:
> Been through this.
> 
> Someone should start compiling these emials for documentation. Is anyone
> out there saving them all?

Are they not all archived at sourceforge?

Keld

Re: [SQL-Ledger-users] permision?

[Thomas S. <ps...@on...>]

Been through this.

Basically you have to get your permissions right, and there are four
kinds to worry about! Personally I wish some one could think of a beeter
way! Anyhoo... (1) You have to get file permissions right on the install
directory. One way to do this is to give complete access on the install
directory from top to bottom to everyone until you get it working and
then come back and make the directory structure more secure. I did this
and what I ended up with in the end is everything being owned by root
and most of the files and directories having a group the same as my web
server's username with full group permissions set. Probably not the most
secure, but not the worst either. (2) Once that's taken care of you need
to make sure your postgres postmaster user account is set up. When first
used the account has no password and needs one made as far as I can tell
(Warning: do not delete this user account!). You'll need this account
to manipulate the postgresql databases or at least to create another
user who can. That user's name and password will then need to be put
into sql-ledger account's file when you finally get to the setup.cgi
page so that sql-ledger can access the postegres database. Make sense?
(3) Then there is the .htaccess and .htpasswd files which apache uses
for security. This security is only used to protect the setup.cgi script.
These files are hidden so you need to do a 'ls -a' to see them. Anyway
you can just delete them if you trust your users or edit them to have
the correct entries. If I remember correctly there's a setting somewhere
to designate where to find the .htpasswd file for the .htaccess file.(unclear?)
Finally, (4) Within the setup.cgi page you'll also define a username
and password for getting into sql-ledger itself (other then this setup.cgi
script).

Does this help?

Someone should start compiling these emials for documentation. Is anyone
out there saving them all?

-- 
Thomas Sawyer
ps...@on... - email
(303) 285-3487 x1594 - voicemail/fax



---- Richard Eicher II <win...@ya...> wrote:
> I get a error when trying to access setup.cgi.
> What do I do to fix this. Apache is running as
> apache apache. I do not find a .htaccess file. I
> am using apache 1.3.12-25 and postgreSQL 7.0.3-2
> on Redhat 7.0.
> 
> I am sure this is something easy.
> 
> Thank you for your time,
> rick
> 
> __________________________________________________
> Get personalized email addresses from Yahoo! Mail - only $35 
> a year!  http://personal.mail.yahoo.com/
> 
> 

__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

[SQL-Ledger-users] tracking Payments, Bills in Sql-Ledger

[Mark W. <ma...@ma...>]

Hi All,

I have been working through the issues of SQL-Ledger, to see if it is 
possible to run my business off it.

At this moment it does not look like that I will be able to use the 
Sql-ledger for my business as the tracking of payments from customers and
bill paying does not seem to be there.  The tracking that seems to be 
missing, is the tracking of cheque numbers, payment type (cash or cheque 
etc), and the dates of part payments.

Things that I really liked about the software, is the way the chart of 
accounts works, and the links idea is great.  Networking of the package 
is excellent, with in just over a slow Internet connection, sql-ledger 
is quite useful.

--------------------------------
Some suggestions for the future.
--------------------------------

Have the dates field fill in with a suggested date of todays date..   
Important if you about to make an invoice to hand to someone..  of 
course one can change the before finishing the invoice.

Just wondering if a invoice is printed should it be posted at the same 
time? as a invoice can printed from the browser, but if one hits one of 
the menu items from the frame the invoice would have disappeared forever 
from the system, even through the invoice was printed.

The recording of part payments, cheque numbers, payment type.

The show of what a customer owes when listing the customers

Purchase orders,  it would be great to trace your inventory right from 
the time of ordering items.

---------------------------------------------------------------
Some problems that I can see as the sql-ledger fills up with 
Transactions
---------------------------------------------------------------

There could be a problem with Netscape with large drop down lists to 
select a customer to bill etc..  that if a business has quite a few 
hundred customers.

The recording of payment details on the original receipts..  it's in 
fact changing the invoice after it has been posted.  Not sure but it 
could be better if the payment s should up on a separate Statement, or a 
printable receipt

Other things that I have noticed. 
---------------------------------

Sql-ledger works great with KDE web browser Konqueror

Looks like that SQL-Ledger one day will be a great package.

Cheers
Mark Williamson

[SQL-Ledger-users] permision?

[Richard E. II <win...@ya...>]

I get a error when trying to access setup.cgi.
What do I do to fix this. Apache is running as
apache apache. I do not find a .htaccess file. I
am using apache 1.3.12-25 and postgreSQL 7.0.3-2
on Redhat 7.0.

I am sure this is something easy.

Thank you for your time,
rick

__________________________________________________
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/

[SQL-Ledger-users] Accounting Links

[Thomas S. <ps...@on...>]

TO WHOMEVER KNOWS :)

I do not fully understand the accounting links. Currently I am putting
together a Chart of Accounts. Do the links simply indicate in more detail
what an account is, or do they actually effect the activities of the
system? And the seperate Link Setup Screen, what is it all about?

Aside, but related, is anyone working on documentation?

-- 
Thomas Sawyer
ps...@on... - email
(303) 285-3487 x1594 - voicemail/fax



__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com

RE: [SQL-Ledger-users] Problems with logging in to sql-ledger

[David R. <dr...@ri...>]

SOLVED IT! (yes, this is exciting, to me, anyway).

The problem has to do with the auto/DBD/Pg permissions. I missed that
directory. It's all working now. I knew I was overlooking something. I
noticed this folder after doing another reinstall of DBD::Pg. The default
permissions don't allow nobody.whatever to access the correct modules, yet
the DBI was ok, hence, the weird error.

-----Original Message-----
From: David Rippel [mailto:dr...@ri...]
Sent: Wednesday, January 31, 2001 9:27 AM
To: 'sql...@li...'
Subject: RE: [SQL-Ledger-users] Problems with logging in to sql-ledger


I moved the modules from site-perl to just the i386-linux and set the
permissions to a=r for all modules, a=rx for all directories related to the
DBD/DBI modules, and still, to no avail, I get the same error. I even tried
adding a -I line to specifically direct the login.cgi to the proper
directories and it still fails. This is really driving me INSANE! I have no
idea what the problem is at this point, I'm sure it's something really
stupid that I am missing. I'm using Slackware 7.1, maybe there's some
specific issues there? I'm almost tempted to reinstall Perl. I'd try this
with ActiveState ActivePerl, but I cannot find any PPM support for DBD::Pg.
I've been stuck on this for 3 days now! 

Is there any way to increase debugging output from what's shown below?

To quote the original error message from Apache's error_log:

> > install_driver(Pg) failed: Can't locate loadable object for module
DBD::Pg
> > in @INC (@INC contains: utils /usr/lib/perl5/i386-linux /usr/lib/perl5
> > /usr/lib/perl5/site_perl/i386-linux /usr/lib/perl5/site_perl .) at (eval
> 1)
> > line 3
> > Compilation failed in require at (eval 1) line 3.
> > Perhaps a module that DBD::Pg requires hasn't been fully installed
> >  at /usr/local/apache/htdocs/sql-ledger/login.cgi line 66
> > [Mon Jan 29 09:19:20 2001] [error] [client 192.168.3.179] Premature end
of
> > script headers: /usr/local/apache/htdocs/sql-ledger/login.cgi


-----Original Message-----
From: ufo...@ea... [mailto:ufo...@ea...]
Sent: Tuesday, January 30, 2001 8:32 PM
To: 'sql...@li...'
Subject: RE: [SQL-Ledger-users] Problems with logging in to sql-ledger


If you poke around in your perl dir, you'll see a a "1386-linux" and a
"site-perl/i386-linux".  Be sure that you have the modules in the first
one.  What I did after I found the problem was jsut to copy the modules
to that dir.  I think this also is affecting Ian.  So Ian, please check
this also.

			Wes