sql-ledger-users — SQL-Ledger users

Re: [SL] Can't open perl script / File name too long -> Premature end of script headers

[Antony G. <an...@wa...>]

I don't want to bombard the list, but really, has nobody seen this?  My
setup is pretty vanilla.

Antony Gelberg wrote:
> Hi,
> 
> I have seen the following intermittently over the past few years with
> SL, and finally, it's annoying me enough to ask the list.
> 
> The web browser asks me if I want to save or open the .pl file as if I
> had initiated a download.  The errors below appear in the apache error log.
> 
> I'd appreciate any assistance to debug this - can't believe I'm the only
> one.  SL 2.6.3, Apache 2.2.3, Perl 5.8.8.
> 
> [Sun Mar 04 14:32:04 2007] [error] [client 82.68.107.174] Can't open
> perl script
> "ct.pl%3faction%3dlist_names%26direction%3dDESC%26oldsort%3dname%26db%3dvendor%26path%3dbin%2fmozilla%26login%3droma%26sessionid%3d1173017171%26status%3dall%26l_subtotal%3d%26l_name%3dY%26l_contact%3dY%26l_phone%3dY%26l_email%3dY%26l_amount%3dY%26l_tax%3dY%26l_total%3dY%26name%3dJean-Philippe%2520Blangy%26sort%3dname":
> File name too long, referer:
> https://xxx.wayforth.co.uk/sql-ledger/ct.pl?action=edit&id=11379&db=vendor&path=bin/mozilla&login=roma&sessionid=1173017171&status=all&callback=ct.pl%253faction%253dlist_names%2526direction%253dDESC%2526oldsort%253dname%2526db%253dvendor%2526path%253dbin%252fmozilla%2526login%253droma%2526sessionid%253d1173017171%2526status%253dall%2526l_subtotal%253d%2526l_name%253dY%2526l_contact%253dY%2526l_phone%253dY%2526l_email%253dY%2526l_amount%253dY%2526l_tax%253dY%2526l_total%253dY%2526name%253dJean-Philippe%252520Blangy%2526sort%253dname
> [Sun Mar 04 14:32:04 2007] [error] [client 82.68.107.174] Premature end
> of script headers: ct.pl, referer:
> https://xxx.wayforth.co.uk/sql-ledger/ct.pl?action=edit&id=11379&db=vendor&path=bin/mozilla&login=roma&sessionid=1173017171&status=all&callback=ct.pl%253faction%253dlist_names%2526direction%253dDESC%2526oldsort%253dname%2526db%253dvendor%2526path%253dbin%252fmozilla%2526login%253droma%2526sessionid%253d1173017171%2526status%253dall%2526l_subtotal%253d%2526l_name%253dY%2526l_contact%253dY%2526l_phone%253dY%2526l_email%253dY%2526l_amount%253dY%2526l_tax%253dY%2526l_total%253dY%2526name%253dJean-Philippe%252520Blangy%2526sort%253dname
> 

Re: [SL] SL in a service business?

[Paul T. <pt...@wa...>]

Michael Hasse schreef:
> Hi everyone,
>
>     Anybody using SL in a service business where incoming units to be  
> repaired need to be tracked?
>     Take a garage for example, lots of customers, some of which have  
> multiple vehicles.  When the vehicle comes in not only is the work  
> tied to the customer and the usual parts/labor is invoiced but there  
> also need to an association with the vehicle make/model/VIN etc so  
> that the repair history can be reported on.
>     We're not seeing any way to do that last bit in the SL  
> interface.  Short of creating a separate customer account for every  
> single vehicle, (not really feasible if some have fleets of  
> hundreds), is there some other angle on this that we're just missing?
>
>
> Thanks,
>
> Michael
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>
>   
You could consider the PROJECT field for this..A new project for each 
new car one time, available from then on. Could be the license plate or 
make model year licence plate or something like that..

HtH

Re: [SL] Cheque template help requested.

[Jigme D. <jig...@gm...>]

> I think it
> may have to do with boxes?

I think it's due to using a fixed /vspace instead of flexible vglue.
I think what you want to do (and this may take some playing around) is
figure out how far *up* the page you want the bottom of your cheque,
and put a \vfill between the top of the cheque, and the bottom of the
summary, and then at the bottom put the \vspace that you want from the
bottom of your cheque.  Now I'm not sure that this gives the answer
that you are looking for.  It would depend on how you want to lay this
all out.  The way that you have it laid out you have the invoice
information at the top, then the cheque below that, and it appears
that it is just a little bit below  it.  So what you want to do if you
want to maintain the same format is to make sure that {tabularx} is
the same size, and I'm not familiar enough with LaTeX to know if that
is a text box, or if it's just a lexical boundary.  If it is a textbox
then you should be able to define the hsize and vsize of the box.  If
it's simply lexical (has no direct effect on how things are laid out
on the page), then you will have to find a way to put the cheque on
the page where you want (and that's crutial).  I would suggest trying
to place the cheque either on the top of the printed page of
"letterpaper".  That may be easily said, but much more difficult to
produce with the cheque paper that you are using.

Jigme Datse

Re: [SL] Best Linux OS for SL?

[ATM L. <atm...@km...>]

> 
> I've been using FreeBSD since 2.2.8 (and one prototype laptop 
> that would only run 2.2.2) and I would also agree that it's a 
> great choice for running SL.  (Our install is running on 
> 6.1->6.2) I would however add the there is no reason not to 
> use the package's instead of building from ports.  You'll 
> save loads of time, and the packages are already optimized 
> plus you'll make it easier on FreeBSD's bandwidth as there 
> isn't as much to d/l(if something comes up down the road you 
> can always change it later).  And as already noted, use 
> either package or the ports tree, not both.
> 
> If you're really insistent on having a GUI check out 
> www.pcbsd.org - FBSD + KDE
> 

Looks like I cannot install SQL on the VMWare package of this  :(

At least not using:
cd /usr/ports/finance/sql-ledger/ && make install clean

Re: [SL] Cheque template help requested.

[C. D. H. <Du...@Du...>]

Jeff Roberts wrote:
> Hi Everyone
>
> I modified my latex file to print cheques in the new format required 
> starting this spring in Canada. Everything seems to work as long as I am 
> only paying one invoice. If I pay two or three invoices the extra lines 
> printed in the top third of the page push the information down in the 
> cheque body. If I pay one invoice everything lines up, if i pay two then 
> the cheque body is down a line, by the time i try to pay three cheques 
> all at once the cheque information is totally out of place.
>
> I tried to find out how to correct this by reading my copy of "The not 
> so short introduction to Latex" but couldn't figure it out. I think it 
> may have to do with boxes?
>
> Here is my cheque code:
>
> /*\documentclass{scrartcl}
> \usepackage[latin1]{inputenc}
> \usepackage{tabularx}
> \usepackage[letterpaper,top=2cm,bottom=-3cm,left=2.25cm,right=2cm]{geometry}
> \usepackage{graphicx}
>
> \begin{document}
>
> \pagestyle{myheadings}
> \thispagestyle{empty}
>
> \fontfamily{cmss}\fontsize{12pt}{12pt}\selectfont
>
> <%company%>
>
> \vspace{0.5cm}
>
> <%name%> \hfill <%datepaid%> \hfill <%source%>
>
> \vspace{0.5cm}
> \begin{tabularx}{\textwidth}{lXrr@{}}
> \textbf{Invoice \#} & \textbf{Invoice Date}
>   & \textbf{Amount Due} & \textbf{Applied} \\
> <%foreach invnumber%>
> <%invnumber%> & <%invdate%> \dotfill
>   & <%due%> & <%paid%> \\
> <%end invnumber%>
> \end{tabularx}
>
> \vspace{1cm}
>
> \text{Memo: } \
> <%memo%>
>
> \vspace*{3.5cm}
>
> \hfill <%source%>
>
> \vspace*{.75cm}
>
> \hfill <%datepaid%>
>
> \vspace*{1.75cm}
>
> <%text_amount%> \dotfill <%decimal%>/100 \makebox[4cm]{\hfill}
>
> % \hfill <%datepaid%> \makebox[2cm]{\hfill} <%amount%>
>
> \hfill <%amount%>  \makebox[1cm]{\hfill}
>
> % different date format for datepaid
> % <%DD%><%MM%><%YYYY%>
>
> %\vspace{0.25cm}
>
> <%name%>
>
> <%address1%>
> <%address2%>
>
> <%city%>
> <%if state%>
> \hspace{-0.1cm}, <%state%>
> <%end state%>
> <%zipcode%>
>
> <%country%>
>
> \vspace{0.25cm}
>
> <%memo%>
>
> \vfill
>
> \end{document}
> */
> Thanks in advance
>
> Jeff Roberts
>   
Jeff - There's always a million ways to skin a cat, but we found the 
easiest way to handle this specific problem was with the Latex tabularx 
package.  We use 3 part checks, with the actual check in the middle.  
We're limited to 20 invoices / check, but other then that it works like 
a charm.  Drop me a line off list if you'd like to take a look at what 
we did.

Dunc

[SL] Cheque template help requested.

[Jeff R. <je...@jr...>]

Hi Everyone

I modified my latex file to print cheques in the new format required 
starting this spring in Canada. Everything seems to work as long as I am 
only paying one invoice. If I pay two or three invoices the extra lines 
printed in the top third of the page push the information down in the 
cheque body. If I pay one invoice everything lines up, if i pay two then 
the cheque body is down a line, by the time i try to pay three cheques 
all at once the cheque information is totally out of place.

I tried to find out how to correct this by reading my copy of "The not 
so short introduction to Latex" but couldn't figure it out. I think it 
may have to do with boxes?

Here is my cheque code:

/*\documentclass{scrartcl}
\usepackage[latin1]{inputenc}
\usepackage{tabularx}
\usepackage[letterpaper,top=2cm,bottom=-3cm,left=2.25cm,right=2cm]{geometry}
\usepackage{graphicx}

\begin{document}

\pagestyle{myheadings}
\thispagestyle{empty}

\fontfamily{cmss}\fontsize{12pt}{12pt}\selectfont

<%company%>

\vspace{0.5cm}

<%name%> \hfill <%datepaid%> \hfill <%source%>

\vspace{0.5cm}
\begin{tabularx}{\textwidth}{lXrr@{}}
\textbf{Invoice \#} & \textbf{Invoice Date}
  & \textbf{Amount Due} & \textbf{Applied} \\
<%foreach invnumber%>
<%invnumber%> & <%invdate%> \dotfill
  & <%due%> & <%paid%> \\
<%end invnumber%>
\end{tabularx}

\vspace{1cm}

\text{Memo: } \
<%memo%>

\vspace*{3.5cm}

\hfill <%source%>

\vspace*{.75cm}

\hfill <%datepaid%>

\vspace*{1.75cm}

<%text_amount%> \dotfill <%decimal%>/100 \makebox[4cm]{\hfill}

% \hfill <%datepaid%> \makebox[2cm]{\hfill} <%amount%>

\hfill <%amount%>  \makebox[1cm]{\hfill}

% different date format for datepaid
% <%DD%><%MM%><%YYYY%>

%\vspace{0.25cm}

<%name%>

<%address1%>
<%address2%>

<%city%>
<%if state%>
\hspace{-0.1cm}, <%state%>
<%end state%>
<%zipcode%>

<%country%>

\vspace{0.25cm}

<%memo%>

\vfill

\end{document}
*/
Thanks in advance

Jeff Roberts

/*

*/

Re: [SL] Output reports to csv

[Craig I. <cr...@da...>]

P&L = Profit & Loss (i.e. Income Statement)

I'll give this a try later tonight or tomorrow and let you know how it
goes...

Craig

> -----Original Message-----
> From: sql...@li... [mailto:sql-ledger-
> use...@li...] On Behalf Of Dr Eberhard Lisse
> Sent: Tuesday, March 13, 2007 3:50 PM
> To: sql...@li...
> Subject: Re: [SL] Output reports to csv
> 
> Craig,
> 
> It's a pleasure.
> 
> 
> What are P&Ls? I am not sure I understand what you are asking, but maybe
> you have a look this statement:
> 
> --
> -- This statement is copylefted by Dr E W Lisse
> -- and may not be used by the pompous Ozzie
> -- and the idiot Wannabe Kraut.
> --
> --
> SELECT date_part('month',ac.transdate) AS dmonth,
>      to_char(ac.transdate,'MON') AS cmonth,
>      sum(ROUND(ac.amount::NUMERIC,2)) AS amount
> FROM gl, acc_trans ac, chart
> WHERE (ac.trans_id = gl.id)
> AND chart.accno BETWEEN 4000 AND 4999
> AND (ac.chart_id = chart.id)
> AND (ac.source not ilike '%yearend%')
> GROUP BY cmonth, dmonth
> ORDER by dmonth;
> 
> 
> Use the SQL, Luke!
> 
> el
> 
> on 3/13/07 5:27 PM Craig Isdahl said the following:
> > EL,
> >
> > This was very helpful for me, thank you for posting it.  Before I
> > spend a bunch of time on this - can you tell me how much of an
> > undertaking it would be to pull monthly P&Ls into a CSV like your
> > example below?  My goal is to output a report that would show all 12
> > months individually.
> >
> > Thanks!
> > Craig
> >
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Config

[mauricio a. <ma...@ho...>]

if you not remenber the sql-ledger password, you must change  the password 
for this user in postgres direc tly or if you have instaled pgamin3 o can 
you try with pgaccess that are visual admin postgres administration, you can 
change de password for sql-legder user


>From: Sergio Ruiz <ru...@sb...>
>Reply-To: sql...@li...
>To: sql...@li...
>Subject: [SL] Config
>Date: Fri, 9 Mar 2007 09:29:03 -0800 (PST)
>
>Hi folks,
>   This might be a stupid question, but I'm already don't know where to 
>look. I'm trying to install sql-ledger, and I'm having problems.
>
>   I enter in http://myservername/sql-ledger/admin.pl. Then I click on 'Pg  
>Database Administration' to create the dataset. In host I type in the ip 
>address of the computer hosting the software. As user sql-ledger, and 
>connect to template1. I don't know the password for sql-ledger. I have 
>tried leaving it blank, or use the password 'password', but nothing seems 
>to work.
>
>The error message is the following:
>Error!
>could not connect to server: Connection refused
>  Is the server running on host "192.168.1.24" and accepting
>  TCP/IP connections on port 5432?
>
>
>I have the feeling that I'm missing something. I have no idea what. Can 
>anyone help me, please?
>
>Thank you,
>
>Sergio J Ruiz
>
>
>-------------------------------------------------------------------------
>Take Surveys. Earn Cash. Influence the Future of IT
>Join SourceForge.net's Techsay panel and you'll get the chance to share 
>your
>opinions on IT & business topics through brief surveys-and earn cash
>http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>_______________________________________________
>sql-ledger-users mailing list
>sql...@li...
>https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

_________________________________________________________________
Don't just search. Find. Check out the new MSN Search! 
http://search.msn.com/

Re: [SL] Output reports to csv

[Dr E. L. <el...@li...>]

Craig,

It's a pleasure.


What are P&Ls? I am not sure I understand what you are asking, but maybe
you have a look this statement:

--
-- This statement is copylefted by Dr E W Lisse
-- and may not be used by the pompous Ozzie
-- and the idiot Wannabe Kraut.
--
-- 
SELECT date_part('month',ac.transdate) AS dmonth,
     to_char(ac.transdate,'MON') AS cmonth,
     sum(ROUND(ac.amount::NUMERIC,2)) AS amount
FROM gl, acc_trans ac, chart
WHERE (ac.trans_id = gl.id)
AND chart.accno BETWEEN 4000 AND 4999
AND (ac.chart_id = chart.id)
AND (ac.source not ilike '%yearend%')
GROUP BY cmonth, dmonth
ORDER by dmonth;


Use the SQL, Luke!

el

on 3/13/07 5:27 PM Craig Isdahl said the following:
> EL,
>
> This was very helpful for me, thank you for posting it.  Before I
> spend a bunch of time on this - can you tell me how much of an
> undertaking it would be to pull monthly P&Ls into a CSV like your
> example below?  My goal is to output a report that would show all 12
> months individually.
>
> Thanks!
> Craig
>

Re: [SL] SL in a service business?

[Rich S. <rsh...@ap...>]

On Mon, 12 Mar 2007, Michael Hasse wrote:

>    Anybody using SL in a service business where incoming units to be
> repaired need to be tracked?

   Nope.

>    Take a garage for example, lots of customers, some of which have
> multiple vehicles.  When the vehicle comes in not only is the work
> tied to the customer and the usual parts/labor is invoiced but there
> also need to an association with the vehicle make/model/VIN etc so
> that the repair history can be reported on.

   How about assigning each vehicle to a project? Might that work for you?

Rich

-- 
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

Re: [SL] Output reports to csv

[Craig I. <cr...@da...>]

EL,

This was very helpful for me, thank you for posting it.  Before I spend a
bunch of time on this - can you tell me how much of an undertaking it would
be to pull monthly P&Ls into a CSV like your example below?  My goal is to
output a report that would show all 12 months individually.

Thanks!
Craig

> -----Original Message-----
> From: sql...@li... [mailto:sql-ledger-
> use...@li...] On Behalf Of Dr Eberhard Lisse
> Sent: Thursday, March 01, 2007 11:23 PM
> To: sql...@li...
> Subject: Re: [SL] Output reports to csv
> 
> Actually this is wrong.
> 
> psql -AtF, databasename < gl.psql > gl.csv will produce CSV.
> 
> and gl.psql looking like
> 
> SELECT  c.accno, c.description, ac.transdate, g.id,
>     round(ac.amount::numeric,2) as Amount,
>     g.reference,
>     g.description, substr(g.notes,1,55) as Notes,
>     ac.memo
> 
> FROM gl g
> JOIN acc_trans ac ON (g.id = ac.trans_id)
> JOIN chart c ON (ac.chart_id = c.id)
> LEFT JOIN department d ON (d.id = g.department_id)
> WHERE 1 = 1
>     AND ac.transdate >= '2005-06-01'
>     AND ac.transdate <= '2006-06-30'
> 
> UNION ALL
> 
> SELECT c.accno,  c.description, ac.transdate, a.id,
>     round(ac.amount::numeric,2) as Amount,
>     a.invnumber,
>     ct.name, substr(a.notes,1,55) as Notes,
>    ac.memo
> FROM ar a
> JOIN acc_trans ac ON (a.id = ac.trans_id)
> JOIN chart c ON (ac.chart_id = c.id)
> JOIN customer ct ON (a.customer_id = ct.id)
> LEFT JOIN department d ON (d.id = a.department_id)
> WHERE 1 = 1
>    AND ac.transdate >= '2005-06-01'
>    AND ac.transdate <= '2006-06-30'
> 
> UNION ALL
> 
> SELECT c.accno,  c.description, ac.transdate,  a.id,
>     round(ac.amount::numeric,2) as Amount,
>     a.invnumber,
>     ct.name, substr(a.notes,1,55) as Notes,
>    ac.memo
> FROM ap a
> JOIN acc_trans ac ON (a.id = ac.trans_id)
> JOIN chart c ON (ac.chart_id = c.id)
> JOIN vendor ct ON (a.vendor_id = ct.id)
> LEFT JOIN department d ON (d.id = a.department_id)
> WHERE 1 = 1
>    AND ac.transdate >= '2005-06-01'
>    AND ac.transdate <= '2006-06-30'
> 
> ORDER BY 1, 3, 4;
> 
> does it for my auditor :-)-O
> 
> el
> 
> on 3/1/07 10:42 PM C. Duncan Hudson said the following:
> > David Boyle wrote:
> >> On Thu, 2007-03-01 at 09:17 -0800, Wray Cason wrote:
> >>
> >>> My bookkeeper wants to be able to crunch some numbers from my SQL
> Ledger
> >>> database in a spreadsheet.  Is there any established way to output
> reports
> >>> to a csv file or something similar?
> >>>
> >> I imagine there is...but copy/paste works pretty well and is easy.
> >>
> >> David Boyle
> >> NAPCO (Northwest Arkansas Paper Company)
> >>
> >>
> > There isn't, actually, a way to output to any kind of file.  The
> > technical solution is cut and paste, which I think leaves a lot to be
> > desired.  I use Postgres SQL Manager to generate reports.  It would be
> > nice if the functionality was built in, as that's not a tool I give to
> > any of my users.
> >
> > Dunc
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

[SL] SL in a service business?

[Michael H. <mh...@it...>]

Hi everyone,

    Anybody using SL in a service business where incoming units to be  
repaired need to be tracked?
    Take a garage for example, lots of customers, some of which have  
multiple vehicles.  When the vehicle comes in not only is the work  
tied to the customer and the usual parts/labor is invoiced but there  
also need to an association with the vehicle make/model/VIN etc so  
that the repair history can be reported on.
    We're not seeing any way to do that last bit in the SL  
interface.  Short of creating a separate customer account for every  
single vehicle, (not really feasible if some have fleets of  
hundreds), is there some other angle on this that we're just missing?


Thanks,

Michael

Re: [SL] Best Linux OS for SL?

[Adam V. M. <amv...@gm...>]

I've been using FreeBSD since 2.2.8 (and one prototype laptop that would
only run 2.2.2) and I would also agree that it's a great choice for running
SL.  (Our install is running on 6.1->6.2) I would however add the there is
no reason not to use the package's instead of building from ports.  You'll
save loads of time, and the packages are already optimized plus you'll make
it easier on FreeBSD's bandwidth as there isn't as much to d/l(if something
comes up down the road you can always change it later).  And as already
noted, use either package or the ports tree, not both.

If you're really insistent on having a GUI check out www.pcbsd.org - FBSD +
KDE

I've beening using it to install desktop workstations, but the project has
commercial backing and a server option during the install plus the pbi
collection allows for clickable installers for common apps eg apache, open
office, etc.  Of course it comes with it's own standard quirks, but they're
easy to overcome if you're familiar w/ FBSD.

Re: [SL] Mid-size consulting firm; replacement for QuickBooks?

[Rich S. <rsh...@ap...>]

On Mon, 12 Mar 2007, JT wrote:

> I am with a boutique management consulting organization with approximately
> 100 people.

JT,

   Good to know; many boutiques need management consultants.

> We bill for our time + reimbursable expenses. We need a general accounting
> system + timecard, billing and a/p to support our business. Our needs are
> similar to a legal or accounting firm; due to the specialized nature of
> our business, there are no industry specific shrink-wrapped solutions.

   But, there is SL.

> I would like to find a consultant experienced implementing SL in an
> organization similar in size to ours!

   Well, we're nowhere near that size, but SL works for any company of 1+
employees. Set up your services and normal expenses as inventory items,
create projects for each client/project, use the timecard capabilities, and
go to town. SL will generate invoices for you, add them to A/R when posted,
and handle the A/P and G/L functions, too.

   There's no payroll (as far as I know), and many companies contract that to
a dedicated payroll firm or have their accountant handle it.

   Go set up SL and ask your questions here. As far as this capability is
concerned, size does _not_ matter.

Rich

-- 
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

[SL] Looking for SQL scripts to set ROP based on Sales

[Ronald K. <rj...@ya...>]

I've been live on Sql for 14 months now.  Current version 2.6.14.  I've lim=
ped through some cumbersome tasks hoping the system will become more effici=
ent.  I am not a programmer; I've paid a programmer to customize my system.=
 He has contributed my patches back to the community.  He has other project=
s and is not interested in my future customization needs......=0A=0ACan any=
one on this board help with simple management tasks?   =0A=0AI've emailed D=
ieter in the past;  he either does not answer or says he doesn't have time.=
=0A=0AMy current needs are:=0A=0ASet ROP=0AMy current need is to establish =
ROP's for my 130,000 skus in inventory.  40,000 skus on hand.  My thought i=
s a script that will clear ROP.  Run a report on my 14 months of sales hist=
ory for items.  Set ROP equal to an item's monthly sales.  Seasonally adjus=
t ROP based on previous year would be great too.=0A=0AGenerate Weekly Purch=
ase Order=0AI currently have a script that runs Sunday nights that generate=
s an SO based on M-Sun sales.  It takes all sales that run through AR to ge=
nerate this PO.  I would like this program edited to generate an SO based o=
n WIPROP.  WIPROP =3D ROP - SO + PO. =0A=0AYou can email me directly=0A=0AT=
hank you=0A=0A...@ml...=0A=0A=0A =0A_________________________________=
___________________________________________________=0AExpecting? Get great =
news right away with email Auto-Check. =0ATry the Yahoo! Mail Beta.=0Ahttp:=
//advision.webevents.yahoo.com/mailbeta/newmail_tools.html 

Re: [SL] Mid-size consulting firm; replacement for QuickBooks?

[JT <jtr...@ya...>]

I am with a boutique management consulting organization with approximately =
100 people. We bill for our time + reimbursable expenses. We need a general=
 accounting system + timecard, billing and a/p to support our business. Our=
 needs are similar to a legal or accounting firm; due to the specialized na=
ture of our business, there are no industry specific shrink-wrapped solutio=
ns.=0A=0AIn addition to QuickBooks, we have a custom developed time sheet s=
ystem (which we hope to eliminate through the functionality in a new replac=
ement integrated accounting system). We also do job profitability reporting=
 in a separate system. We outsource payroll to ADT.=0A=0AI would like to fi=
nd a consultant experienced implementing SL in an organization similar in s=
ize to ours!=0A=0AThanks,=0A=0AJeremy=0A=0A=0A----- Original Message ----=
=0AFrom: Michael Hasse <mh...@it...>=0ATo: sql...@li...u=
rceforge.net=0ASent: Monday, February 26, 2007 10:54:42 PM=0ASubject: Re: [=
SL] Mid-size consulting firm; replacement for QuickBooks?=0A=0AThe lack of =
a payroll module may be an issue, depending on whether  =0Ayou're using QB'=
s right now or not.=0A    Otherwise it really depends on the nature of the =
business.  E.g.  =0AI wouldn't put a healthcare organization on it due to t=
he specialized  =0Ainsurance tracking and forms required.=0A    This is rea=
lly where the MS lock-in has held sway for so long,  =0Athe vast majority o=
f businesses occupy what are called "vertical  =0Amarkets", i.e. they are i=
n niche industries.  And for the most part  =0Athose vertical markets have =
a small number of applications available  =0Ato serve the day to day busine=
ss process needs which are highly  =0Atailored to that particular demograph=
ic and which usually require  =0AWindows.=0A    This is not always the case=
 of course, the retail sector has a  =0Arich selection of applications for =
all platforms OSS and otherwise.   =0AConstruction companies on the other h=
and have about three options and  =0Athey are all Windows based.=0A    So t=
ell us - what do you do?  :)=0A=0A=0AThanks,=0A=0AMichael=0A=0A=0AOn Feb 26=
, 2007, at 1:02 PM, JT wrote:=0A=0A> ----- Original Message ----=0A> From: =
Rich Shepard <rsh...@ap...>=0A> To: sql...@li...ur=
ceforge.net=0A> Sent: Monday, February 26, 2007 2:23:25 PM=0A> Subject: Re:=
 [SL] Mid-size consulting firm; replacement for  =0A> QuickBooks?=0A>=0A>=
=0A> On Mon, 26 Feb 2007, JT wrote:=0A>=0A>> I have used SL for my own home=
-office based business in the past, ...=0A>=0A>    Ergo, you are familiar w=
ith it and know how extensive it is.=0A>=0A>> We will soon start to look at=
 the Microsoft Dynamics options, but  =0A>> I am=0A>> interested in finding=
 out the availability of professional  =0A>> services to=0A>> support an SL=
 implementation in an organization of our size.=0A>=0A>    I don't understa=
nd. If you want a proprietary solution from  =0A> Microsoft,=0A> then pay t=
hem. If you want to replace QB with SQL-Ledger that's a  =0A> totally=0A> d=
ifferent situation. First, you're aware of the help and resources  =0A> rig=
ht=0A> here, since this is where you posted your message. Second, if you  =
=0A> look on=0A> the SQL-Ledger web site you'll see that there are companie=
s that  =0A> provide=0A> hands-on help and that Dieter is available for pai=
d help, too.=0A>=0A>    What's your question to the list?=0A>=0A> Rich=0A>=
=0A> -- =0A> Richard B. Shepard, Ph.D.               |    The Environmental=
  =0A> Permitting=0A> Applied Ecosystem Services, Inc.        |          Ac=
celerator(TM)=0A> <http://www.appl-ecosys.com>     Voice: 503-667-4517     =
 Fax:  =0A> 503-667-8863=0A>=0A> My question is relative to what type of co=
mpanies have adopted SL  =0A> as their financial system; more specifically,=
 does this group (or  =0A> Dieter) know of $10M - $50M companies using SL? =
I am not a  =0A> Microsoft fan; I would greatly prefer to go with an OSS so=
lution;  =0A> especialy one with the flexibility to grow with our company. =
Does  =0A> anyone know of situations where companies had to migrate off of =
SL  =0A> due to running into limitations (I imagine not). I am looking for =
 =0A> organizations in similar situations to ours.=0A>=0A> Sorry for not be=
ing more clear on my last post.=0A>=0A> Jeremy=0A> ------------------------=
---------------------------------------------- =0A> ---=0A> Take Surveys. E=
arn Cash. Influence the Future of IT=0A> Join SourceForge.net's Techsay pan=
el and you'll get the chance to  =0A> share your=0A> opinions on IT & busin=
ess topics through brief surveys-and earn cash=0A> http://www.techsay.com/d=
efault.php? =0A> page=3Djoin.php&p=3Dsourceforge&CID=3DDEVDEV=0A> _________=
______________________________________=0A> sql-ledger-users mailing list=0A=
> sql...@li...=0A> https://lists.sourceforge.net/=
lists/listinfo/sql-ledger-users=0A=0A=0A-----------------------------------=
--------------------------------------=0ATake Surveys. Earn Cash. Influence=
 the Future of IT=0AJoin SourceForge.net's Techsay panel and you'll get the=
 chance to share your=0Aopinions on IT & business topics through brief surv=
eys-and earn cash=0Ahttp://www.techsay.com/default.php?page=3Djoin.php&p=3D=
sourceforge&CID=3DDEVDEV=0A_______________________________________________=
=0Asql-ledger-users mailing list=0As...@li...=
=0Ahttps://lists.sourceforge.net/lists/listinfo/sql-ledger-users=0A=0A=0A

Re: [SL] Best Linux OS for SL?

[Wallace R. C. <wrc...@gm...>]

On 3/11/07, Tony <to...@in...> wrote:
> My personal feeling is that a server should be just that ' a server '. GUI
> addons only serve to waste resources and add potential security holes. I also
> tend to sperate 'services' and dedicate a box for each one if possible for
> the same reasons.

I agree on both points.

> I've had SL running on BSD 5.x without a problem, however i used the official
> installer instead of what was in the ports tree. There was a bit of manual
> labor to get all the components setup but its pretty straight forward.

As Shakespeare wrote, "Aye, there's the rub."

I've used FreeBSD in the past & found that it requires a bit of
tinkering.  Nothing wrong with that, but I often don't have the time
to tinker, so I've fallen back to using Fedora Core on my server
boxes.  "It just works."
-- 
Best Regards,
Wallace

Re: [SL] Best Linux OS for SL?

[Tony <to...@in...>]

My personal feeling is that a server should be just that ' a server '. GUI 
addons only serve to waste resources and add potential security holes. I also 
tend to sperate 'services' and dedicate a box for each one if possible for 
the same reasons.

I've had SL running on BSD 5.x without a problem, however i used the official 
installer instead of what was in the ports tree. There was a bit of manual 
labor to get all the components setup but its pretty straight forward.

And to answer  you question about first/last/etc:  if you do make install on a 
port, it installs it for you and you dont need to install the package 
afterwards. ( its sort of redundant )

its also best to stick with ports, and not packages if you can. Ports is the 
preferred way for any BSD application, packages are just there for 
convenience.

On Sunday 11 March 2007 09:30 am, ATM Logic wrote:
> Ok...  Well, I am game for Free-BSD, and have played with it a bit..., If I
> have the power, any reason I should still not go with the GUI?  (Will be
> run on a HP Xeon 2Ghz with 512M, not sure what drive/drives I will put in
> yet...
>
> Also, here for the BSD
> ftp://ftp.freebsd.org/pub/FreeBSD/releases/i386/ISO-IMAGES/6.2/
>
> Then this to install SL
> To install the port: cd /usr/ports/finance/sql-ledger/ && make install
> clean To add the package: pkg_add -r sql-ledger
>
> (Do I have to add the package???  First?/After?/Never?)
>
> When its done will I be good to PDF invoices?  Or am I back to trying to
> get everything working again?
>
> Thanks for the Ideas, I will be going FreeBSD unless it gets too cranky,
> then I will give up and go CentOS...
>
> I guess the bigest Question would be ... Could/Should/I leave the GUI
> etc??/ If I did, can you think of any other 'Kewl' uses for it?
>
> ---Andrew
> ATM Logic
>
> > -----Original Message-----
> > From: sql...@li...
> > [mailto:sql...@li...] On
> > Behalf Of Jeff Roberts
> > Sent: Saturday, March 10, 2007 1:45 PM
> > To: sql...@li...
> > Subject: Re: [SL] Best Linux OS for SL?
> >
> > Hi ATM Logic
> >
> > I agree with Vlad, I installed it on a FreeBSD box and the
> > install couldn't have been simpler. There is a port for
> > SQL-Ledger, (it was version 2.6.22 when i installed in Dec)
> > and one command (make install) will fetch the whole of SQL,
> > Apache and Postgres, install all of them and all dependancies
> > and you are ready to run. It took about three or four hours
> > for FreeBSD to fetch everything, compile it all and install
> > it but I just watched TV and when I came back I edited one
> > config file and it all ran perfectly. Like Vlad points out,
> > you don't need X on the server so it can run on any old box.
> >
> > Jeff
> >
> > Vladimir Botka wrote:
> > >> Normally I use SME/Mitel/E-smith for my SL installes,
> >
> > however I have
> >
> > >> a site that wants SL, already has a SME doing way to many other
> > >> tasks.. what would the"list" recomend for simple Linux OS
> >
> > to install
> >
> > >> SL as a stand alone server??
> > >>
> > >> Thanks,
> > >>
> > >> PS, sorry if this is a duplicate.. I did not see my post
> >
> > arrive last
> >
> > >> time....
> > >
> > > Hello, as a standalone server consider FreeBSD. Get rid of
> >
> > the X and
> >
> > > desktop management configuration, just install the applications you
> > > need for SL (apache, sql, ...) Also the security management
> >
> > will be easier.
> >
> > > If you decide for linux try Debian or Redhat server. No
> >
> > SUSe after M$
> >
> > > aliance.
> > >
> > > Cheers, -vlado
> >
> > ----------------------------------------------------------------------
> >
> > > --- Take Surveys. Earn Cash. Influence the Future of IT Join
> > > SourceForge.net's Techsay panel and you'll get the chance to share
> > > your opinions on IT & business topics through brief
> >
> > surveys-and earn
> >
> > > cash
> >
> > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEV
> >
> > > DEV _______________________________________________
> > > sql-ledger-users mailing list
> > > sql...@li...
> > > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> > --------------------------------------------------------------
> > -----------
> > Take Surveys. Earn Cash. Influence the Future of IT Join
> > SourceForge.net's Techsay panel and you'll get the chance to
> > share your opinions on IT & business topics through brief
> > surveys-and earn cash
> > http://www.techsay.com/default.php?page=join.php&p=sourceforge
> > &CID=DEVDEV
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Best Linux OS for SL?

[ATM L. <atm...@km...>]

Ok...  Well, I am game for Free-BSD, and have played with it a bit..., If I
have the power, any reason I should still not go with the GUI?  (Will be run
on a HP Xeon 2Ghz with 512M, not sure what drive/drives I will put in yet...

Also, here for the BSD
ftp://ftp.freebsd.org/pub/FreeBSD/releases/i386/ISO-IMAGES/6.2/

Then this to install SL
To install the port: cd /usr/ports/finance/sql-ledger/ && make install clean
To add the package: pkg_add -r sql-ledger

(Do I have to add the package???  First?/After?/Never?)

When its done will I be good to PDF invoices?  Or am I back to trying to get
everything working again?

Thanks for the Ideas, I will be going FreeBSD unless it gets too cranky,
then I will give up and go CentOS...
	
I guess the bigest Question would be ... Could/Should/I leave the GUI etc??/
If I did, can you think of any other 'Kewl' uses for it?

---Andrew
ATM Logic

 

> -----Original Message-----
> From: sql...@li... 
> [mailto:sql...@li...] On 
> Behalf Of Jeff Roberts
> Sent: Saturday, March 10, 2007 1:45 PM
> To: sql...@li...
> Subject: Re: [SL] Best Linux OS for SL?
> 
> Hi ATM Logic
> 
> I agree with Vlad, I installed it on a FreeBSD box and the 
> install couldn't have been simpler. There is a port for 
> SQL-Ledger, (it was version 2.6.22 when i installed in Dec)  
> and one command (make install) will fetch the whole of SQL, 
> Apache and Postgres, install all of them and all dependancies 
> and you are ready to run. It took about three or four hours 
> for FreeBSD to fetch everything, compile it all and install 
> it but I just watched TV and when I came back I edited one 
> config file and it all ran perfectly. Like Vlad points out, 
> you don't need X on the server so it can run on any old box.
> 
> Jeff
> 
> 
> Vladimir Botka wrote:
> >> Normally I use SME/Mitel/E-smith for my SL installes, 
> however I have 
> >> a site that wants SL, already has a SME doing way to many other 
> >> tasks.. what would the"list" recomend for simple Linux OS 
> to install 
> >> SL as a stand alone server??
> >>  
> >> Thanks,
> >>  
> >> PS, sorry if this is a duplicate.. I did not see my post 
> arrive last 
> >> time....
> >>     
> >
> > Hello, as a standalone server consider FreeBSD. Get rid of 
> the X and 
> > desktop management configuration, just install the applications you 
> > need for SL (apache, sql, ...) Also the security management 
> will be easier.
> > If you decide for linux try Debian or Redhat server. No 
> SUSe after M$ 
> > aliance.
> >
> > Cheers, -vlado
> >
> > 
> ----------------------------------------------------------------------
> > --- Take Surveys. Earn Cash. Influence the Future of IT Join 
> > SourceForge.net's Techsay panel and you'll get the chance to share 
> > your opinions on IT & business topics through brief 
> surveys-and earn 
> > cash 
> > 
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEV
> > DEV _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> >
> >   
> 
> --------------------------------------------------------------
> -----------
> Take Surveys. Earn Cash. Influence the Future of IT Join 
> SourceForge.net's Techsay panel and you'll get the chance to 
> share your opinions on IT & business topics through brief 
> surveys-and earn cash 
> http://www.techsay.com/default.php?page=join.php&p=sourceforge
> &CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> 

Re: [SL] Howto recover a deleted invoice

[<la...@cl...>]

Have you try looking into Postgres' point-in-time recovery? I believe
Postgres by default turn on transaction logging so you may just want to
look into this topic for sure. Typically, that's done by restoring the
last full backup, and then start rolling forward the logs since the last
full backup until the point just prior to the invoice was deleted. So just
one invoice? Interesting...could you just recreate the invoice with the
paperwork or info. that you may have?

> Simple:
>
> Use the back browser button to get to the invoice then edit it to match
> the original invoice (that was overwritten) "post as new"
>
> That way way the 'original' gets posted as a new invoice
>
> The one that was "posted" instead of "posted as new" gets left alone.
>
> Jeff
>
>
> Dr Eberhard Lisse wrote:
>> Doesn't SL do this with an transaction ID, so that you can have two
>> invoices with the same invoice number if you want? In other words, would
>> it not overwrite the new one?
>>
>> Never mind, if this happens to you, it does teach you, to conentrate
>> :-)-O
>>
>> el
>>
>> on 3/10/07 1:52 PM Craig Isdahl said the following:
>>
>>> We'll I'm no SL expert but if they did a "post as new" it created a
>>> new invoice w/ a new invoice number.  Assuming they are able to go
>>> "back" in the browser to the original unmodified invoice they could
>>> repost it, re-creating the original and leaving the new one.  Is my
>>> logic flawed?
>>>
>>>
>>
>> -------------------------------------------------------------------------
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share
>> your
>> opinions on IT & business topics through brief surveys-and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> sql-ledger-users mailing list
>> sql...@li...
>> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>>
>>
>>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>

Re: [SL] Best Linux OS for SL?

[Jeff R. <je...@jr...>]

Hi ATM Logic

I agree with Vlad, I installed it on a FreeBSD box and the install 
couldn't have been simpler. There is a port for SQL-Ledger, (it was 
version 2.6.22 when i installed in Dec)  and one command (make install) 
will fetch the whole of SQL, Apache and Postgres, install all of them 
and all dependancies and you are ready to run. It took about three or 
four hours for FreeBSD to fetch everything, compile it all and install 
it but I just watched TV and when I came back I edited one config file 
and it all ran perfectly. Like Vlad points out, you don't need X on the 
server so it can run on any old box.

Jeff


Vladimir Botka wrote:
>> Normally I use SME/Mitel/E-smith for my SL installes, however I have
>> a site that wants SL, already has a SME doing way to many other
>> tasks.. what would the"list" recomend for simple Linux OS to install
>> SL as a stand alone server??
>>  
>> Thanks,
>>  
>> PS, sorry if this is a duplicate.. I did not see my post arrive last
>> time....
>>     
>
> Hello, as a standalone server consider FreeBSD. Get rid of the X and
> desktop management configuration, just install the applications you need
> for SL (apache, sql, ...) Also the security management will be easier.
> If you decide for linux try Debian or Redhat server. No SUSe after M$
> aliance.
>
> Cheers, -vlado
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>   

Re: [SL] Howto recover a deleted invoice

[Jeff R. <je...@jr...>]

Simple:

Use the back browser button to get to the invoice then edit it to match 
the original invoice (that was overwritten) "post as new"

That way way the 'original' gets posted as a new invoice

The one that was "posted" instead of "posted as new" gets left alone.

Jeff


Dr Eberhard Lisse wrote:
> Doesn't SL do this with an transaction ID, so that you can have two
> invoices with the same invoice number if you want? In other words, would
> it not overwrite the new one?
>
> Never mind, if this happens to you, it does teach you, to conentrate :-)-O
>
> el
>
> on 3/10/07 1:52 PM Craig Isdahl said the following:
>   
>> We'll I'm no SL expert but if they did a "post as new" it created a
>> new invoice w/ a new invoice number.  Assuming they are able to go
>> "back" in the browser to the original unmodified invoice they could
>> repost it, re-creating the original and leaving the new one.  Is my
>> logic flawed?
>>
>>     
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>   

[SL] Accounts Payable reports

[Danita Z. <da...@ca...>]

Okay - I am having a difficult time translating something I used to do to =
Quickbooks, so maybe someone can help me.  I have some "vendors" who are =
authors that I pay royalties to.  We also make various expenditures on the =
authors' behalf throughout the year. =20

So, I will have a vendor "invoice" or AP transaction (can't figure out =
which would be better) for the royalties due for a quarter.  Then I might =
have an expenditure for that author for returns, or affiliate fees, or =
association dues, etc.  I could pay a payment to a different vendor, and =
assign it to the amount due to the author.  I can't see a way to do that.  =
For example, if I pay $10 to an affiliate, and want to decrease the amount =
due to the author by that amount, I can't see how to do that.  I.e., how =
can I pay a second vendor, and assign part or all of the payment to the =
"AP" account of another vendor.

Danita

Re: [SL] Printer Output Default/Media

[Florian R. <fl...@re...>]

Hi,

i looked a bit in the documentation, and some minutes in the source.

How can the printer media enforced, e.g. only create pdf, no html, no
postscript. And or how could be PDF marked as default?


thanks in advance..

-- 
Florian Reitmeir

Re: [SL] /sql-ledger/login.pl: symbol lookup error

[Joseph <sy...@in...>]

On Fri, 2007-03-09 at 23:44 +0000, Joseph wrote:
> After upgrading several perl script, when I try to log-in to sql-ledger
> I get:
> /usr/local/sql-ledger/login.pl: symbol lookup error: /usr/lib/perl5/vendor_perl/5.8.8/i686-linux/auto/DBD/Pg/Pg.so: undefined symbol: PQserverVersion
> [client 127.0.0.1] Premature end of script headers: login.pl
> 
> Can anybody point me in the right direction?

According to documentation from:
http://cpan.uwinnipeg.ca/htdocs/DBD-Pg/README.html 
-----quote------
If you get an error message like:

perl: error while loading shared libraries:
/usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBD/Pg/Pg.so: undefined
symbol: PQconnectdb

when you call DBI->connect, then your libpq.so was probably not seen at
build-time. This should have caused 'make test' to fail; did you really run it
and look at the output? Check the setting of POSTGRES_LIB and recompile DBD-Pg.
-----end quote-------

Can somebody provide a hint how to ""Check the setting of POSTGRES_LIB" ?

Joseph