sql-ledger-users — SQL-Ledger users

Problem with adding parts after I imported part data

[Chris K. <kac...@ho...>]

What I did:
I had to put in about 100 parts.  Instead of entering each one through the
gui, I tested a few and found that the tables affected were parts, partstax,
and makemodel.  I then dummied up a spreadsheet for each of these tables
with ids and imported them into the postgres tables (pgaccess is really
cool).

What Happened:
This worked fine until I tried to add in a new part via the web interface.
When I did this, the new part showed up twice in the parts table (same id
number which confused me because I thought this was a unique field).  Also,
it over wrote an id number in the parts table from one of the parts I
imported.

What may be happening:
Does SQL-Ledger keep a counter somewhere of the next available id number.
If so, where is the counter so I can update it.  Of perhaps there is a
better way of importing a lot of data into SQL-Ledger.

Thanks in advance for your help.  I really like the program, just do not
want to do a bunch of hand entry.

cheers,

ski

sALudos(patches)

[h <h...@gr...>]

Hi,

  Here are three small patches to show credit_limit and balance on the 
invoice and order add forms.  It doesn't work on the "add vendor invoice", 
because I just modified the get_customer function.  I also include a tgz 
with locales for Mexico. 

  In many countries including Mexico, Spain, Venezuela there is a "Tax payer 
registry", and in Mexico is obligatory to print this registry called 
RFC(Registro federal de contribuyentes) in the invoices. At the moment I'm 
using the last address field for this purpose, but I also have the problem 
that sometimes the addresses are very long, so I suggest the addition of 
this field to the db tables customer and vendor. 

 In Mexico as many other countrys we requiere to print the invoice total 
amount with letters as $546.00 (Five hundred and forty five dlls.), I solve 
this problem using the package ES::Lingua::Numeros. I don't know If the 
solution is to make locale-spell patches, or include number-spell packages 
for all the languages that need this feature? 

 I think that including number-spell packages would be a solution and that 
could be used to create also checks, and many other documents. 

sALudos 

Re: can't get background to print

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

----- Original Message ----- 
From: "lee johnson" <le...@im...>


[...]
> secondly if it has nothing to do with sql-ledger then I guess the person
> that told me about editing css/sql-ledger.css was mistaken go fig..


I think so, using that you change the background,
but printing is another thing...

> and I do not use IE,. so I use netscape 4.78 and yes I've looked
> everywhere and see nowhere to set in netscape the ability to print
> background..I 'thought' sql-ledger was utter customizable according to
> docs..totally customizeable with html to make invoices look just like
> you want...


printing is a browser thing, in IE I have a checkbox for
printing the background of pages or not.
what about if you try mozilla ?

/sergio

Re: can't get background to print

[Cesar V. <da...@et...>]

> secondly if it has nothing to do with sql-ledger then I
> guess the person that told me about editing
> css/sql-ledger.css was mistaken go fig..
> and I do not use IE,. so I use netscape 4.78 and yes I've
> looked everywhere and see nowhere to set in netscape the
> ability to print background..I 'thought' sql-ledger was
> utter customizable according to docs..totally
> customizeable with html to make invoices look just like
> you want...

Please, keep the tone on this thread. We are all here to=20
help each other.

First, the guy who told you how to change css was allright,=20
if you want that the backgroung appears in all the screen=20
that use the class body.

If you want to use a special body class to invoices, define=20
in css and change your invoice templates, or change=20
directly your invoice templates: In any measure, this=20
"customization" it is just plain HTML, nothing to do with=20
the primary purpose of SQL-Ledger (search for HTML tutorial=20
in the Internet).=20

Second, if you can _see_ the background image in your=20
Netscape, it will be printed, can you see it in the first=20
place?



--=20
C=E9sar Villanueva
SuSE Linux C.A.
"First they ignore you. Then they laugh at you.
Then they fight you. Then you win." [Gandhi]=20

Re: can't get background to print

[lee j. <le...@im...>]

On Sat, 2002-02-02 at 18:55, Sergio A. Kessler wrote:
> printing has nothing to do with sql-ledger
> actually it's your browser's bussiness.
> (if you are using IE look at tools/options/advanced for printing the
> background)
> 
> and PLEASE, do not send html mail to mailing lists...

first off it was not my intent 'to' send html email..if something snuck
in it was an accidental paste nothing more :(..I have html send off by
default..:)

secondly if it has nothing to do with sql-ledger then I guess the person
that told me about editing css/sql-ledger.css was mistaken go fig..

and I do not use IE,. so I use netscape 4.78 and yes I've looked
everywhere and see nowhere to set in netscape the ability to print
background..I 'thought' sql-ledger was utter customizable according to
docs..totally customizeable with html to make invoices look just like
you want...

thx
lee
-=====

Re: can't get background to print

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

printing has nothing to do with sql-ledger
actually it's your browser's bussiness.
(if you are using IE look at tools/options/advanced for printing the
background)

and PLEASE, do not send html mail to mailing lists...

/sergio

----- Original Message -----
From: "lee johnson" le...@im...


> I altered the cvs/sql-ledger.cvs to include the background-image:
> (pathto it);} but I still am not getting the background to print...

can't get background to print

[lee j. <le...@im...>]

I altered the cvs/sql-ledger.cvs to include the background-image:
(pathto it);} but I still am not getting the background to print... 


thx 
lee 
-=== 

Re: sALudos(PATCH)

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

yes, please.
ideally all the patches should be posted here,
maybe someone can spot a bug or clean up the code.

/sergio

----- Original Message -----
From: "h" <h...@gr...>


> Hi,
>
>  I have some minor changes to to show the (balance = ar.amount - ar.paid)
at
> the add invoice form and add form. Do I post the patch to the list?
>
> sALudos
>
> Alberto Ladron

RE: login.pl problems

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

If you have the Pg and Oracle driver installed both show on screen. You
can then fill in the data for the appropriate driver. Leaving the
checkmark off forces you do check one of them.

I added a quick error check if none of the drivers are checked. This will
be in the next patch release.


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

On Fri, 1 Feb 2002, Moseley, Ted wrote:

> I had seen the same problem when I went to configure SQL-LEDGER for the
> first time.  It took me a while to figure out what it was talking about.
> Since PostGres is the database of first resort wouldn't it make sense to
> make that default setting to on? Or is there another reason why it is
> not set.  
> 
> Since I am new to using this program and don't have any historical
> perspective, much less a developer perspective, it may be something else
> that I am not aware of.
> 
> Ted Moseleuy
> 
> -----Original Message-----
> From: sql...@li...
> [mailto:sql...@li...]On Behalf Of
> Kenneth Gonsalves
> Sent: Friday, February 01, 2002 8:14 AM
> To: Rodrigo Roman; sql...@li...
> Subject: Re: login.pl problems
> 
> 
> thanks a lot - it worked. i had entered the data in the user
> configuration 
> page, but had not noticed that the pg driver option was not ticked.
> 
> (first time i have ever come across anyone from Argentina! i am from
> india)
> 
> regards
> 
> kg
> On Friday 01 February 2002 04:45 pm, you wrote:
> > The user you are trying to connect with dowsn't have driver
> configured...
> > Log in as admin and configure pg driver in the user configuration
> page, you
> > must also put the db name etc..
> >
> > -----Mensaje original-----
> > De: Kenneth Gonsalves [mailto:la...@th...]
> > Enviado el: Viernes, 01 de Febrero de 2002 02:56 a.m.
> > Para: sql...@li...
> > Asunto: login.pl problems
> >
> >
> > hi
> > have set up sql-ledger upto admin and create user. when i try to log
> in as
> > the user i get the following error message:
> >
> > Can't connect(  ), no database driver specified and DBI_DSN env var
> not set
> > at SL/User.pm line 101
> > Compilation failed in require at /usr/local/www/sql-ledger/login.pl
> line
> > 85. [Thu Jan 31 12:22:27 2002] [error] [client 192.168.0.1] Premature
> end
> > of script headers: /usr/local/www/sql-ledger/login.pl
> >
> > please help out
> >
> > regards
> >
> > kg
> 
> 

Re: background in invoice

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

On 1 Feb 2002, lee johnson wrote:

> okay how do I get a background image to show up in printed invoice..i
> have it properly setup in invoice template but its a no show :)

A neat way of always have a background image is by changing
css/sql-ledger.css from

  body { background-color: #ffffff; }

to

  body { background-color: #ffffff;
         background-image: url(../sql-ledger.gif); }

and (obviously) change the path to some picture of your own - the path is
relative to the css file, not the html.

Have a look at http://dr.jones.dk/info/ for inspiration on how to make a
big logo with small binary size (my logo is only 6k!)

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

background in invoice

[lee j. <le...@im...>]

okay how do I get a background image to show up in printed invoice..i
have it properly setup in invoice template but its a no show :)

thx
lee
-====

sALudos(PATCH)

[h <h...@gr...>]

Hi,

 I have some minor changes to to show the (balance = ar.amount - ar.paid) at 
the add invoice form and add form. Do I post the patch to the list? 

sALudos 

Alberto Ladron

RE: login.pl problems

[Moseley, T. <tmo...@ds...>]

I had seen the same problem when I went to configure SQL-LEDGER for the
first time.  It took me a while to figure out what it was talking about.
Since PostGres is the database of first resort wouldn't it make sense to
make that default setting to on? Or is there another reason why it is
not set. =20

Since I am new to using this program and don't have any historical
perspective, much less a developer perspective, it may be something else
that I am not aware of.

Ted Moseleuy

-----Original Message-----
From: sql...@li...
[mailto:sql...@li...]On Behalf Of
Kenneth Gonsalves
Sent: Friday, February 01, 2002 8:14 AM
To: Rodrigo Roman; sql...@li...
Subject: Re: login.pl problems


thanks a lot - it worked. i had entered the data in the user
configuration=20
page, but had not noticed that the pg driver option was not ticked.

(first time i have ever come across anyone from Argentina! i am from
india)

regards

kg
On Friday 01 February 2002 04:45 pm, you wrote:
> The user you are trying to connect with dowsn't have driver
configured...
> Log in as admin and configure pg driver in the user configuration
page, you
> must also put the db name etc..
>
> -----Mensaje original-----
> De: Kenneth Gonsalves [mailto:la...@th...]
> Enviado el: Viernes, 01 de Febrero de 2002 02:56 a.m.
> Para: sql...@li...
> Asunto: login.pl problems
>
>
> hi
> have set up sql-ledger upto admin and create user. when i try to log
in as
> the user i get the following error message:
>
> Can't connect(  ), no database driver specified and DBI_DSN env var
not set
> at SL/User.pm line 101
> Compilation failed in require at /usr/local/www/sql-ledger/login.pl
line
> 85. [Thu Jan 31 12:22:27 2002] [error] [client 192.168.0.1] Premature
end
> of script headers: /usr/local/www/sql-ledger/login.pl
>
> please help out
>
> regards
>
> kg

Re: SID & Oracle

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

On Fri, 1 Feb 2002, Cesar Villanueva wrote:

> Hi All
>=20
> Just a question, what is the meaning of the global variable=20
> $sid with a value of T80509 defines in sql-ledger.conf and=20
> related to Oracle.
>=20
> Thanks in Advance

> C=E9sar Villanueva

Hello Cesar!

We are still debugging this port.  If you want to help out, join in!=20
A SID (more properly, an $ORACLE_SID) is an Oracle System ID
every box has one and it tags which set of databases and tablespaces
go where.  It is a somewhat clumsy mechanism but it's what we
have to work with.

On my box I do this:

echo $ORACLE_SID

And I get back: oralin
which is what I set it to on installation (way back when.)

> SuSE Linux C.A.

I like SuSE alot - and I am a fierce (albeit non-violent!) advocate
of Gandhi's experiments in truth.

Lemme know if I can be of assistance to you, eh?  ;-)

> "First they ignore you. Then they laugh at you.
> Then they fight you. Then you win." [Gandhi]=20
>=20

------------------------------------------------------------------------
Thomas Good                                         to...@ad...
Programmer/Analyst                                  th...@sq...
Residential Services, Behavioral Health Services
Saint Vincent Catholic Medical Centers                                     =
=20
--
SQL Clinic - An Open Source Clinical Record            www.sqlclinic.net
------------------------------------------------------------------------
=20

Re: login.pl problems

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

thanks a lot - it worked. i had entered the data in the user configuration 
page, but had not noticed that the pg driver option was not ticked.

(first time i have ever come across anyone from Argentina! i am from india)

regards

kg
On Friday 01 February 2002 04:45 pm, you wrote:
> The user you are trying to connect with dowsn't have driver configured...
> Log in as admin and configure pg driver in the user configuration page, you
> must also put the db name etc..
>
> -----Mensaje original-----
> De: Kenneth Gonsalves [mailto:la...@th...]
> Enviado el: Viernes, 01 de Febrero de 2002 02:56 a.m.
> Para: sql...@li...
> Asunto: login.pl problems
>
>
> hi
> have set up sql-ledger upto admin and create user. when i try to log in as
> the user i get the following error message:
>
> Can't connect(  ), no database driver specified and DBI_DSN env var not set
> at SL/User.pm line 101
> Compilation failed in require at /usr/local/www/sql-ledger/login.pl line
> 85. [Thu Jan 31 12:22:27 2002] [error] [client 192.168.0.1] Premature end
> of script headers: /usr/local/www/sql-ledger/login.pl
>
> please help out
>
> regards
>
> kg

SID & Oracle

[Cesar V. <da...@et...>]

Hi All

Just a question, what is the meaning of the global variable=20
$sid with a value of T80509 defines in sql-ledger.conf and=20
related to Oracle.

Thanks in Advance
--=20
C=E9sar Villanueva
SuSE Linux C.A.
"First they ignore you. Then they laugh at you.
Then they fight you. Then you win." [Gandhi]=20

Problem with negative invoices

[Luca V. <lu...@ye...>]

Hi,

I've seen that in a lot of countries
is present something like our 'Nota di Credito'.
It is a negative invoice that 'clean' the
invoice of a customer.

I use negative invoices for our 'Nota di Credito'.

I have two problems:

1. The inventory is not decreased unless I put
a negative quantity of items with a positive
product price. (This is not actually a problem,
it is just not so intuitive)

2. When I see the AR aging report I see two
credits: one negative and the other positive.
It is not true, the negative one should
'clean' the positive one and I should see no
credits instead of two.

Luca

Re: sALudos, nota de credito and letter of credit

[Paul S. <zi...@su...>]

Please do not mix the terms:

"nota de credito" translates to "credit note" and is actually an "I owe you"

"Letter of Credit" which is the payment term L/C, normally used with the 
additions of "confirmed" and "irrevocable". Letter of Credits are used 
mainly in foreign trade when the seller wants to be sure to obtain the 
payment for the goods or services delivered. A synonym for L/C is 
rembourse.
When the payment term L/C is used as payment term the proceedings are 
basicly the  following:
- The buyer approaches his bank
- the bank grants a credit to the buyer and informs the bank of the 
seller that such a credit has been granted (confirmed meaning informing 
the seller's bank and  irrevocable meaning basicly that the buyer cannot 
cancel the transaction or credit)
- the seller's bank informs the seller that a L/C has been opened
- the seller presents proof that the terms of sales have been met 
(usually by handing over shipping documents and change of title 
documents, i.e ownership docs)
- seller's bank once satisfied that tems of sale have been met releases 
the money to the seller
- seller's bank sends shipping and ownership documents to buyer's bank
- buyer's bank hands over documents to buyer

As noticed from above L/Cs are banking instruments, pretty complicated 
and thus expensive.


Paul

login.pl problems

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

hi
have set up sql-ledger upto admin and create user. when i try to log in as 
the user i get the following error message:

Can't connect(  ), no database driver specified and DBI_DSN env var not set 
at SL/User.pm line 101
Compilation failed in require at /usr/local/www/sql-ledger/login.pl line 85.
[Thu Jan 31 12:22:27 2002] [error] [client 192.168.0.1] Premature end of 
script headers: /usr/local/www/sql-ledger/login.pl

please help out

regards

kg

Re: sALudos

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

Hola,

On Thu, 2002-01-31 at 09:13, Cesar Villanueva wrote:
> El Jue 31 Ene 2002 07:36, John Christian Stoddart escribi=F3:
> > John Christian Stoddart
>=20
> Hola Todos
>=20
> Con relaci=F3n a este mail del amigo mexicano me gustar=EDa=20
> peguntar algo: =BFEs Dieter el =FAnico desarrollador activo de=20
> SQL-Ledger?

Hay una lista de desarrolladores y contribuyentes en=20
http://www.sql-ledger.org/misc/contributors.html

> =BFC=F3mo podemos participar los dem=E1s?

Puedes instalar el sistema y familiarizarte con =E9l como paso previo.
Quiero decir, examinar los archivos y la forma en que est=E1 estructurado
el sistema en general

Si tienes experiencia con perl y DBI puedes contribuir parches, c=F3digo,
lo que sea. Los desarrolladores de sql-ledger en general son muy
abiertos y hay varios proyectos en proceso, entre los cuales hay un
programa de n=F3mina, punto de venta, etc.

Tambi=E9n podr=EDa ser que al darle uso, probablemente quisieras hacer cosa=
s
de una manera u otra, por lo que podr=EDas hacer sugerencias, que, de ser
practicables podr=EDan implementarse en una versi=F3n futura.

En la p=E1gina http://www.sql-ledger.org/misc/ahead.html hay una forma que
puedes llenar en caso de requerir alguna caracter=EDstica en particular.

> Te lo digo=20
> porque, por ejemplo, en el registro de clientes y=20
> proveedores en Venezuela (estoy en Caracas igual que J.=20
> Stoddart) es interesante colocar el RIF (Registro de=20
> Informaci=F3n Fiscal) que identifica para efectos de=20
> impuestos y, aunque hay un "business number" s=F3lo aparece=20
> en la creaci=F3n del usuario. (=BFC=F3mo haces aqu=ED John=20
> Stoddart)?

Podr=EDas agregarle otro(s) campo(s) a la base de datos (ver respuesta
anterior al respecto en la lista) si tienes esp=EDritu de aventura. Luego
tienes que incorporarlos a la pantalla.

Puedes usar la primera l=EDnea de la direcci=F3n para informaci=F3n de RIF
(y/o NIT, si quieres). En el futuro pr=F3ximo le pedir=E9 a Dieter si puede
incorporarlo de una manera m=E1s formal (y gen=E9rica), ya que muchos pa=ED=
ses
utilizan este tipo de identificador para fines fiscales.

> =BFEst=E1 documentada la API de SQL-Ledger?

Dieter ha publicado recientemente en
http://www.sql-ledger.org/misc/api.html una (breve) descripci=F3n del API
para la incorporaci=F3n en forma standard de caracter=EDsticas adicionales.

> =BFSu arquitectura,=20
> es decir, c=F3mo se relacionan sus m=F3dulos?=20

Te sugiero que tomes algo de tiempo para visitar el sitio web, el cual
suministra bastante informaci=F3n. Existe un FAQ en=20
http://www.sql-ledger.org/misc/faq.html d=F3nde recientemente un usuario
contribuy=F3 instrucciones para la instalaci=F3n del sql-ledger en una
distribuci=F3n SuSE.

Saludos cordiales,




John Christian Stoddart
Caracas - Venezuela

Re: sALudos

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

On Thursday 31 January 2002 19:39, Sergio A. Kessler wrote:
> they are called "letters of credit" and are used
> very much over here...

I thought sALudos was talking about credit notes, rather than letters of 
credit.

His modifications sound very good, though.  I hope we can get his modified 
scripts.

--
richard 

Re: sALudos

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

they are called "letters of credit" and are used
very much over here...
btw, h, your additions seems good...

/sergio

----- Original Message -----
From: "Luca Venturini" <lu...@ye...>


> Hi,
>
> I've seen your modifications.
> In Italy we use the 'Nota di Credito' too.
>
> At the moment I generate a negative invoice
> for each 'Nota di Credito'. Do you do something
> different?
>
> Luca
>
>
> h wrote:
> >
> > Hi all,
> >
> >  I'm Alberto Ladron from Mexico and I'm working with sql-leder, I think
that
> > is a great software but It needs hard work.
> >
> >   I have been programming on some modifications to the software, but
I'll
> > like to join the official team, I think my modifications can be usefull
to
> > many people.
> >
> >  Here I list some of my modifications:
> >
> >  I added the tags %speellinvtotal% and %spellordtotal% to the invoice
and
> > order templates and to the .pl and .pl. Eg. 576.98 => (SON QUINIENTOS
> > SETENTA Y SEIS PESOS 98/100 m.n.). I'm using the Lingua::ES package.
> >
> >  On the create invoice and create order screens when you select a client
and
> > update the page you can see his credit limit, (total - paid) and
> > balance(credit_limit - total - paid).
> >
> >   On the inventory report listing you can choose  the flags to see the
> > products last cost, price, price + tax.
> >
> >   On the AP and AR reports I added the columns balance(total-paid).
> >
> >   I made more modifications, but now I don't remember all of them.
> >
> >   Sometimes I don't know the right term in english for example I don't
know
> > if the term spellinvtotal is clear or not, if (credit_limit - total -
paid)
> > is balance, etc.
> >
> >   I'll like to work in two extra modules: "nota de cargo" and "nota
> > credito".
> >
> > "nota de cargo".- When the customer doesn't pay on time or creates any
> > situation that represents a charge for him you create a "nota de cargo".
> > "nota de cargo" is part of your AR.
> >
> > "nota de credito".- Supose that you sell something and the next day the
> > customer returns the product and he asks for he's money, you answer him
that
> > you can't give his money back but you can give him a "nota de credito"
and
> > he can use this as money in his futures buys.
> > "nota de credito" is part of your AP.
> >
> >   I also a have doubt, when you convert an order into invoice, the
invoice
> > can include the contents of just one order? In Mexico is a very common
> > practice to make orders all day long, and a the end of the day create an
> > invoice that includes the sells of the whole day.
> >
> > sALudos
>
>

Re: sALudos

[Luca V. <lu...@ye...>]

Hi,

I've seen your modifications.
In Italy we use the 'Nota di Credito' too.

At the moment I generate a negative invoice
for each 'Nota di Credito'. Do you do something
different?

Luca


h wrote:
> 
> Hi all,
> 
>  I'm Alberto Ladron from Mexico and I'm working with sql-leder, I think that
> is a great software but It needs hard work.
> 
>   I have been programming on some modifications to the software, but I'll
> like to join the official team, I think my modifications can be usefull to
> many people.
> 
>  Here I list some of my modifications:
> 
>  I added the tags %speellinvtotal% and %spellordtotal% to the invoice and
> order templates and to the .pl and .pl. Eg. 576.98 => (SON QUINIENTOS
> SETENTA Y SEIS PESOS 98/100 m.n.). I'm using the Lingua::ES package.
> 
>  On the create invoice and create order screens when you select a client and
> update the page you can see his credit limit, (total - paid) and
> balance(credit_limit - total - paid).
> 
>   On the inventory report listing you can choose  the flags to see the
> products last cost, price, price + tax.
> 
>   On the AP and AR reports I added the columns balance(total-paid).
> 
>   I made more modifications, but now I don't remember all of them.
> 
>   Sometimes I don't know the right term in english for example I don't know
> if the term spellinvtotal is clear or not, if (credit_limit - total - paid)
> is balance, etc.
> 
>   I'll like to work in two extra modules: "nota de cargo" and "nota
> credito".
> 
> "nota de cargo".- When the customer doesn't pay on time or creates any
> situation that represents a charge for him you create a "nota de cargo".
> "nota de cargo" is part of your AR.
> 
> "nota de credito".- Supose that you sell something and the next day the
> customer returns the product and he asks for he's money, you answer him that
> you can't give his money back but you can give him a "nota de credito" and
> he can use this as money in his futures buys.
> "nota de credito" is part of your AP.
> 
>   I also a have doubt, when you convert an order into invoice, the invoice
> can include the contents of just one order? In Mexico is a very common
> practice to make orders all day long, and a the end of the day create an
> invoice that includes the sells of the whole day.
> 
> sALudos

sALudos

[h <h...@gr...>]

Hi all,

 I'm Alberto Ladron from Mexico and I'm working with sql-leder, I think that 
is a great software but It needs hard work. 

  I have been programming on some modifications to the software, but I'll 
like to join the official team, I think my modifications can be usefull to 
many people. 

 Here I list some of my modifications: 

 I added the tags %speellinvtotal% and %spellordtotal% to the invoice and 
order templates and to the .pl and .pl. Eg. 576.98 => (SON QUINIENTOS 
SETENTA Y SEIS PESOS 98/100 m.n.). I'm using the Lingua::ES package. 

 On the create invoice and create order screens when you select a client and 
update the page you can see his credit limit, (total - paid) and 
balance(credit_limit - total - paid). 

  On the inventory report listing you can choose  the flags to see the 
products last cost, price, price + tax. 

  On the AP and AR reports I added the columns balance(total-paid). 

  I made more modifications, but now I don't remember all of them. 

  Sometimes I don't know the right term in english for example I don't know 
if the term spellinvtotal is clear or not, if (credit_limit - total - paid) 
is balance, etc. 

  I'll like to work in two extra modules: "nota de cargo" and "nota 
credito". 

"nota de cargo".- When the customer doesn't pay on time or creates any 
situation that represents a charge for him you create a "nota de cargo".
"nota de cargo" is part of your AR. 

"nota de credito".- Supose that you sell something and the next day the 
customer returns the product and he asks for he's money, you answer him that 
you can't give his money back but you can give him a "nota de credito" and 
he can use this as money in his futures buys.
"nota de credito" is part of your AP. 

  I also a have doubt, when you convert an order into invoice, the invoice 
can include the contents of just one order? In Mexico is a very common 
practice to make orders all day long, and a the end of the day create an 
invoice that includes the sells of the whole day. 

sALudos 

About importing data, command line and cron jobs

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

First of all, SQL-Ledger can be driven from the command line, it is not
what appears to be just a web application. You can basically run every
function from posting invoices to searching or importing data from a
command prompt.

i.e to display the search screen from the ct module.

./ct.pl "login=handle&path=bin/mozilla&password=encrypted&action=search&db=customer"

This displays the search screen for customers in html format on screen.
From there on it is up to you what you want to do with the output. You can
pipe it through another application to perhaps convert the output to pdf
or send it to a printer.

Scheduled transactions, say sending out monthly invoices, can be produced
with a cronjob using the same concept.


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