sql-ledger-users — SQL-Ledger users

Demo Data

[Pierre-Alexandre L. <sql...@th...>]

Hi all, 

I came across sql-ledger while reading the slashdot post regarding
accounting software. 

I must say I am more than impressed, everything is clear, installs in a
seconds. 

I was wondering if someone had a postgres dump of some demo data so that
I can play with sql-ledger with some "real-world" data ?

Thanks again,

Pierre

ps: I am currently investigating on making a chart of accounts according
to belgian accounting standards.

Split Booking

[Ralph S. <rs...@gm...>]

Hi 

The only reason why I am not using sql-ledger is the lack of split
booking (I hope this is the correct expression), i.e. the possibility of
recording different positions of one invoice in different accounts. 

Example: 

Our company buys 4 harddrives. 3 are for resale, one is to be used by
ourselves. Consequently the 3 disks have to be recorded as
merchandise/trading goods, the other one as computing equipment (or the
like) and should not show up in inventory. 

Another Example:

Our company bills a customer. There are two positions: we sold her a HDD
and charged her for some services (eg. support). Again both items have
to be recorded in different accounts. 

I cannot see how this can be done with sql-ledger at the moment. If this
feature could be implemented in the future, this would make sql-ledger
even better :)

Any comments?

regards,
ralph

AR-Customer Invoice and Modules

[Donna Z. <don...@wo...>]

12/18/01

AR-Customer Invoice:
    Is there any way to enter the Inventory Item Number and have the
Description and Price display automatically?

Modules:
    We just want to use the AR-Customer Invoice.  Can we set this up so that
nothing else displays; ie, the General Ledger options, etc. - even if it is
running in the background?

Best wishes for a healthy and peaceful holiday season.

Donna

"FATAL 1: Socket command type N unknown" when creating database

[<Nic...@po...>]

I have a fresh install with the following setup:

FreeBSD 4.4
postgresql-7.1.3
p5-DBD-Pg-1.01
p5-DBI-1.20
perl 5.005_03

sql-ledger-1.6.13

When I try to create a new SQL Ledger database from admin.pl, I get the following:

  Error!

  FATAL 1: Socket command type N unknown CREATE TABLE defaults ( inventory_accno_id int, income_accno_id int, expense_accno_id int, invnumber text, ponumber text, yearend varchar(5), nativecurr varchar(3), weightunit varchar(5), businessnumber text, version varchar(8) );

This is a PostgreSQL error.  Turning the debug level on postgres up to
-d 4 doesn't help much: I see the CREATE TABLE chart go through
successfully, then the next lines are:

DEBUG:  CommitTransactionCommand
FATAL 1:  Socket command type N unknown
DEBUG:  proc_exit(0)

It looks as if DBD-Pg isn't talking to PostgreSQL very well.
Suggestions?

Nick B

Permissions on 'users templates users/members'?

[Roger S. <rs...@ma...>]

Hi, I'm having trouble adding new users to Sql-Ledger. I have successfully set mine up with full priviledges. But now I try to add a user from a Win 98 machine(BTW I have Sql-Ledger installed in a RH 7.1) and the new user is owned by apache.apache... I just don't know what I may be doing wrong. With my user I can do pretty much everything, as far as PostGresSQL working and perl working. Any tips and help is greatly appreciated.

Rogelio J. Samour

Re: Customer Invoice/Post invoice?

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

On Mon, 2001-12-17 at 17:46, Ilkka ... wrote:
> Hi,
> 
> >Very well indeed!!
> 
> Good to hear that :)
> 
> > > Error!
> > > You have an error in your SQL syntax near '' at line 1 SELECT onhand 
> >FROM
> > > parts WHERE id =
> >
> >This is not the complete error message. The best thing to do is cut and
> >paste the whole message so we can be of help.
> 
> Well, it is, the id was really empty, and that was the erroneous part. I 
> corrected it, with my own way - I'm not sure how it was meant to be.
> 
> And BTW, I'm still on my way porting Sql-ledger to Windows & MySQL, it's 
> almost ready now. I don't know if you remember me talking about this earlier 
> but I needed to get it working on Windows & MySQL. Maybe that's part of the 
> reason to my problem :-)
> 
> There are some other functionality too that I have added - like Javascript 
> things and something else. When it's ready I hope that it can be backported 
> to original version (hopefully not by me :), but anyway if there are people 
> interested, I can give them a copy (of course, with disclaimers - for 
> example the installation procedure is not very smooth).

Sounds interesting, please keep us posted!


John Stoddart
Caracas - Venezuela

SQL-Ledger and accounting on /.

[<gha...@fr...>]

There is an ongoing discussion on slashdot about open source
accounting systems, SQL-Ledger seems to be well represented.
http://slashdot.org/askslashdot/01/12/17/1750227.shtml
is the URL (I hope).

Gord

Direct Customer Link to Invoice - it works

[alta <al...@al...>]

Dieter ...

I added a direct link from the customer form to the invoice form in 
order to solve some of the issues we discussed.  In order to make 
this work, I had to modify code in several places. 

This enables the user to find and verify (or add) a customer in the 
customer form, then quickly jump to the invoice form with the 
customer already displayed as default in the invoice form.  It 
eliminates the need for a huge drop-down list (4000 customers in my 
case).  Also, Konqueor does not hang the system for 30 seconds 
anymore.

For me and the large customer-base, this is an improvement, but I can 
understand that others may feel differently.

The code modifications follow:
(the wordwrap may be confusing -- sorry)

------------ bin/mozilla/ct.pl----sub form_footer--------------

 if ($form->{id}) {
  
    print qq|<input class=submit type=submit name=action 
value="|.$locale->text('Delete ' . ucfirst $form->{db}).qq|">|;
    
    # reedw-20011217 Add direct link from Customer to Invoice Form.
    print qq|<a 
href=is.pl?path=$form->{path}&action=add&login=$form->{login}&linked_customer=$form->{id} 
target=main_window>|.$locale->text('Customer Invoice').qq|</a>|;

  }

______ end snippet ______

------------ bin/mozilla/ispl----sub create_links--------------

  # create links
  $form->create_links("AR", \%myconfig, "customer");
  
  # build the popup menus
  # reedw-20011217 Handle customer_id if linked in from Customer Form:
  if ($form->{linked_customer}) { $form->{customer_id} = 
$form->{linked_customer} }
  foreach $ref (@{ $form->{all_customer} }) {
    if ($ref->{id} == $form->{customer_id}) {
      $form->{customer} = "$ref->{name}--$ref->{id}";
      IS->get_customer(\%myconfig, \%$form);
    }
  # reedw-20011217 Drop-down removed, so following line not needed: 
  #  $form->{selectcustomer} .= "<option>$ref->{name}--$ref->{id}\n";
  }

______ end snippet ______

------------ bin/mozilla/ispl----sub form_header--------------
<tr>
  <?-- reedw-20011217 Next line modified to replace drop-down list 
with simple input. -->
  <td colspan=6><b>|.$locale->text('Customer').qq|</b> <input 
name=customer value=$form->{customer}> &nbsp;&nbsp; 
  <b>|.$locale->text('Credit Limit').qq|</b> $form->{creditlimit}
  </td>
</tr>

<?-- reedw-20011217 Removed: input type=hidden name=selectcustomer 
value=... -->

<tr>
  <td colspan=6>
  <b>|.$locale->text('E-mail').qq|</b>
  <font size=-1> <input name=email size=25 
value=$form->{email}></font>
  <b>|.$locale->text('Freight').qq|</b> 
  <font size=-1> <input name=shippingpoint 
value="$form->{shippingpoint}"></font>
  </td>
</tr>

______ end snippet ______

... Reed

PS - Your code is clever and tight.  I am learning some useful 
tricks, though some of it I do not understand yet.  At my age, the 
brain doesn't learn so fast. -R

-- 
Reed White  -  ALTA RESEARCH  -  www.alta-research.com
Phone: 877-360-2582  -  Email: al...@al...

Re: User manual

[Thomas G. <to...@ad...>]

On Mon, 17 Dec 2001, Andrew Sharp wrote:

> $100 for support and a manual.  I think this redefines the phrase
> "...drop in the bucket."  I can tell you that if sold as a
> professional software package, and it is currently quite a bit
> better than several I've seen, sql-ledger would go, quite easily,
> for 100 times that.  If you are a company with the actual need for

I've known Dieter for quite some time as we were both involved in an
earlier project and he is one guy who *produces*.  Our first
project (we were not in the leadership) produced only vapourware.
Even after Dieter gave them the code for what became SQL-Ledger!
So Dieter did himself what an entire team never accomplished.
Amazing...but true.

He also regularly contributes (advice and code) to my project - so I know
firsthand, he is a top shelf programmer.  What you get for your money
is lean and mean, well written perl code.  I regularly borrow Dieter's
ideas...there is no better compliment.  SQL Ledger proves that the
Open Source model works.

--------------------------------------------------------------------
              Saint Vincent Catholic Medical Centers               =20
--------------------------------------------------------------------
Thomas Good                          tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst                              Phone:  718-818-5528=20
Behavioral Health Services                      Fax:    718-818-5056 =20
Residential Services                            Mobile: 917-282-7359 =20
--------------------------------------------------------------------
/*         Rekordmeister ist nur der FC Bayern M=FCnchen!           */
--------------------------------------------------------------------

VB/Access System

[alta <al...@al...>]

Andrew ...

> Just out of curiosity, the VB/Access OP system, do you still use it
> (and like it)?  Or do you think back on that project with fear and
> trepidation?  And how would you compare it to something like
> PgMarket or "The N.U.E. Order?

You asked about my VB/Access system.  Mine is homebrew, highly 
fine-tuned for selling books, and very fast and friendly for me.  80% 
of my code is about programming around Microsoft bugs to make it work 
reliably.  Every time I update the MS operating system, I sweat it 
out. 

My VB/Access order processing system is still in use, and I am 
currently attempting to use sql-ledger in parallel.  I plan to fully 
transition at the end of the year.

Reasons for change: I dislike VB and like perl. I do not trust MS 
products or MS evolution, etc.  sql-ledger looks like it will work 
out fine for me.  Currently, I am in the process ot learning, 
testing, and tweeking it.

I will lose a slick and fast user interface, well-formated printout 
(available from MS products), and ability to print shipping labels.  
I will gain with sql-ledger a real accounting system based on perl 
with the ability to grow, and a good group of people to work with.

As I learn and tweek, I hope to be able to give back to the community 
some useful software enhancements for the system.

Regards ... Reed

-- 
Reed White  -  ALTA RESEARCH  -  www.alta-research.com
Phone: 877-360-2582  -  Email: al...@al...

Re: User manual

[Andrew S. <an...@ne...>]

$100 for support and a manual.  I think this redefines the phrase
"...drop in the bucket."  I can tell you that if sold as a
professional software package, and it is currently quite a bit
better than several I've seen, sql-ledger would go, quite easily,
for 100 times that.  If you are a company with the actual need for
sql-ledger, and need the support, it just might be the best $100 you
ever spent.  Just one small business man's opinion, who has been
there, done that, and laughs demonically every time he overhears
people with QuirkBerks(tm) problems.

Just out of curiosity, the VB/Access OP system, do you still use it
(and like it)?  Or do you think back on that project with fear and
trepidation?  And how would you compare it to something like
PgMarket or "The N.U.E. Order?

Hmm, good coffee this morning....

a

alta wrote:
> 
> Phil ...
> 
> You get a manual if you sign up for support ($100).  In my opinion,
> the support is very responsive, and the coder deserves some
> compensation for his work.  However, the manual does not get into
> accounting principals.  Like you, I am challenged in this area,
> though I did write an order processing system (without full ledger)
> in VB Access.
> 
> Welcome to the club.
> 
> ... Reed
> 
> 
> On Monday 17 December 2001 02:00, you wrote:
> > Reply-To: sql...@li... there
> >
> > I've searched the documentation for some sort of user manual. Is
> > there one? If not, are there any plans for one. I am a techo,
> > rather than a user, so need all the help I can get to use
> > Accounting systems ;-)  As an example, whats PST (tax)?
> >
> > Cheers
> > Phil Eldridge
> > Developer
> 
> --
> Reed White  -  ALTA RESEARCH  -  www.alta-research.com
> Phone: 877-360-2582  -  Email: al...@al...

Re: Customer Invoice/Post invoice?

[Ilkka ... <gon...@ho...>]

Hi,

>Very well indeed!!

Good to hear that :)

> > Error!
> > You have an error in your SQL syntax near '' at line 1 SELECT onhand 
>FROM
> > parts WHERE id =
>
>This is not the complete error message. The best thing to do is cut and
>paste the whole message so we can be of help.

Well, it is, the id was really empty, and that was the erroneous part. I 
corrected it, with my own way - I'm not sure how it was meant to be.

And BTW, I'm still on my way porting Sql-ledger to Windows & MySQL, it's 
almost ready now. I don't know if you remember me talking about this earlier 
but I needed to get it working on Windows & MySQL. Maybe that's part of the 
reason to my problem :-)

There are some other functionality too that I have added - like Javascript 
things and something else. When it's ready I hope that it can be backported 
to original version (hopefully not by me :), but anyway if there are people 
interested, I can give them a copy (of course, with disclaimers - for 
example the installation procedure is not very smooth).

Ilkka


_________________________________________________________________
Join the world’s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

Re: Customer Invoice/Post invoice?

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

Hello Ilkka,

On Sat, 2001-12-15 at 18:52, Ilkka ... wrote:
> Hi,
> 
> Does the Customer Invoice / Post Invoice work?

Very well indeed!!

> When I make a new Customer Invoice and press "Post Invoice" button, it gives 
> me this error:
> 
> Error!
> You have an error in your SQL syntax near '' at line 1 SELECT onhand FROM 
> parts WHERE id =

This is not the complete error message. The best thing to do is cut and
paste the whole message so we can be of help.


Good luck!



John Stoddart
Caracas - Venezuela

Re: User manual

[alta <al...@al...>]

Phil ...

You get a manual if you sign up for support ($100).  In my opinion, 
the support is very responsive, and the coder deserves some 
compensation for his work.  However, the manual does not get into 
accounting principals.  Like you, I am challenged in this area, 
though I did write an order processing system (without full ledger) 
in VB Access.

Welcome to the club.

... Reed
 


On Monday 17 December 2001 02:00, you wrote:
> Reply-To: sql...@li... there
>
> I've searched the documentation for some sort of user manual. Is
> there one? If not, are there any plans for one. I am a techo,
> rather than a user, so need all the help I can get to use
> Accounting systems ;-)  As an example, whats PST (tax)?
>
> Cheers
> Phil Eldridge
> Developer

-- 
Reed White  -  ALTA RESEARCH  -  www.alta-research.com
Phone: 877-360-2582  -  Email: al...@al...

Warning: Konqueror Performance Issue

[alta <al...@al...>]

I noticed when using the Konqueror browser that with 4000 customer 
records, my CPU becomes saturated for 30+ seconds when updating the 
form.  This is presumably due to the extremely large drop-down list 
of customers.

However, the mozilla browser handles it OK.

PS - My mozilla browser with HP LaserJet 4MV clips the 
right-justified dollar values so that they are unreadable.  A browser 
or print driver bug, I guess.  Does anyone have a fix, other than 
modifying the invoice form?

... Reed

-- 
Reed White  -  ALTA RESEARCH  -  www.alta-research.com
Phone: 877-360-2582  -  Email: al...@al...

User manual

[Phil E. <pel...@vo...>]

Hi there

I've searched the documentation for some sort of user manual. Is there one? 
If not, are there any plans for one. I am a techo, rather than a user, so 
need all the help I can get to use Accounting systems ;-)  As an example, 
whats PST (tax)?

Cheers
Phil Eldridge
Developer

Shipping Costs on Invoice

[alta <al...@al...>]

Here is how I am adding shipping costs to the invoice.  I hope the 
linkages are right!

To create a shipping account for invoice:

1. Login to sql-ledger via a browser.

2. -> Setup

3. Accounts: Add
   Account number: 4310
   Description: Shipping
   Account Type:  @ Expense, @ Account   --  CORRECT?
   Receivables: x Income   -- CORRECT?
   Service Income:  x Income

4. Save Account

5. -> Accounting

6. -> Add Service

7. Number: Shipping
   Description: Shipping
   Unit of measure: (blank)
   List Price: (blank)
   Sell Price: (blank)
   Income: 4310--Shipping
   Expense 5100--Freight
   (In Oregon USA, GST and PST are not checked.)

8. Save Service

9. In customer invoice, after entering parts for sale, enter 
"shipping" on the list.  Fill in the price value for shipping...

Is there a better or more correct way to do this?

... Reed

-- 
Reed White  -  ALTA RESEARCH  -  www.alta-research.com
Phone: 877-360-2582  -  Email: al...@al...

Re: Newbee start of sqlLedger

[Steve R. <st...@fi...>]

You wrote:

> From: Thomas Good <to...@ad...>
> To: Gunner Carstens <gu...@pl...>
> Cc: sql...@li...
> Date: Sun, 16 Dec 2001 07:32:02 -0500 (EST)
> Subject: Re: Newbee start of sqlLedger
> 
> 
> On Sun, 16 Dec 2001, Gunner Carstens wrote:
> 
> > Hi,
> > 
> > >
> > > Doublecheck your installation of DBI.pm.
> > >
> > Thanks for the answer to my install problems. Now I tried to install DBI and 
> > thereafter DBD-pg. When I try to run the first command in installing DBD-pg i 
> > get this answer:
> > 
> > "Remember to actually read the README file !
> > please set environment variables POSTGRES_INCLUDE and POSTGRES_LIB !"
> > 
> > But I cannot find in the README file how to set these variables (and find out 
> > what they are?)
> 
> Hi.
> 
> I edit my /etc/profile to append the following:
> 
> POSTGRES_INCLUDE=/usr/local/pgsql/include
> POSTGRES_LIB=/usr/local/pgsql/lib
> export POSTGRES_INCLUDE POSTGRES_LIB
> 
> NOTICE:  you must locate your libraries and edit the above strings.
> $ locate libpq-fe.h    < -- this will locate the include directory
> $ locate libpq.a       < -- this will find the lib directory
> (if you have not removed the src directories they will appear in the
> output - ignore this...)
> 
> Enjoy SQL-Ledger!
> 
> --------------------------------------------------------------------
>               Saint Vincent Catholic Medical Centers                
> --------------------------------------------------------------------
> Thomas Good                          tomg@ { admin | q8 } .nrnet.org
> Programmer/Analyst                              Phone:  718-818-5528 
> Behavioral Health Services                      Fax:    718-818-5056  
> Residential Services                            Mobile: 917-282-7359  
> --------------------------------------------------------------------
> /*         Rekordmeister ist nur der FC Bayern München!           */
> --------------------------------------------------------------------

Goto the main site for sql-ledger and look for the FAQ. You can actually cut
and paste the commands from the FAQ to the terminal and it should work fine.

The FAQ contains information on howto install the software for common
platforms.

Variables are simply to set information for your terminal.

EG If there is a directory that you work in often, you can set a variable to
the name of your directory.

Like SO:

[stever@linux05 src]$ cd /
[stever@linux05 /]$ export t=/usr/local/src
[stever@linux05 /]$ cd $t
[stever@linux05 src]$ pwd
/usr/local/src


Everytime you need to goto /usr/local/src

just type cd $t and your there.

Thanks,

Steve

Re: Newbee start of sqlLedger

[Thomas G. <to...@ad...>]

On Sun, 16 Dec 2001, Gunner Carstens wrote:

> Hi,
>=20
> >
> > Doublecheck your installation of DBI.pm.
> >
> Thanks for the answer to my install problems. Now I tried to install DBI =
and=20
> thereafter DBD-pg. When I try to run the first command in installing DBD-=
pg i=20
> get this answer:
>=20
> "Remember to actually read the README file !
> please set environment variables POSTGRES_INCLUDE and POSTGRES_LIB !"
>=20
> But I cannot find in the README file how to set these variables (and find=
 out=20
> what they are?)

Hi.

I edit my /etc/profile to append the following:

POSTGRES_INCLUDE=3D/usr/local/pgsql/include
POSTGRES_LIB=3D/usr/local/pgsql/lib
export POSTGRES_INCLUDE POSTGRES_LIB

NOTICE:  you must locate your libraries and edit the above strings.
$ locate libpq-fe.h    < -- this will locate the include directory
$ locate libpq.a       < -- this will find the lib directory
(if you have not removed the src directories they will appear in the
output - ignore this...)

Enjoy SQL-Ledger!

--------------------------------------------------------------------
              Saint Vincent Catholic Medical Centers               =20
--------------------------------------------------------------------
Thomas Good                          tomg@ { admin | q8 } .nrnet.org
Programmer/Analyst                              Phone:  718-818-5528=20
Behavioral Health Services                      Fax:    718-818-5056 =20
Residential Services                            Mobile: 917-282-7359 =20
--------------------------------------------------------------------
/*         Rekordmeister ist nur der FC Bayern M=FCnchen!           */
--------------------------------------------------------------------

Re: Newbee start of sqlLedger

[Gunner C. <gu...@pl...>]

Hi,

>
> Doublecheck your installation of DBI.pm.
>
Thanks for the answer to my install problems. Now I tried to install DBI and 
thereafter DBD-pg. When I try to run the first command in installing DBD-pg i 
get this answer:

"Remember to actually read the README file !
please set environment variables POSTGRES_INCLUDE and POSTGRES_LIB !"

But I cannot find in the README file how to set these variables (and find out 
what they are?)

thanks 
Gunner

Customer Invoice/Post invoice?

[Ilkka ... <gon...@ho...>]

Hi,

Does the Customer Invoice / Post Invoice work?

When I make a new Customer Invoice and press "Post Invoice" button, it gives 
me this error:

Error!
You have an error in your SQL syntax near '' at line 1 SELECT onhand FROM 
parts WHERE id =


I just upgraded to the latest version.

Ilkka



_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.

Re: Newbee start of sqlLedger

[Steve R. <st...@fi...>]

You wrote:

> From: Gunner Carstens <g....@ma...>
> To: sql...@li...
> Date: Sat, 15 Dec 2001 11:08:50 -0500
> Subject: Newbee start of sqlLedger
> 
> 
> 
> 
> Hi,
> I tried to install a sqlLedger on my mandrake 8.0 box in a userdirectory with 
> no root access. 
> I used the personal "try-out" way described in the README file.  I did the 
> first thing which is described below:
> 
> >"To start the web server change directory to dnhttpd/exec
> >
> >  ./dnhttpd
> >
> >Load your web browser.
> >
> >For administrative tasks connect to
> >  http://localhost:8000/admin.pl ".
> 
> When I in the browser typed:"http://localhost:8000/admin.pl" I got the 
> following error:
> >Processing request from 127.0.0.1:1208
> >Serving file at 
> >/home/Snedkeren/orgboard/div3/sql-ledger/dnhttpd/exec/../../admi
> >n.pl
> >Executing CGI
> >Can't locate DBI.pm in @INC (@INC contains: /usr/lib/perl5/5.6.0/i386-linux 
> >/usr
> >/lib/perl5/5.6.0 /usr/lib/perl5/site_perl/5.6.0/i386-linux 
> >/usr/lib/perl5/site_p
> >erl/5.6.0 /usr/lib/perl5/site_perl .) at bin/mozilla/admin.pl line 38.
> >BEGIN failed--compilation aborted at bin/mozilla/admin.pl line 38.
> >Compilation failed in require at 
> >/home/Snedkeren/orgboard/div3/sql-ledger/dnhttp
> >d/exec/../../admin.pl line 104.
> 
> Can anyone tell me what to do now?
> /Gunner




Doublecheck your installation of DBI.pm.

Thanks,

Steve

Newbee start of sqlLedger

[Gunner C. <g....@ma...>]

Hi,
I tried to install a sqlLedger on my mandrake 8.0 box in a userdirectory with 
no root access. 
I used the personal "try-out" way described in the README file.  I did the 
first thing which is described below:

>"To start the web server change directory to dnhttpd/exec
>
>  ./dnhttpd
>
>Load your web browser.
>
>For administrative tasks connect to
>  http://localhost:8000/admin.pl ".

When I in the browser typed:"http://localhost:8000/admin.pl" I got the 
following error:
>Processing request from 127.0.0.1:1208
>Serving file at 
>/home/Snedkeren/orgboard/div3/sql-ledger/dnhttpd/exec/../../admi
>n.pl
>Executing CGI
>Can't locate DBI.pm in @INC (@INC contains: /usr/lib/perl5/5.6.0/i386-linux 
>/usr
>/lib/perl5/5.6.0 /usr/lib/perl5/site_perl/5.6.0/i386-linux 
>/usr/lib/perl5/site_p
>erl/5.6.0 /usr/lib/perl5/site_perl .) at bin/mozilla/admin.pl line 38.
>BEGIN failed--compilation aborted at bin/mozilla/admin.pl line 38.
>Compilation failed in require at 
>/home/Snedkeren/orgboard/div3/sql-ledger/dnhttp
>d/exec/../../admin.pl line 104.

Can anyone tell me what to do now?
/Gunner

Shipping costs on Invoice Form?

[alta <al...@al...>]

There is no place for shipping costs on the Invoice Form or Printed 
Invoice.

How do other folks handle this?

Create a part called "Shipping", or what do you do?

Thanks for your ideas.

... Reed

PS - Sometimes I get double-records for "customer".  If I try to 
delete one, they both get deleted.  Anyone know what I might have 
done wrong?

-- 
Reed White  -  ALTA RESEARCH  -  www.alta-research.com
Phone: 877-360-2582  -  Email: al...@al...

Post install problem.

[<sql...@fi...>]

Howdy all!

I have installed sql-ledger on a redhat 6.2 webserver (all stop
except for the ugraded rh secure webserver which works fine).

Everything has seemed to go well, except for the database stuff.
I have not done anything special with the database. I started the
daemon by simply using the script /etc/rc.d/init.d/postgresql.
It seemed to create the database just fine upon initial invocation.

I am able to create a user, but when I goto create a new database, it
takes about 10 seconds, then gives me this error.

ERROR: parser: parse error at or near "select" insert into tax (chart_id,rate) values ((select id from chart where accno = 2310),0.07);

I have checked and the tree is in /var/lib/pgsql/base

drwx------    2 postgres postgres     4096 Dec 10 20:35 test2

The directory does contain files that have size to them and are also owned by
postgres. The database is local to the server.

The version is sql-ledger-1.6.13.tar.gz. It also failed on the last version.

Any ideas? I know nothing of postgresql but am familiar with perl and apache.

Thanks,

Steve