sql-ledger-users — SQL-Ledger users

Re: Multiple companies and consolidated company reports

[Markus D. <mda...@sw...>]

Dr Default wrote:

>If you can export balance sheet plus P/L to a text file you could then
>import to a multiple page spreadsheet, 
>one per company, and put a totals page at the end.. Bit of extra work,
>but then in consolidation you might 
>want to review some things anyway..
>
This is a bit simplistic. At least intercompany must be excluded from 
consolidation... 

RE: Multiple companies and consolidated company reports

[Dr D. <drd...@ho...>]

If you can export balance sheet plus P/L to a text file you could then
import to a multiple page spreadsheet, 
one per company, and put a totals page at the end.. Bit of extra work,
but then in consolidation you might 
want to review some things anyway..

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of
Dieter Simader
Sent: donderdag 21 maart 2002 20:44
To: Michael A. Salvucci
Cc: sql...@li...
Subject: Re: Multiple companies and consolidated company reports


Multiple companies, yes, consolidation, no.


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 Thu, 21 Mar 2002, Michael A. Salvucci wrote:

> Does anyone know if sql-ledger handles multiple companies?
> 
> and
> 
> Can these multiple companies can be consolidated into one report?
> 
> Thanks,
> Mike Salvucci
> 
> 

Re: Multiple companies and consolidated company reports

[Michael A. S. <msa...@se...>]

hmmm...   How do we set up multiple companies?  Maybe I'm blind, but I don't 
see a link for that.

If the companies are stored in the same database, then I think we can write 
some scripts for consolidated reports.  Right?

Thanks,
Mike Salvucci



On Thursday 21 March 2002 01:43 pm, Dieter Simader wrote:
> Multiple companies, yes, consolidation, no.
>
>
> 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 Thu, 21 Mar 2002, Michael A. Salvucci wrote:
> > Does anyone know if sql-ledger handles multiple companies?
> >
> > and
> >
> > Can these multiple companies can be consolidated into one report?
> >
> > Thanks,
> > Mike Salvucci

Re: Double posts

[Richard L. <ri...@th...>]

On Thursday 21 March 2002 22:25, David Tupper wrote:
> Is it just me or is everyone getting everything (at least) twice?
> 
> David Tupper

Just once (except replies to my posts).  But then I haven't had a drop all 
day...

--
richard

Double posts

[David T. <alp...@or...>]

Is it just me or is everyone getting everything (at least) twice?

David Tupper

printing

[Jeff S. <js...@en...>]

Hello all,

I'm having some problems printing. When the files are sent to the printer,
there's a good 6-7 inches of white space at the top of the page before any
content appears. This seems to be happening with all the templates. I'm
printing to an HP LaserJet 4050N.

Thanks,

Jeff

A copy of the invoice template follows:


\documentclass[twoside]{scrartcl}
\usepackage[frame]{xy}
\usepackage{tabularx}
\setlength{\voffset}{0.5cm}
\setlength{\hoffset}{-2.0cm}
\setlength{\topmargin}{0cm}
\setlength{\headheight}{0.5cm}
\setlength{\headsep}{1cm}
\setlength{\topskip}{0pt}
\setlength{\oddsidemargin}{1.0cm}
\setlength{\evensidemargin}{1.0cm}
\setlength{\textwidth}{19.2cm}
\setlength{\textheight}{24.5cm}
\setlength{\footskip}{1cm}
\setlength{\parindent}{0pt}
\renewcommand{\baselinestretch}{1}
\begin{document}

\newlength{\descrwidth}\setlength{\descrwidth}{10cm}

\newsavebox{\hdr}
\sbox{\hdr}{
  \fontfamily{cmss}\fontsize{10pt}{12pt}\selectfont

  \parbox{\textwidth}{
    \parbox[b]{12cm}{
      <%company%>

      <%address%>}\hfill
    \begin{tabular}[b]{rr@{}}
    Telephone & <%tel%>\\
    Facsimile & <%fax%>
    \end{tabular}

    \rule[1.5ex]{\textwidth}{0.5pt}
  }
}

\fontfamily{cmss}\fontshape{n}\selectfont

\markboth{<%company%>\hfill <%invnumber%>}{\usebox{\hdr}}

\pagestyle{myheadings}
%\thispagestyle{empty}     use this with letterhead paper

<%pagebreak 90 27 48%>
\end{tabular*}

  \rule{\textwidth}{2pt}

  \hfill
  \begin{tabularx}{7cm}{Xr@{}}
  \textbf{Subtotal} & \textbf{<%sumcarriedforward%>} \\
  \end{tabularx}

\newpage

\markright{<%company%>\hfill <%invnumber%>}

\vspace*{-12pt}

\begin{tabular*}{\textwidth}{@{}lp{\descrwidth}@{\extracolsep\fill}rlrrr@{}}
  \textbf{Number} & \textbf{Description} & \textbf{Qt'y} &
    \textbf{Unit} & \textbf{Price} & \textbf{Disc} & \textbf{Amount} \\
  & carried forward from page <%lastpage%> & & & & & <%sumcarriedforward%>
\\
<%end pagebreak%>


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

\vspace*{2cm}

<%name%>

<%addr1%>

<%addr2%>

<%addr3%>

<%addr4%>

\vspace{3.5cm}

\textbf{I N V O I C E}
\hfill
\begin{tabular}[t]{l@{\hspace{0.3cm}}l}
  \textbf{Date} & <%invdate%> \\
  \textbf{Number} & <%invnumber%> \\
  \textbf{Customer} & <%customer_id%>
\end{tabular}

\vspace{1cm}

\begin{tabular*}{\textwidth}{@{}lp{\descrwidth}@{\extracolsep\fill}rlrrr@{}}
  \textbf{Number} & \textbf{Description} & \textbf{Qt'y} &
    \textbf{Unit} & \textbf{Price} & \textbf{Disc} & \textbf{Amount} \\
<%foreach number%>
  <%number%> & <%description%> & <%qty%> &
    <%unit%> & <%sellprice%> & <%discount%> & <%linetotal%> \\
<%end number%>
\end{tabular*}


\parbox{\textwidth}{
\rule{\textwidth}{2pt}

\vspace{0.2cm}

\hfill
\begin{tabularx}{7cm}{Xr@{}}
  \textbf{Subtotal} & \textbf{<%subtotal%>} \\
<%foreach tax%>
  <%taxdescription%> on <%taxbase%> & <%tax%>\\
<%end tax%>
  \hline
  \textbf{Total} & \textbf{<%total%>}\\
\end{tabularx}

\vspace{0.3cm}

\hfill
  All prices in \textbf{<%currency%>} funds.

\vspace{12pt}

<%if notes%>
  <%notes%>
<%end if%>

}

\vfill
\centerline{\textbf{Thank You for your valued business!}}

\renewcommand{\thefootnote}{\fnsymbol{footnote}}

\footnotetext[1]{\tiny
Payment due NET <%terms%> Days from date of Invoice. Interest on overdue
amounts will acrue at the rate of 1.5\% per month starting from <%duedate%>
until paid in full. Items returned are subject to a 10\% restocking charge.
A return authorization must be obtained from <%company%> before goods are
returned. Returns must be shipped prepaid and properly insured.
<%company%> will not be responsible for damages during transit.}

\end{document}

Re: new to sql-ledger and postgresql.

[Gianluca C. <te...@li...>]

You can also modify the postgresql.conf file:

tcpip_socket = true

You have also to grant access to the clients, modifying the file
pg_hba.conf, that is in
$PGDATA directory (/usr/local/pgsql/data in my case).
It is self explanatory, for example I introduced this line in it

host all 192.168.0.0 255.255.0.0 trust

supposing that clients connections arrive from 192.168.0.0 network.

HIH.



Bye,

Gianluca

----- Original Message -----
From: "Olaf Faaland" <ofa...@at...>
To: "klavs klavsen" <kl...@vs...>; "SQL-Ledger mailinglist"
<sql...@li...>
Sent: Thursday, March 21, 2002 4:51 PM
Subject: Re: new to sql-ledger and postgresql.


> Klav,
>
> See the snippet below from the Postgres manual.  Perhaps sql-ledger is
> trying to connect via TCP, but Postgres is only accepting connections via
> UDP (the Postgres default, at least at one time).
>
> -Olaf
>
> =======================
>
> 3.3.2. Client Connection Problems
> Although the error conditions possible on the client side are quite varied
> and application-dependent, a few of them might be directly related to how
> the server was started up. Conditions other than those shown below should
be
> documented with the respective client application.
>
>
> psql: could not connect to server: Connection refused
>         Is the server running on host server.joe.com and accepting
>         TCP/IP connections on port 5432?
> This is the generic "I couldn't find a server to talk to" failure. It
looks
> like the above when TCP/IP communication is attempted. A common mistake is
> to forget the -i option to allow the postmaster to accept TCP/IP
> connections.
>
> Alternatively, you'll get this when attempting Unix-socket communication
to
> a local postmaster:
>
> psql: could not connect to server: Connection refused
>         Is the server running locally and accepting
>         connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
>
> ----- Original Message -----
> From: "klavs klavsen" <kl...@vs...>
> To: "SQL-Ledger mailinglist" <sql...@li...>
> Sent: Thursday, March 21, 2002 5:53 AM
> Subject: new to sql-ledger and postgresql.
>
>
>
>
>

Re: Multiple companies and consolidated company reports

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

Multiple companies, yes, consolidation, no.


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 Thu, 21 Mar 2002, Michael A. Salvucci wrote:

> Does anyone know if sql-ledger handles multiple companies?
> 
> and
> 
> Can these multiple companies can be consolidated into one report?
> 
> Thanks,
> Mike Salvucci
> 
> 

Quotes

[Wes W. <we...@lp...>]

Does sql-ledger handle quoting?  I was tying to search the archive, but
I couldn't find any way to do it.  Any help of suggestions are
appreciated.

				Wes

Multiple companies and consolidated company reports

[Michael A. S. <msa...@se...>]

Does anyone know if sql-ledger handles multiple companies?

and

Can these multiple companies can be consolidated into one report?

Thanks,
Mike Salvucci

Re: new to sql-ledger and postgresql.

[Olaf F. <ofa...@at...>]

Klav,

See the snippet below from the Postgres manual.  Perhaps sql-ledger is
trying to connect via TCP, but Postgres is only accepting connections via
UDP (the Postgres default, at least at one time).

-Olaf

=======================

3.3.2. Client Connection Problems
Although the error conditions possible on the client side are quite varied
and application-dependent, a few of them might be directly related to how
the server was started up. Conditions other than those shown below should be
documented with the respective client application.


psql: could not connect to server: Connection refused
        Is the server running on host server.joe.com and accepting
        TCP/IP connections on port 5432?
This is the generic "I couldn't find a server to talk to" failure. It looks
like the above when TCP/IP communication is attempted. A common mistake is
to forget the -i option to allow the postmaster to accept TCP/IP
connections.

Alternatively, you'll get this when attempting Unix-socket communication to
a local postmaster:

psql: could not connect to server: Connection refused
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

----- Original Message -----
From: "klavs klavsen" <kl...@vs...>
To: "SQL-Ledger mailinglist" <sql...@li...>
Sent: Thursday, March 21, 2002 5:53 AM
Subject: new to sql-ledger and postgresql.

new to sql-ledger and postgresql.

[klavs k. <kl...@vs...>]

Hi guys,

I just installed rpm's of postgresql, and installed sql-ledger.

When I try to connect and "Create Dataset" from admin.pl, it keeps
giving me "Error. Could not connect to server: connection refused".

I tried adding a new postgres user (tnx. for the link to postgresql
guide I got earlier on the list). I still get the same error even though
I added the user, with the -P (to set password).
postgresql listens on udp 1045 according to lsof -i udp.

what am I missing?
--=20
Regards,
Klavs Klavsen

-------------| This mail has been sent to you by: |------------
              Klavs Klavsen - Open Source Consultant=20
                 kl...@vs... - http://www.vsen.dk

    Get PGP key from www.keyserver.net - Key ID: 0x586D5BCA=20
Fingerprint =3D A95E B57B 3CE0 9131 9D15 94DA E1CD 641E 586D 5BCA
--------------------[ I believe that... ]-----------------------
It is a myth that people resist change. People resist what other
people make them do, not what they themselves choose to do...
That's why companies that innovate successfully year after year
seek their peopl's ideas, let them initiate new projects and
encourage more experiments.            -- Rosabeth Moss Kanter

RE: sql-ledger rpm/deb

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

A private installation can be setup without root access. No changes to any
other configuration files are needed. Of course you must have perl, DBI
and DBD-(Pg|Oracle) installed and either Postgres or Oracle running or at
least have access to a SQL server.

1. Unpack SQL-Ledger in your home directory
2. setup one user in postgres
   If your name has already been added or if you use the
   postgres superuser you can forget this step
3. load the webserver (cd dnhttpd/exec; ./dnhttpd.pl)
4. load your browser
5. connect to http://localhost:8000/admin.pl
6. setup a company (Database Administration -> Create Dataset)
7. setup a user (Add User)

log in or connect to http://localhost:8000/login.pl and log in.


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 Wed, 20 Mar 2002, Dr Default wrote:

> I would VERY much like to see this option indeed! 
> 
> Being a 'simple bookkeeper' I did not yet get SQL-ledger up on either
> Suse, Red Hat, Mandrake or ELX. 
> This is very likely mostly due to my lack of Linux skills, the quality
> of the mails in this list and 
> the documentation lead me to believe this is an excellent accounting
> package. Unfortunately I do not have 
> the time to become a Linux specialist any time soon, so RPM or DEB based
> install (now THAT I can do ;-)
> would be perfect. I would be willing to change over to whatever Linux
> distro needed gladly! 
> 
> Because I NEED a semi or pro accounting package, at the moment I am
> stuck to M$. If Debian or any other 
> distro could come with RPM-based (or even as included part, wow!) my
> guess is that 'the penguin' will have 
> a whole bunch of new followers real soon, accounting being the only
> thing missing for SOHO needs up till now. 
> 
> An easy foolproof (that's me again ;-) Linux install with spreadsheet,
> mail, word editor, browser and accounting 
> package is more than ample for 99% of small to medium size companies. 
> 
> I can hardly wait..

Re: Report Bugs

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

If a string has not been translated English is used instead.


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 Wed, 20 Mar 2002, Ke Deng wrote:

> Hi,all:
>     I like sql-ledger very much and hope it better and better.Now I have two
> bugs to report.I use version 1.8.2.
>     1)When I create sale invoice from sale order(brower sale order and then
> click "create invoice" button),the sale invoice form has not use current
> locale variants,for example,if I use Italian,some fields of the form display
> Italian,and some others display english,I think it's a bug.
>     2)I enter "edit part" form in the way that I click part number of part
> in the "edit assembly" form,when i save changes modified in the form ,it
> prompt incorrect password,although it real does commit change to the
> database.
> thanks,
>         Karl.
> 
> 
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
> 
> 
> 

RE: Inventory not incrementing

[Sergio M. <ma...@ds...>]

Does SQL-Ledger offer the functionality to capture inventory going out.  For
example, the system will actually decrease the inventory when invoice is
posted.  Since items are still in inventory warehouse, there is a pick
process, then there is a control quality process.  Do you guys have
suggestions on controling Inventory going out of warehouse?


Thanks...
Sergio

RE: sql-ledger rpm/deb

[Dr D. <drd...@ho...>]

I would VERY much like to see this option indeed! 

Being a 'simple bookkeeper' I did not yet get SQL-ledger up on either
Suse, Red Hat, Mandrake or ELX. 
This is very likely mostly due to my lack of Linux skills, the quality
of the mails in this list and 
the documentation lead me to believe this is an excellent accounting
package. Unfortunately I do not have 
the time to become a Linux specialist any time soon, so RPM or DEB based
install (now THAT I can do ;-)
would be perfect. I would be willing to change over to whatever Linux
distro needed gladly! 

Because I NEED a semi or pro accounting package, at the moment I am
stuck to M$. If Debian or any other 
distro could come with RPM-based (or even as included part, wow!) my
guess is that 'the penguin' will have 
a whole bunch of new followers real soon, accounting being the only
thing missing for SOHO needs up till now. 

An easy foolproof (that's me again ;-) Linux install with spreadsheet,
mail, word editor, browser and accounting 
package is more than ample for 99% of small to medium size companies. 

I can hardly wait..

>
> I'll try to put something together for Redhat 7.2 since that's what 
> I'm currently using.
>
> Any ideas what do you think about the idea in general, how thigs 
> should be set up by default, comments from people who have experience 
> in creating rpm or deb packages and like to help (eq supporting other 
> distibutions), etc. are welcome.

I am (slowly) packaging SQL-Ledger for Debian.

It will be an official part of Debian GNU/Linux, and thus not be put in
/usr/local as Dieter (correctly) suggests on the packaging page.

 - Jonas

-- 
Jonas Smedegaard (+45 40843136)          http://dr.jones.dk/~jonas/
Spiff ApS (= IT-guide dr. Jones ApS)     http://dr.jones.dk/
Debian GNU/Linux developer               http://people.debian.org/~js/

Report Bugs

[Ke D. <szs...@ya...>]

Hi,all:
    I like sql-ledger very much and hope it better and better.Now I have two
bugs to report.I use version 1.8.2.
    1)When I create sale invoice from sale order(brower sale order and then
click "create invoice" button),the sale invoice form has not use current
locale variants,for example,if I use Italian,some fields of the form display
Italian,and some others display english,I think it's a bug.
    2)I enter "edit part" form in the way that I click part number of part
in the "edit assembly" form,when i save changes modified in the form ,it
prompt incorrect password,although it real does commit change to the
database.
thanks,
        Karl.


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

Bug: Total on saved invoice changes when customer tax is edited

[Jonas S. <dr...@jo...>]

Hi Dieter,

I believe the following is a bug in the data storage logic:

1) Create 2 different taxes: "sales tax" and "expense tax" (in Denmark
they are taxed equally but must be tracked and reported separately).

2) Create a new customer (which by default enables both which is wrong,
but leave it as is for now).

3) Create an invoice using the badly configured customer (will be double
taxed) and save it.

4) Edit the customer and correct the error: turn off "expense tax" (which
will never ever be useful here - only for vendors).

5) Find the invoice: the tax calculation has changed!

This is BAD! When I make an invoice I expect that invoice to not change
unless I hit the "update Form" button.

Editing customer/vendor/part/service should apply only to _new_ invoices,
not existing ones.

Currently, published invoices _link_ to entries in the "address book" of
customers/vendors. Correct behavior IMHO would be to _copy_ the info
instead (and possibly re-copy when doing an "Update Form").

I am using SQL-Ledger version 1.8.3.

 - Jonas

-- 
Feel free to quote me wherever. I usually post on d-private because that's
where most developers are. Sadly there's no similar _public_ spot!

Jonas Smedegaard (+45 40843136)          http://dr.jones.dk/~jonas/
Spiff ApS (= IT-guide dr. Jones ApS)     http://dr.jones.dk/
Debian GNU/Linux developer               http://people.debian.org/~js/

Re: Inventory not incrementing

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

Did you use the same part on the customer and vendor invoice or perhaps
do you have two of what seems to be the same item in inventory?

Run an inventory report for the item and check "bought" and "sold". It
will tell you how many items where bought and sold.


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 20 Mar 2002 br...@th... wrote:

> 
> Hi,
> 
> I'm using SQL-Ledger 1.8.2, and have a problem with inventory.
> 
> When I add a Vendor invoice containing received goods, quantity is not
> incremented appropriately in inventory.
> 
> When I invoice the customer for a given part, quantity IS decremented
> appropriately.
> 
> As a result, I now have a number of parts in inventory with a negative
> value. Would this likely be something *I've* overlooked, or is it a
> known problem?
> 
> Further, exactly how much a bad thing(tm) would it be for me to manually
> adjust the quantity in the tables directly (if I've created the correct
> invoices)?
> 
> I'm using the following:
> 
> 	SQL-Ledger 1.8.2
> 	Apache 1.3.23
> 	Postgres 7.2
> 
> Thanks,
> 
> Brad.
>  
> 
> 
> 
> 
> 

Inventory not incrementing

[<br...@th...>]

Hi,

I'm using SQL-Ledger 1.8.2, and have a problem with inventory.

When I add a Vendor invoice containing received goods, quantity is not
incremented appropriately in inventory.

When I invoice the customer for a given part, quantity IS decremented
appropriately.

As a result, I now have a number of parts in inventory with a negative
value. Would this likely be something *I've* overlooked, or is it a
known problem?

Further, exactly how much a bad thing(tm) would it be for me to manually
adjust the quantity in the tables directly (if I've created the correct
invoices)?

I'm using the following:

	SQL-Ledger 1.8.2
	Apache 1.3.23
	Postgres 7.2

Thanks,

Brad.
 

Re: sql-ledger rpm/deb

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

On Tue, Mar 19, 2002 at 10:11:26PM +0100, Jonas Smedegaard wrote:
> On Tue, 19 Mar 2002, Martin Lillepuu wrote:
> 
> > has anybody thought of creating deb/rpm packages of sql-ledger? if all
> > of the rather complicated setup (for unexperienced/first time users)
> > would be done automatically, most topcis about obscure error messages
> > after first install would never appear on this list and everyone could
> > be consentrating on sql-ledger bookkeeping related issues or adding new
> > features to sql-ledger.  the package scripts could be set to handle
> > adding apache configuration, setting direcotory permissions, complaining
> > about failed dependencies, configure postgres authentication, maybe even
> > add shortcuts to user's kde/gnome desktop..
> >
> > I'll try to put something together for Redhat 7.2 since that's what I'm
> > currently using.
> >
> > Any ideas what do you think about the idea in general, how thigs should
> > be set up by default, comments from people who have experience in
> > creating rpm or deb packages and like to help (eq supporting other
> > distibutions), etc. are welcome.
> 
> I am (slowly) packaging SQL-Ledger for Debian.
> 
> It will be an official part of Debian GNU/Linux, and thus not be put in
> /usr/local as Dieter (correctly) suggests on the packaging page.

When will the debian package be available?

keld

Re: sql-ledger rpm/deb

[Jonas S. <dr...@jo...>]

On Tue, 19 Mar 2002, Martin Lillepuu wrote:

> has anybody thought of creating deb/rpm packages of sql-ledger? if all
> of the rather complicated setup (for unexperienced/first time users)
> would be done automatically, most topcis about obscure error messages
> after first install would never appear on this list and everyone could
> be consentrating on sql-ledger bookkeeping related issues or adding new
> features to sql-ledger.  the package scripts could be set to handle
> adding apache configuration, setting direcotory permissions, complaining
> about failed dependencies, configure postgres authentication, maybe even
> add shortcuts to user's kde/gnome desktop..
>
> I'll try to put something together for Redhat 7.2 since that's what I'm
> currently using.
>
> Any ideas what do you think about the idea in general, how thigs should
> be set up by default, comments from people who have experience in
> creating rpm or deb packages and like to help (eq supporting other
> distibutions), etc. are welcome.

I am (slowly) packaging SQL-Ledger for Debian.

It will be an official part of Debian GNU/Linux, and thus not be put in
/usr/local as Dieter (correctly) suggests on the packaging page.

 - Jonas

-- 
Jonas Smedegaard (+45 40843136)          http://dr.jones.dk/~jonas/
Spiff ApS (= IT-guide dr. Jones ApS)     http://dr.jones.dk/
Debian GNU/Linux developer               http://people.debian.org/~js/

Email'ed invoices/sales orders are blank...

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

I recently upgraded to the latest sql-ledger and now have an issue with 
emailing invoices or sales orders...

If I select HTML and EMAIL I get an attached file of 7 bytes that only 
contains

<HEAD>

and terminates.... My templates display correctly when directed to screen. Is 
there something I need to change on my templates to have them work correctly 
with this new update?

Thanks,
Dave

Re: sql-ledger rpm/deb

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

I posted some information for building a package at
http://www.sql-ledger.org/source/packaging.html

The Debian package is beeing looked after by Wolfgang Sourdeau.


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, 19 Mar 2002, Martin Lillepuu wrote:

> hello,
> 
> has anybody thought of creating deb/rpm packages of sql-ledger? if all of the 
> rather complicated setup (for unexperienced/first time users) would be done 
> automatically, most topcis about obscure error messages after first install 
> would never appear on this list and everyone could be consentrating on 
> sql-ledger bookkeeping related issues or adding new features to sql-ledger. 
> the package scripts could be set to handle adding apache configuration, 
> setting direcotory permissions, complaining about failed dependencies, 
> configure postgres authentication, maybe even add shortcuts to user's 
> kde/gnome desktop.. 
> 
> I'll try to put something together for Redhat 7.2 since that's what I'm 
> currently using.
> 
> Any ideas what do you think about the idea in general, how thigs should be 
> set up by default, comments from people who have experience in creating rpm 
> or deb packages and like to help (eq supporting other distibutions), etc. are 
> welcome. 
> 
> 

sql-ledger rpm/deb

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

hello,

has anybody thought of creating deb/rpm packages of sql-ledger? if all of the 
rather complicated setup (for unexperienced/first time users) would be done 
automatically, most topcis about obscure error messages after first install 
would never appear on this list and everyone could be consentrating on 
sql-ledger bookkeeping related issues or adding new features to sql-ledger. 
the package scripts could be set to handle adding apache configuration, 
setting direcotory permissions, complaining about failed dependencies, 
configure postgres authentication, maybe even add shortcuts to user's 
kde/gnome desktop.. 

I'll try to put something together for Redhat 7.2 since that's what I'm 
currently using.

Any ideas what do you think about the idea in general, how thigs should be 
set up by default, comments from people who have experience in creating rpm 
or deb packages and like to help (eq supporting other distibutions), etc. are 
welcome. 

-- 
Martin Lillepuu | e-mail: ma...@li... | gsm: +372 515 6450