sql-ledger-users

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 

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

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

[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, 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