sql-ledger-users — SQL-Ledger users

Re: sequence ID.

[Sergio A. K. <ser...@ho...>]

yup.

you can have a sequence for every table, or just one
sequence for all tables.

dieter choose the second, that IMO is the more simple
solution and work well, you don't need more than that...

or put it in another way: why you will want 20 sequences 
when only one do the job just fine ?  ;)

/sergio

----- Original Message ----- 
From: "MR" <mtr...@du...>


> Am I correct in my observation that the sequence ID is the basis of
> oe.id
> oe.vendor_id
> oe.customer_id
> 
> orderitems.trans_id
> orderitems.parts_id
> 
> and a few other places I'm not sticking my fingers into?
> 
> 
> 

sequence ID.

[MR <mtr...@du...>]

Am I correct in my observation that the sequence ID is the basis of 
oe.id
oe.vendor_id
oe.customer_id

orderitems.trans_id
orderitems.parts_id

and a few other places I'm not sticking my fingers into?

Has anyone used the console interface API? http://www.sql-ledger.org/mi

[MR <mtr...@du...>]

sc/api.html

Before I go off down some dead ends.... 

Has anyone any code examples of inserting data into oe.pl from the command     
line beyond the documentation at:
http://www.sql-ledger.org/misc/api.html

Re: any body can guide me how to start using sql-ledger

[Kenneth G. <la...@th...>]

there is no opening balance module. you have to individually enter the 
vouchers to get the starting balance
kg
On Sunday 17 March 2002 20:25, cheraslab ccl wrote:
> Hello friends, Iam new to this software. I managed to install and able to
> log in to the software system. However iam in the dark how to set the
> starting balance.
>
> My trial so far is unsuccesfull
>
> thank
>
>
> "CHERAS COMPUTER LABORATORY". 30A Jalan Sembilang Taman Tenaga KM6 Jalan
> Cheras 56000 KUALA LUMPUR MALAYSIA. Print, Scan, Fax, PhotoCopy, Typing,
> Surfing, Voice Chat, WebCam
> -The Only Computer Lab with Voice and Camera Facility-
>
>
> ------------------------------------------------------------
> Malaysia Free Web Based Mail at Mesra.net http://www.mesra.net
>
>
> ---------------------------------------------------------------------
> Express yourself with a super cool email address from BigMailBox.com.
> Hundreds of choices. It's free!
> http://www.bigmailbox.com
> ---------------------------------------------------------------------

Should I be seeing 'auto incrementation' of the order number?

[MR <mtr...@du...>]

I thought at one time the order number 'auto incremented', but in todays 
work I'm doing with ripping out OE.pm to make it stand alone and driven
from a externally parsed text file, I am not seeing auto-increment 
behavior in the web pages.

So:  Was I on the cheap crack (becuase I hadn't got billing out and therefore
can get the good stuff :-)  or have I missed some sort of flag that allows
the next logical ordernum to be placed on the web page?

For the code I'm writing, its a non-problem, but my memory says that the web
page used to auto-increment, and I seek clarity on this.  

database connection difficulty

[kevin b. <kev...@bi...>]

hi there,

i'm still at the proof of concept stage.  i have successfully setup SL 
to work on my debian woody workstation - but now i need it to run on my 
co-located server which runs slackware.

i have created a new DB from a template and created a user.

however - when i try to connect i get the following message.



Database Error: PQconnectPoll() -- connect() failed: Connection refused

in the browser,

sorry i can't find any other log messages - this is a slackware distro 
and i can't find my way around it as easily as debian,

TIA

kev bailey

any body can guide me how to start using sql-ledger

[cheraslab c. <che...@me...>]

Hello friends, Iam new to this software. I managed to install and able to log in to the software system. However iam in the dark how to set the starting balance.

My trial so far is unsuccesfull

thank


"CHERAS COMPUTER LABORATORY". 30A Jalan Sembilang Taman Tenaga KM6 Jalan Cheras 56000 KUALA LUMPUR MALAYSIA.
Print, Scan, Fax, PhotoCopy, Typing, Surfing, Voice Chat, WebCam
-The Only Computer Lab with Voice and Camera Facility-


------------------------------------------------------------
Malaysia Free Web Based Mail at Mesra.net http://www.mesra.net


---------------------------------------------------------------------
Express yourself with a super cool email address from BigMailBox.com.
Hundreds of choices. It's free!
http://www.bigmailbox.com
---------------------------------------------------------------------

Re: LaTeX selection followup

[Sergio A. K. <ser...@ho...>]

dieter, can you make the announcements on this list also ?

it doesn't seem to me this list is high traffic...
(and I don't think you make announcements every day)

/sergio

----- Original Message ----- 
From: "Dieter Simader" <dsi...@sq...>


> I made it clear in my announcement that the config file needs to be
> changed.

Re: LaTeX selection followup

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

On Sat, 16 Mar 2002, Dieter Simader wrote:

> I made it clear in my announcement that the config file needs to be
> changed.

I noticed that some of the info in the announcement was not mentioned in
the Readme as well (like LaTeX requirements). I assume it is not required
to read *both* readme and announcement when doing an install/upgrade?

As a sidenote - I had problems reading the pdf file (xpdf doesn't like
type 3 fonts) so I switched to using dvipdfm (instead of the gs dvipdf).
It generates smaller pdf files that renders nicer. It seems to generate
quicker as well :-)

NB: Debian users need the package tetex-extra.

 - 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/

Re: LaTeX selection followup

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

I made it clear in my announcement that the config file needs to be
changed.

excerpt from the announce message.
----------
Installation:
over top, no changes to the tables are required at this time

copy sql-ledger.conf.default to sql-ledger.conf

If you have modified sql-ledger.conf merge the changes from the default
file rather than copying over top.
-------------


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

On Sat, 16 Mar 2002, MR wrote:

> >I got the same problem after upgrading from 1.8.2
> ....
> >did a new install. Now the options are there.
> 
> It is not well documented, but the file sql-ledger.conf changed.
> 
> (I figured it out 10 mins after sending the mail to the list.)
> 
> >Btw, I tried to modify to *.tex files with LyX.
> 
> Hrmmmm, I'll have to try some convolutions like latex2rtf, then import .rtf     
> into Abiword, then output .latex.  Or import the html, and output the .latex.
> 
> It shouldn't MATTER  what generates the .tex output.  But with .tex
> my page formatting stays the same for paper output.  Netscape print is
> different then mozilla, hence the search for a format that stays the same,
> like LaTeX.
> 
> 
> 
> 

LaTeX selection followup

[MR <mtr...@du...>]

>I got the same problem after upgrading from 1.8.2
....
>did a new install. Now the options are there.

It is not well documented, but the file sql-ledger.conf changed.

(I figured it out 10 mins after sending the mail to the list.)

>Btw, I tried to modify to *.tex files with LyX.

Hrmmmm, I'll have to try some convolutions like latex2rtf, then import .rtf     
into Abiword, then output .latex.  Or import the html, and output the .latex.

It shouldn't MATTER  what generates the .tex output.  But with .tex
my page formatting stays the same for paper output.  Netscape print is
different then mozilla, hence the search for a format that stays the same,
like LaTeX.

Re: LaTeX selection?

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

I got the same problem after upgrading from 1.8.2
Even after installation of LaTeX, sql-ledger didn't display the radio 
buttons for formats "ps" and "pdf". I erased the install directory 
completely and did a new install. Now the options are there.

To avoid printing problems, article no may not contain "_", also check 
tax options if you get latex errors.

Btw, I tried to modify to *.tex files with LyX. Import did not work, 
reLyX neither. Is there an other tool to adapt the tex files to local 
needs (besides inclueded form editor)?

Markus

MR wrote:

>I note that 1.8.3 has LaTeX (thus my delayed research into the LaTeX 
>invoicing seems to be solved).
>
>What I do not see is how to get the LaTeX out however :-(
>
>I spot a radio button for HTML and buttons for send to screen and e-mail
>but I don't know where to set up or get the LaTeX.    
>
>Oh, and as an aside:  If you have an older DBI you see this error:
>Can't use an undefined value as an ARRAY reference at /usr/local/lib/perl5/site_
>perl/5.005/i386-freebsd/DBI.pm line 1016.
>So, if you see that, or have not upgraded to 1.8.3, you may need to 
>upgrade the DBI.
>
>
>

Re: What's meaning of Terms

[Kenneth G. <la...@th...>]

can you please use some standard font when mailing? - looks more like chinese 
than english
kg
On Saturday 16 March 2002 08:50, Ke Deng wrote:
> Hi,all:
>     I 've already installed SQL-ledger on my host and understand most of
> this accounting system.But because of not familiar deeply with accounting
> ,I don't know the meaning of a few accounting terms below:
>     1)List Prices 2)Bin 3)ROP(ReOrder Point?).
>
>     In order to use this software better,I want to know what's meaning of
> these terms.
> thanks,
>     Karl Deng.
>
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com

LaTeX selection?

[MR <mtr...@du...>]

I note that 1.8.3 has LaTeX (thus my delayed research into the LaTeX 
invoicing seems to be solved).

What I do not see is how to get the LaTeX out however :-(

I spot a radio button for HTML and buttons for send to screen and e-mail
but I don't know where to set up or get the LaTeX.    

Oh, and as an aside:  If you have an older DBI you see this error:
Can't use an undefined value as an ARRAY reference at /usr/local/lib/perl5/site_
perl/5.005/i386-freebsd/DBI.pm line 1016.
So, if you see that, or have not upgraded to 1.8.3, you may need to 
upgrade the DBI.

What's meaning of Terms

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

Hi,all:
    I 've already installed SQL-ledger on my host and understand most of
this accounting system.But because of not familiar deeply with accounting ,I
don't know the meaning of a few accounting terms below:
    1)List Prices 2)Bin 3)ROP(ReOrder Point?).

    In order to use this software better,I want to know what's meaning of
these terms.
thanks,
    Karl Deng.


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

Re: Is it possible to make subaccounts in chart of accounts ?

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

Hi Peter.


This is why I wrote that csv file dump.

I find that dumping the trial balance into a csv and doing your reports in a spreadsheet let's you handle situations like
below easily.  You can automate most of it with macros.

As far as numbering goes, it's a good idea to leave yourself room for the future.

You can multiply your acct numbers by 10 with (Dieter's tip):

update chart set accno = accno * 10;

Good luck.
Steve

Peter Dabrowski wrote:

>
> I would like to have them called in Balance sheet and other reports.
> I've got other complications.
> I follow recomended by polish laws account structures. COA was easy to setup. Problems starting with Balance Sheet report.
> For example, say accounts in group 3000
> have to be shown on the beginning of report before accounts group 1000.
> It would be a chance in GL reports to select(code in the tamplate)certain groups of accounts to appear in chosen place?
> Peter
>
> ----- Original Message -----
> From: Dieter Simader <dsi...@sq...>
> Date: Fri, 15 Mar 2002 09:46:49 -0700 (MST)
> To: Alexander Govoruschenko <ga...@fo...>
> Subject: Re: Is it possible to make subaccounts in chart of accounts ?
>
> > Accounts are ordered by account number. This is a number. To simulate sub
> > accounts enter accounts this way.
> >
> > 100010000   bank accounts
> > 100010100   bank west
> > 100010110   checking
> > 100010120   savings
> > 100010200   bank east
> > 100010210   checking
> > 100010220   savings
> >
> > I'll be adding an account range report on the GL reports. This is about
> > the same as subaccount report sans totals.
> >
> >
> > 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, 14 Mar 2002, Alexander Govoruschenko wrote:
> >
> > > Is it possible to make subj ?
> > > NOT accounts under headers, real subaccounts.
> > >
> >
> >
> >
>
> --
>
> _______________________________________________
> Sign-up for your own FREE Personalized E-mail at Mail.com
> http://www.mail.com/?sr=signup
>
> Travelocity.com is giving away two million travel miles.
> http://ad.doubleclick.net/clk;3969773;6991039;g?http://svc.travelocity.com/promos/millionmiles_main/0,,TRAVELOCITY,00.html

Re: Is it possible to make subaccounts in chart of accounts ?

[Peter D. <mer...@ma...>]

Hi Dieter'
Excelent.
My accounts are stractured in this way.
Do you recon I shuld put more digits.
below is example of my structure.
3000 (this is my header account)
 3100
  3110
  3120
 3200
  3210
   3211
   3212
  3220
   3221
   3222
   3223 etc
I would like to have them called in Balance sheet and other reports.
I've got other complications.
I follow recomended by polish laws account structures. COA was easy to setup. Problems starting with Balance Sheet report.
For example, say accounts in group 3000
have to be shown on the beginning of report before accounts group 1000.
It would be a chance in GL reports to select(code in the tamplate)certain groups of accounts to appear in chosen place?
Peter

----- Original Message -----
From: Dieter Simader <dsi...@sq...>
Date: Fri, 15 Mar 2002 09:46:49 -0700 (MST) 
To: Alexander Govoruschenko <ga...@fo...>
Subject: Re: Is it possible to make subaccounts in chart of accounts ?


> Accounts are ordered by account number. This is a number. To simulate sub
> accounts enter accounts this way.
> 
> 100010000   bank accounts
> 100010100   bank west
> 100010110   checking
> 100010120   savings
> 100010200   bank east
> 100010210   checking
> 100010220   savings
> 
> I'll be adding an account range report on the GL reports. This is about
> the same as subaccount report sans totals.
> 
> 
> 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, 14 Mar 2002, Alexander Govoruschenko wrote:
> 
> > Is it possible to make subj ?
> > NOT accounts under headers, real subaccounts.
> > 
> 
> 
> 

-- 

_______________________________________________
Sign-up for your own FREE Personalized E-mail at Mail.com
http://www.mail.com/?sr=signup

Travelocity.com is giving away two million travel miles.
http://ad.doubleclick.net/clk;3969773;6991039;g?http://svc.travelocity.com/promos/millionmiles_main/0,,TRAVELOCITY,00.html

Re: Is it possible to make subaccounts in chart of accounts ?

[Rob R. <ri...@at...>]

On Thu, 14 Mar 2002, Alexander Govoruschenko wrote:

> Is it possible to make subj ?
> NOT accounts under headers, real subaccounts.

If it is a subaccount it can't be a GL account.

Accounts that are similar are usually consecutive
in the chart, and are often summarized as one
item in balance sheet reports and such.

Commonly, there is a GL account for every
bank account, but they are often reported
together as "Cash".  

rob                     Live the dream.

Re: Is it possible to make subaccounts in chart of accounts ?

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

Accounts are ordered by account number. This is a number. To simulate sub
accounts enter accounts this way.

100010000   bank accounts
100010100   bank west
100010110   checking
100010120   savings
100010200   bank east
100010210   checking
100010220   savings

I'll be adding an account range report on the GL reports. This is about
the same as subaccount report sans totals.


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, 14 Mar 2002, Alexander Govoruschenko wrote:

> Is it possible to make subj ?
> NOT accounts under headers, real subaccounts.
> 

Re: Is it possible to make subaccounts in chart of accounts ?

[Peter D. <mer...@ma...>]

It wasn't very productive adwise.
Peter
----- Original Message -----
From: Nique Naque <ne...@ta...>
Date: Fri, 15 Mar 2002 22:42:15 +1100 
To: "Peter Dabrowski" <mer...@ma...>
Subject: Re: Is it possible to make subaccounts in chart of accounts ?


> On Fri, 15 Mar 2002, you wrote:
> > I don't think so. I've got the same problem.
> > Maybe somebody got some ideas on this subject.
> > Peter
> > ----- Original Message -----
> > From: Alexander Govoruschenko <ga...@fo...>
> > Date: Thu, 14 Mar 2002 18:52:57 +0200
> > To: sql...@li...
> > Subject: Is it possible to make subaccounts in chart of accounts ?
> >
> > > Is it possible to make subj ?
> > > NOT accounts under headers, real subaccounts.
> > > --
> > > WBR, GAV.
> 
> 
> Anything is possible - you just have to have the will to make it happen!
> 
> Nicholas Tomlin
> 
> 

-- 

_______________________________________________
Sign-up for your own FREE Personalized E-mail at Mail.com
http://www.mail.com/?sr=signup

Travelocity.com is giving away two million travel miles.
http://ad.doubleclick.net/clk;3969773;6991039;g?http://svc.travelocity.com/promos/millionmiles_main/0,,TRAVELOCITY,00.html

Re: Is it possible to make subaccounts in chart of accounts ?

[Nique N. <ne...@ta...>]

On Fri, 15 Mar 2002, you wrote:
> I don't think so. I've got the same problem.
> Maybe somebody got some ideas on this subject.
> Peter
> ----- Original Message -----
> From: Alexander Govoruschenko <ga...@fo...>
> Date: Thu, 14 Mar 2002 18:52:57 +0200
> To: sql...@li...
> Subject: Is it possible to make subaccounts in chart of accounts ?
>
> > Is it possible to make subj ?
> > NOT accounts under headers, real subaccounts.
> > --
> > WBR, GAV.


Anything is possible - you just have to have the will to make it happen!

Nicholas Tomlin

Re: Is it possible to make subaccounts in chart of accounts ?

[Peter D. <mer...@ma...>]

I don't think so. I've got the same problem.
Maybe somebody got some ideas on this subject.
Peter
----- Original Message -----
From: Alexander Govoruschenko <ga...@fo...>
Date: Thu, 14 Mar 2002 18:52:57 +0200 
To: sql...@li...
Subject: Is it possible to make subaccounts in chart of accounts ?


> Is it possible to make subj ?
> NOT accounts under headers, real subaccounts.
> -- 
> WBR, GAV.
> 
> 

-- 

_______________________________________________
Sign-up for your own FREE Personalized E-mail at Mail.com
http://www.mail.com/?sr=signup

Travelocity.com is giving away two million travel miles.
http://ad.doubleclick.net/clk;3969773;6991039;g?http://svc.travelocity.com/promos/millionmiles_main/0,,TRAVELOCITY,00.html

Is it possible to make subaccounts in chart of accounts ?

[Alexander G. <ga...@fo...>]

Is it possible to make subj ?
NOT accounts under headers, real subaccounts.
-- 
WBR, GAV.

Re: SQL-Ledger for a legal office

[Nique N. <ne...@ta...>]

On Thu, 14 Mar 2002, you wrote:

> > I'm a lawyer from Australia and I run my office entirely on open source
> software.  Well, almost.  The last package that I am using that is
> proprietary is Quickbooks Pro, for accounting.  I am wanting to make the
> move to SQL-Ledger.  However, there are some apparent omissions from
> SQL-Ledger that will make the move difficult:
>
> * It is imperative that separate matters or jobs be defined for each
>   client.  The only way to accomodate this would be either to record an
>   "order" for each matter (but this is not really acceptable, because we
>   need to send out multiple bills on a single matter), or to record each
>   new matter as a separate client (but this is not acceptable, because
>   we need to then re-key all the client details for each matter they
>   open).
>
> * Lawyers record their time in 6 minute units.  We need some way to
>   integrate a time tracking program (eg. gtt) into SQL-Ledger so that we
>   can import the time entries directly into an invoice, the way that
>   Quickbooks Pro does with its timer application.
>
> There are others, but these are the main ones.  Does anyone have any
> workarounds for this functionality, or do I just have to wait, or write
> a patch?

Jeremy,

I'm currently working on translating data out of an MYOB system to sql 
ledger, so far I've managed to move a few of the tables with some problems, 
you could find this to be your biggest head ache, but there are always drugs 
to fix that problem...

It may be quicker to write a patch for this, if you come up with one I would 
dearly like to know.. because if you don't discover one or do it yourself 
then I'll be onto it soon, as soon as I learn perl, postgres, etc, etc...

Regards,

Nicholas Tomlin.

Re: Latex error

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

Salve Matteo

Thank you, your hint help me a lot.

Without underscore the invoices are printed. Besides the underscore, 
there are some other weaknesses to take into account when printing, one 
of them seems to be tax... I'll prepare a list with the points related 
to printing.

Ciao

Matteo Centonza wrote:

>Hi Markus,
>
>
>having examined your log file, it seems that a first error resides on the 
>fact that you have used a name (H_KomS) with an underscore that TeX considers
>a special mathematical character (used to write subscripts) and so 
>complains for missing $ (the math switching character).
>