sql-ledger-users — SQL-Ledger users

Credit Note(Patch)

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

Hi,

 I've made some minor patches to add "Credit Note" to the AP Menu, It needs 
more work but I'll like you to check it in order to know if I'm doing it 
right. 

sALudos 

Alberto Ladron 

Re: Commerce ID

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

IMO your solution is too complicated for what is trying
to resolve and complicate the life of the programmer,
while the dieter's solution complicate the life of the
end user (and difficult to validate).

I second the motion of root, just add some "custom"
fields and everyone happy, a simple solution that
pass the KISS test.

if you *need* one of the custom fields to have non null
values you just add a constraint (or checks).
(as is the case for CUIT -tax number- for us)

another solution is to take advantage of pgsql dynamic
array field ("custom varchar(99)[]") and with one field
you can have all the custom fields you want.

but I prefer the simpler solution that is to add
some "custom_n" fields.

/sergio

----- Original Message -----
From: "Jack William Bell" <ja...@sf...>


> Dieter, et al;
>
> I have been lurking on this list for a while, but this subject has such a
> simple answer that I am de-cloaking to provide it. (Apologies in advance
to
> non-programmers who might be overwhelmed by coder-speak.)
>
> Root has mentioned a version of the answer; simply provide some custom
> fields in the table which can mean different things for different users.
But
> there is an extension of this concept that would add 0 to N custom fields
to
> everything without changing the existing tables!
>
> Create a set of 'Custom Fields' tables. These would look like this:
>
> CustFieldsHeader
> ----------------
> ID
> DisplayName
> Description
> ParentTableName (value should be actual table name to avoid confusion)
> ValueType (Indicates how the value should be stored and retrived -
optional)
> FormHTML (Actual HTML to use in a form including the value - optional)
> ReportHTML (Actual HTML to use in a report including the value - optional)
>
> CustFieldsValue
> ---------------
> HeaderID (foreign key to CustFieldsHeader.ID)
> ParentOID (foreign key to 'OtherTable'.OID)
> TextValue (note that all values could be kept as text to simplify the
code)
> NumericValue
> DateValue
>
> For each table you want to add a custom value for, you create a 'header'
> record describing the custom value. Values added to the Value table would
> use the OID of the 'owner' record in the parent table as the foreign key
> (note that this might be PostreSQL specific).
>
> Now you simply modify the code for any form that allows custom values to
get
> the the appropriate CustFieldsHeader records and add the custom fields to
> the form. Same for any report. The values can be retrived in one of the
> following ways:
>   (1) Use a separate query for the CustFieldsValues based on an OID
returned
> from another query. (probably the simplest way to implement this)
>   (2) Modify a parent table query to also retrieve
> CustFieldsHeader.DisplayName and CustFieldsValue.TextValue (or whatever)
and
> treat them as key/value pairs. Note that this would require changing any
> code that loops through a recordset to look for a key change to know it
has
> 'actually' moved to the next record. (complex, but not too many changes to
> code)
>   (3) Create a query generator that reads the CustFieldsHeader records for
a
> particular parent table and then generates SQL query statements that
include
> custom fields. (complex, but something you can encapsulate into a
re-useable
> function, may require lots of changes to code)
>
> Admittedly this seems a little bit complex at first, and above I told you
> the answer was 'simple'. But if you look at this carefully you will see it
> has the advantage of being something you can add to any table without too
> much effort once the base work has been done. It also has the advantage of
> being hugely flexible -- with the ability to allow users to add their own
> custom fields to tables via a simple form. In the long run it really is
> quite simple. I have used variations on this scheme to create extremely
> flexible systems in the past and I know it works quite well.
>
> Of course you are probably wondering why I don't just do it? Mostly
because
> I need to do paying programming work right now -- anyone want to pay me
for
> this? If you do then you should also send a few shekels Dieter's way as
> well, for the excellent work he has done.
>
> Jack William Bell
>
> > -----Original Message-----
> > From: sql...@li...
> > [mailto:sql...@li...]On Behalf Of Dieter
> > Simader
> > Sent: Friday, February 08, 2002 8:12 AM
> > To: sql...@li...
> > Subject: Re: Commerce ID
> > customer specific information such as a tax number, commerce number can
be
> > recorded in the notes field. The notes you enter in the customer screen
> > are carried over when you create an invoice.
> >
> > 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, 8 Feb 2002, Paul Saris wrote:
> >
> > > In the EU the same thing is used, depending on country I have seen it
> > > been called VAT-number or community code.
> > >
> > > By law community code has to be printed on all invoices (and it is
> > > recommended to do it also on all trade related documents) from the
> > > invoicing party.
> > >
> > > In intra-EU trade printing of the purchasing party's community code
> > > makes it possible to invoice without VAT charged. Definitely this is a
> > > field which should be added to the customer and supplier tables
> > (as well
> > > as print-outs like quotations, order confirmations, invoices).
> > >
> > > Paul
>
>
>
>

Foreign Currency

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

Hi,
To transfer money from foreign currency accunt to current account I'm=20=

using GL transactions. Currently I just convert currency manually and=20=

transfer this value.Would be good to use foreign currency facility in GL=
=20
Transactions to.
AP and AR side of this working very well.
Peter D

RE: Commerce ID

[Jack W. B. <ja...@sf...>]

Dieter, et al;

I have been lurking on this list for a while, but this subject has such a
simple answer that I am de-cloaking to provide it. (Apologies in advance to
non-programmers who might be overwhelmed by coder-speak.)

Root has mentioned a version of the answer; simply provide some custom
fields in the table which can mean different things for different users. But
there is an extension of this concept that would add 0 to N custom fields to
everything without changing the existing tables!

Create a set of 'Custom Fields' tables. These would look like this:

CustFieldsHeader
----------------
ID
DisplayName
Description
ParentTableName (value should be actual table name to avoid confusion)
ValueType (Indicates how the value should be stored and retrived - optional)
FormHTML (Actual HTML to use in a form including the value - optional)
ReportHTML (Actual HTML to use in a report including the value - optional)

CustFieldsValue
---------------
HeaderID (foreign key to CustFieldsHeader.ID)
ParentOID (foreign key to 'OtherTable'.OID)
TextValue (note that all values could be kept as text to simplify the code)
NumericValue
DateValue

For each table you want to add a custom value for, you create a 'header'
record describing the custom value. Values added to the Value table would
use the OID of the 'owner' record in the parent table as the foreign key
(note that this might be PostreSQL specific).

Now you simply modify the code for any form that allows custom values to get
the the appropriate CustFieldsHeader records and add the custom fields to
the form. Same for any report. The values can be retrived in one of the
following ways:
  (1) Use a separate query for the CustFieldsValues based on an OID returned
from another query. (probably the simplest way to implement this)
  (2) Modify a parent table query to also retrieve
CustFieldsHeader.DisplayName and CustFieldsValue.TextValue (or whatever) and
treat them as key/value pairs. Note that this would require changing any
code that loops through a recordset to look for a key change to know it has
'actually' moved to the next record. (complex, but not too many changes to
code)
  (3) Create a query generator that reads the CustFieldsHeader records for a
particular parent table and then generates SQL query statements that include
custom fields. (complex, but something you can encapsulate into a re-useable
function, may require lots of changes to code)

Admittedly this seems a little bit complex at first, and above I told you
the answer was 'simple'. But if you look at this carefully you will see it
has the advantage of being something you can add to any table without too
much effort once the base work has been done. It also has the advantage of
being hugely flexible -- with the ability to allow users to add their own
custom fields to tables via a simple form. In the long run it really is
quite simple. I have used variations on this scheme to create extremely
flexible systems in the past and I know it works quite well.

Of course you are probably wondering why I don't just do it? Mostly because
I need to do paying programming work right now -- anyone want to pay me for
this? If you do then you should also send a few shekels Dieter's way as
well, for the excellent work he has done.

Jack William Bell

> -----Original Message-----
> From: sql...@li...
> [mailto:sql...@li...]On Behalf Of Dieter
> Simader
> Sent: Friday, February 08, 2002 8:12 AM
> To: sql...@li...
> Subject: Re: Commerce ID
> customer specific information such as a tax number, commerce number can be
> recorded in the notes field. The notes you enter in the customer screen
> are carried over when you create an invoice.
>
> 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, 8 Feb 2002, Paul Saris wrote:
>
> > In the EU the same thing is used, depending on country I have seen it
> > been called VAT-number or community code.
> >
> > By law community code has to be printed on all invoices (and it is
> > recommended to do it also on all trade related documents) from the
> > invoicing party.
> >
> > In intra-EU trade printing of the purchasing party's community code
> > makes it possible to invoice without VAT charged. Definitely this is a
> > field which should be added to the customer and supplier tables
> (as well
> > as print-outs like quotations, order confirmations, invoices).
> >
> > Paul

Bug Report

[Philip R. <p....@li...>]

Hello everyone,

I found two things I think are bugs:

I'm using SL 1.8.2 and Mozilla

1) AP module -> Add transaction
when entering a new transaction the fraction amount of the invoice is cut 
off after saving the entry.
e.g. 80.60 becomes 80.00

2) AP module -> Payments
when entering a payment SL does not use the local fraction divider but the 
us default.
e.g. in Germany we use a comma instead of a dot
when entering 80,60 it becomes 80.600,00

Does anybody have the same problems?

Any help is appreciated.

Ciao,
Philip


--
LINET Services
Linux im Intra- und InterNet

Rebenring 33                                    Tel.:   0531-280 191 71
38106 Braunschweig                              Fax:    0531-280 191 72

http://www.linet-services.de
mailto:in...@li...

Re: Commerce ID

[root <ro...@ma...>]

I'm not the biggest advocate of adding new fields to things for fun, but perhaps the easiest thing to do to accomodate this need as well as many other unforseen needs is to add for each invoice a few 'custom' fields that can be customized by the end user on his/her templates. i.e. custom1, custom2... then in this case you put on your templates Commerce ID: <%custom_1%> ...etc. 
This would meet this need and others we haven't even thought up yet.
But thats just my two cents ;)

Re: Commerce ID

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

customer specific information such as a tax number, commerce number can be
recorded in the notes field. The notes you enter in the customer screen
are carried over when you create an invoice.


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, 8 Feb 2002, Paul Saris wrote:

> In the EU the same thing is used, depending on country I have seen it 
> been called VAT-number or community code.
> 
> By law community code has to be printed on all invoices (and it is 
> recommended to do it also on all trade related documents) from the 
> invoicing party.
> 
> In intra-EU trade printing of the purchasing party's community code 
> makes it possible to invoice without VAT charged. Definitely this is a 
> field which should be added to the customer and supplier tables (as well 
> as print-outs like quotations, order confirmations, invoices).
> 
> Paul
> 
> 
> 
> 
> 

Re: Commerce ID

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

In the EU the same thing is used, depending on country I have seen it 
been called VAT-number or community code.

By law community code has to be printed on all invoices (and it is 
recommended to do it also on all trade related documents) from the 
invoicing party.

In intra-EU trade printing of the purchasing party's community code 
makes it possible to invoice without VAT charged. Definitely this is a 
field which should be added to the customer and supplier tables (as well 
as print-outs like quotations, order confirmations, invoices).

Paul

Patch(AR)

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

Hi all, 

 I've made a patch to print the clients debt in the AR report, this is debt 
= amount - paid.  NowIt just works if the user has set the money amount as 
1000.00, but I'm fixing it, I wish the term debt is right for this. 

sALudos 

Alberto Ladron 

Re: Commerce ID

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

In Poland there is reqirement to have on all
invoces VAT tax number 
Peter D.
-----Original Message-----
From: Oscar Buijten <os...@el...>
Date: Thu, 07 Feb 2002 09:57:21 +0100 
To: John Christian Stoddart <js...@im...>
Subject: Re: Commerce ID


> Hi,
> 
> I am not sure if it is a requirement in all cases in Europe, but with 
> certain transaction you are indeed obliged to indicate the customers (or 
> the shipping address') VAT number as well.
> 
> Example:
> Seller A
> Buyer B
> Warehouse C (logistics company for B)
> 
> When A, B and C are all in different countries (and this happens 
> regularly to me) then A needs to have the VAT number of C on his 
> invoice. This becomes even more important if B does not belong to the EC 
> and A and C do...
> 
> Got it? he he!
> 
> In other words VAT is a pain in the b.. for which you better cover your ...
> 
> Cheers,
> 
> Oscar
> 
> 
> 
> 
> John Christian Stoddart wrote:
> 
> > Hi,
> > 
> > This is a unique number that identifies the business at our local
> > equivalent of the IRS. Local law states mandatory use on all invoices,
> > receipts, etc. Thus an invoice will not only carry our number/code but
> > the customer's number/code as well.
> > 
> > Cheers
> > 
> > 
> > 
> > John Christian Stoddart
> > Caracas - Venezuela
> > 
> > On Wed, 2002-02-06 at 17:42, elizabeth ziph wrote:
> > 
> >>Is the Commerce ID equivalent of an SIC (Standard Industry Code, now
> >>being changed to an NAIC code) in the United States or is it like a
> >>company Tax ID ? 
> >>
> >>thanks
> >>elizabeth ziph
> >>The Linux Box Corp. 
> >>
> >>, On Wed, 2002-02-06 at 15:27, John Christian Stoddart wrote:
> >>
> >>>Hello,
> >>>
> >>>You could also use the first address line, at least until we get a
> >>>special field for this purpose.
> >>>
> >>>Cheers,
> >>>
> >>>
> >>>
> >>>John Christian Stoddart
> >>>Caracas - Venezuela
> >>>
> >>>On Wed, 2002-02-06 at 15:38, Rodrigo Roman wrote:
> >>>
> >>>>Is there any posibility to add a new field to the client?
> >>>> 
> >>>>Here we have a commerce idetifier (cuit like security number) and we need
> >>>>these number to be asociated to the client on every invoice...
> >>>> 
> >>>> 
> >>>>thanks!
> >>>>
> >>>
> >>
> >>
> > 
> > 
> 
> 
> -- 
> _____________________________________________________________
> 
> Oscar Buijten
> 
> Tel: +33.4.67.57.97.45
> Fax: +33.4.67.57.97.46
> GSM: +33.6.20.84.15.22
> 
> Email: os...@el...
> 
> Web:   www.elbie.com
> 
> 
> 
> 
> 

-- 

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

Win a ski trip!
http://www.nowcode.com/register.asp?affiliate=1net2phone3a

Re: Commerce ID

[Oscar B. <os...@el...>]

Hi,

I am not sure if it is a requirement in all cases in Europe, but with 
certain transaction you are indeed obliged to indicate the customers (or 
the shipping address') VAT number as well.

Example:
Seller A
Buyer B
Warehouse C (logistics company for B)

When A, B and C are all in different countries (and this happens 
regularly to me) then A needs to have the VAT number of C on his 
invoice. This becomes even more important if B does not belong to the EC 
and A and C do...

Got it? he he!

In other words VAT is a pain in the b.. for which you better cover your ...

Cheers,

Oscar




John Christian Stoddart wrote:

> Hi,
> 
> This is a unique number that identifies the business at our local
> equivalent of the IRS. Local law states mandatory use on all invoices,
> receipts, etc. Thus an invoice will not only carry our number/code but
> the customer's number/code as well.
> 
> Cheers
> 
> 
> 
> John Christian Stoddart
> Caracas - Venezuela
> 
> On Wed, 2002-02-06 at 17:42, elizabeth ziph wrote:
> 
>>Is the Commerce ID equivalent of an SIC (Standard Industry Code, now
>>being changed to an NAIC code) in the United States or is it like a
>>company Tax ID ? 
>>
>>thanks
>>elizabeth ziph
>>The Linux Box Corp. 
>>
>>, On Wed, 2002-02-06 at 15:27, John Christian Stoddart wrote:
>>
>>>Hello,
>>>
>>>You could also use the first address line, at least until we get a
>>>special field for this purpose.
>>>
>>>Cheers,
>>>
>>>
>>>
>>>John Christian Stoddart
>>>Caracas - Venezuela
>>>
>>>On Wed, 2002-02-06 at 15:38, Rodrigo Roman wrote:
>>>
>>>>Is there any posibility to add a new field to the client?
>>>> 
>>>>Here we have a commerce idetifier (cuit like security number) and we need
>>>>these number to be asociated to the client on every invoice...
>>>> 
>>>> 
>>>>thanks!
>>>>
>>>
>>
>>
> 
> 


-- 
_____________________________________________________________

Oscar Buijten

Tel: +33.4.67.57.97.45
Fax: +33.4.67.57.97.46
GSM: +33.6.20.84.15.22

Email: os...@el...

Web:   www.elbie.com

SQL-Ledger in Taiwan

[<Edm...@ju...>]

I'm trying to get in contact with SQL-Ledger contributors or users in
Taiwan to get impressions, talk about issues in using or implementing
SQL-Ledger in a Traditional Chinese/Taiwan environment.

Would any contributors or users in Taiwan be willing to talk to me
real-time (I'm in Taipei)? If so, could you email me at el...@in...?

Thanks!

...Edmund.

Credit notes

[William H. <wi...@sa...>]

Is there a way to create and print credit notes for a client returning
products etc?

TIA

William

Re: SQL-Ledger Manual & VAT 2

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

Scott Taylor wrote:

>
>
> Can anyone help me on this?
>
> Firstly, is there is a manual.
>
> Secondly, regardless of the answer to the first, I am in UK and VAT to
> customers in AR should be 17.5%. How do I do this?

Try this link:

http://www.minnesota.com/~tom/sql-ledger/howtos/

I believe it covers VAT in the FAQ section.

Good luck,
Steve

>
>
> I haven't got very far with setup of accounts, but is there something
> I should know about treatment of VAT in SQL-Ledger...are there any UK
> users?
>
> Thanks
>
> Scott

Re: Commerce ID

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

Hi,

This is a unique number that identifies the business at our local
equivalent of the IRS. Local law states mandatory use on all invoices,
receipts, etc. Thus an invoice will not only carry our number/code but
the customer's number/code as well.

Cheers



John Christian Stoddart
Caracas - Venezuela

On Wed, 2002-02-06 at 17:42, elizabeth ziph wrote:
> Is the Commerce ID equivalent of an SIC (Standard Industry Code, now
> being changed to an NAIC code) in the United States or is it like a
> company Tax ID ? 
> 
> thanks
> elizabeth ziph
> The Linux Box Corp. 
> 
> , On Wed, 2002-02-06 at 15:27, John Christian Stoddart wrote:
> > Hello,
> > 
> > You could also use the first address line, at least until we get a
> > special field for this purpose.
> > 
> > Cheers,
> > 
> > 
> > 
> > John Christian Stoddart
> > Caracas - Venezuela
> > 
> > On Wed, 2002-02-06 at 15:38, Rodrigo Roman wrote:
> > > Is there any posibility to add a new field to the client?
> > >  
> > > Here we have a commerce idetifier (cuit like security number) and we need
> > > these number to be asociated to the client on every invoice...
> > >  
> > >  
> > > thanks!
> > 
> > 
> 
> 
> 

SQL-Ledger Manual & VAT 2

[Scott T. <sco...@4i...>]

Can anyone help me on this?
Firstly, is there is a manual.
Secondly, regardless of the answer to the first, I am in UK and VAT to=20
customers in AR should be 17.5%. How do I do this?
I haven't got very far with setup of accounts, but is there something I =

should know about treatment of VAT in SQL-Ledger...are there any UK=20
users?
Thanks
Scott

Re: Commerce ID

[elizabeth z. <eli...@li...>]

Is the Commerce ID equivalent of an SIC (Standard Industry Code, now
being changed to an NAIC code) in the United States or is it like a
company Tax ID ? 

thanks
elizabeth ziph
The Linux Box Corp. 

, On Wed, 2002-02-06 at 15:27, John Christian Stoddart wrote:
> Hello,
> 
> You could also use the first address line, at least until we get a
> special field for this purpose.
> 
> Cheers,
> 
> 
> 
> John Christian Stoddart
> Caracas - Venezuela
> 
> On Wed, 2002-02-06 at 15:38, Rodrigo Roman wrote:
> > Is there any posibility to add a new field to the client?
> >  
> > Here we have a commerce idetifier (cuit like security number) and we need
> > these number to be asociated to the client on every invoice...
> >  
> >  
> > thanks!
> 
> 

Re: Commerce ID

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

Hello,

You could also use the first address line, at least until we get a
special field for this purpose.

Cheers,



John Christian Stoddart
Caracas - Venezuela

On Wed, 2002-02-06 at 15:38, Rodrigo Roman wrote:
> Is there any posibility to add a new field to the client?
>  
> Here we have a commerce idetifier (cuit like security number) and we need
> these number to be asociated to the client on every invoice...
>  
>  
> thanks!

Re: Commerce ID

[Rod R. <ro...@su...>]

You could put it in the Notes field.  I used this method to add some 
attributes to Parts, using "keyword=value" instances.

-- Rod
   http://www.sunsetsystems.com/

On Wednesday 06 February 2002 11:38, Rodrigo Roman wrote:
> Is there any posibility to add a new field to the client?
>
> Here we have a commerce idetifier (cuit like security number) and we
> need these number to be asociated to the client on every invoice...
>
>
> thanks!

Commerce ID

[Rodrigo R. <de...@fe...>]

Is there any posibility to add a new field to the client?
 
Here we have a commerce idetifier (cuit like security number) and we need
these number to be asociated to the client on every invoice...
 
 
thanks!

SQL-Ledger Manual & VAT

[Scott T. <sco...@4i...>]

Firstly, is there is a manual.
Secondly, regardless of the answer to the first, I am in UK and VAT to=20
customers in AR is 17.5%. How do I do this?
I haven't got very far with setup of accounts, but is there something I =

should know about treatment of VAT in SQL-Ledger...are there any UK=20
users?
Thanks
Scott

MySQL & Red Hat 7.2

[Scott T. <sco...@4i...>]

Can anyone help?
1.Can you use MySQL instead of Postgres. MySQL 3.23.47 has transaction=20
support through the Berkeley DB? Is there a MySQL DBD?
2.I understood most modern distros came with DBD and DBI. How do I know =

they are there and how can configure them? The support docs are too=20
volumous to understand and never explain exactly where you are supposed =

to run these commands from.
I have Apache and MySQL already configured and running, and I am at the =

point in SQL-Ledger where I have to create a dataset in Database=20
Administration.
Thanks

Re: can't get background to print

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

On Sun, 3 Feb 2002, Cesar Villanueva wrote:

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

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

Or here's another approach: Try printing http://dr.jones.dk/info/ and see
if the background shows up on _whatever_ browser you are using ("netscape"
is using for 2 different engines - the classic Netscape and the completely
rewritten Mozilla in Netscape 6+).

If it does not print there either, then your browser (configuration) is to
blame, not SQL-Ledger. One cannot blame SQL-Ledger for interpreting html
wrongly, just as one cannot blame the browser for not printing color on a
black/white printer.

If it does , and not on your hack on SQL-Ledger then compare the sources,
make whatever changes are necessary to make it work for SQL-Ledger as well
and report back on this so we can all gain from your work.

I agree that this is not the list for discussing how to optimally code
html, but on the other hand we all want a best possible SQL-Ledger, and
that includes print output. In other words: hints, suggestions and tweaks
are great, but don't blame SQL-Ledger if html generally doesn't work.

 - Jonas
"The guy that kept a non-perl-hacking html-related thread alive..."

-- 
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: can't get background to print

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

El Dom 03 Feb 2002 16:54, lee johnson escribi=F3:
> No I can not see in first place which I wondered about
> but I did not know if it was par for course or.......but
> yes I did wonder..and yes I changed in both template and
> css so I dunno why it isn't showing in sql-ledger........

I made my little homework on the issue and this is what I=20
have found. When you change the=20
/templates/user/invoice.html and change the=20
<body color=3Dffffff> tag to
<body backgroung=3D"image.gif"> (image.gif is located in the=20
same directory as invoice.html) the invoice _did_ print the=20
bg image.

You  can see the image entering in=20
SETUP/TEMPLATES/INVOICE.=20

You  must remember that if the image is smaller than the=20
page it will be appear tiled. Solution: use a image=20
processing program to paste in the right position against a=20
transparent background and mnipulete the image itself to=20
have a certain degree of transparency, so it can be more of=20
a watermark, not a solid one.

> my 'tone' only came through because I felt the remark
> about 'html' mail was unkind that could have been sent
> privately to avoid embarrasement..I'm an old timer and I
> do not post html email 'on purpose ' :)

The truth is taht I was surprised about the remark because=20
_I_ did NOT get your original message as HTML (I check the=20
source of the page and it was plain text.

Maybe it the other guys configuration=20

>
> cu and thx
> lee

Greetings from Venezuela

--=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: Problem with adding parts after I imported part data

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

Found the problem.  There is a sequence id defined.  I just need to make the
number higher than the number I used when loading in the parts and then I
should be set.  Please let me know if this will not work.

cheers,

ski

 -----Original Message-----
From: 	Chris Kacoroski [mailto:kac...@ho...]
Sent:	Sunday, February 03, 2002 9:39 PM
To:	'sql...@li...'
Subject:	Problem with adding parts after I imported part data

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