sql-ledger-users — SQL-Ledger users

Re: [SL] pdf and freebsd

[Mark B. <ma...@ex...>]

On 31 Oct 2006, at 09:04, Asante, Emmanuel [ING-WBK] wrote:

>
>
>>
>> Hello can anyone give me some pointers on where to begin
>> creating pdf invoces?  Using FreeBSD and all i get for clues
>> i a big red error message.  Not sure where to begin guessing
>> i need some packages installed first.
>>
>> --
>
> Ryan,
>
> You need to install Latex. On my Debian box I installed tetex but I  
> don't know what the Latex package is called on FreeBSD. Find out  
> what it's called and install it.

It will be tetex as well.

http://www.freshports.org/print/teTeX

>
> Regards,
> Emmanuel
>
> This message and any attached files may contain information that is  
> confidential and/or subject of legal privilege intended only for  
> use by the intended recipient. If you are not the intended  
> recipient or the person responsible for delivering the message to  
> the intended recipient, be advised that you have received this  
> message in error and that any dissemination, copying or use of this  
> message or attachment is strictly forbidden, as is the disclosure  
> of the information therein. If you have received this message in  
> error please notify the sender immediately and delete the message.
>
> ---------------------------------------------------------------------- 
> ---
> Using Tomcat but need to do more? Need to support web services,  
> security?
> Get stuff done quickly with pre-integrated technology to make your  
> job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache  
> Geronimo
> http://sel.as-us.falkag.net/sel? 
> cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] pdf and freebsd

[Asante, E. [ING-WBK] <Emm...@bh...>]

=20
>=20
> Hello can anyone give me some pointers on where to begin=20
> creating pdf invoces?=A0 Using FreeBSD and all i get for clues=20
> i a big red error message.=A0 Not sure where to begin guessing=20
> i need some packages installed first.=20
>=20
> --

Ryan,

You need to install Latex. On my Debian box I installed tetex but I don't=
 know what the Latex package is called on FreeBSD. Find out what it's=
 called and install it.

Regards,
Emmanuel

This message and any attached files may contain information that is=
 confidential and/or subject of legal privilege intended only for use by=
 the intended recipient. If you are not the intended recipient or the=
 person responsible for delivering the message to the intended recipient,=
 be advised that you have received this message in error and that any=
 dissemination, copying or use of this message or attachment is strictly=
 forbidden, as is the disclosure of the information therein. If you have=
 received this message in error please notify the sender immediately and=
 delete the message.

[SL] pdf and freebsd

[RYAN M. v. G. <lu...@co...>]

Hello can anyone give me some pointers on where to begin creating pdf invoc=
es?=C2=A0 Using FreeBSD and all i get for clues i a big red error message.=
=C2=A0 Not sure where to begin guessing i need some packages installed firs=
t.=20

--=20
Computer=C2=A0King/CaNMail=20

http://www.computerking.ca=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0http://www.canmail.=
org=20

Sales,=C2=A0Service,=C2=A0and=C2=A0Hosting=20
Email,=C2=A0Data,=C2=A0and=C2=A0Web=C2=A0Packages=20
Ask=C2=A0about=C2=A0web=C2=A0design=C2=A0specials=20

Affiliates=20
http://www.computerking.ca/pages/links/affiliates/affiliates.htm=20

Maybe=C2=A0Computer=C2=A0Science=C2=A0should=C2=A0be=C2=A0in=C2=A0the=C2=A0=
College=C2=A0of=C2=A0Theology.=C2=A0--=C2=A0R.=C2=A0S.=C2=A0Barton=C2=A0=20

Re: [SL] Carrect VAT amount

[Paul L. <pj...@in...>]

WIth regard to adjusting VAT rounding differences on AP invoices, we  
found this works well to adjust the tax:

- set up a service "VATable rounding" which is taxable (price 0.01)
- set up another service "NON VATable service" which is non taxable  
(price 0.01)

You can then combine different quantities of these services, positive  
and negative, to adjust your tax without affecting the net total.

For example, to increase tax, add a positive quantity of VATable  
rounding service and then add an equal negative quantity of NON  
VATable rounding - this leaves your net total unchanged but increases  
the amount of tax.

We have been using this for a few years now and whilst we end up with  
two extra lines on the occasional AP invoice, we find it works really  
neatly and our ledger then balances to our suppliers without having  
to write amounts off or back etc.

Does that sound useful?

Paul.

On 30 Oct 2006, at 21:13, R Pennington wrote:

> Not a bad idea Olle.
> That should help a few people.
>
> But, the problem is, that method adjusts the subtotal...not the TAX.
> I need a way to adjust the tax....not the subtotal.
>
>
> Cheers !
> Roy

Re: [SL] Carrect VAT amount

[R P. <arc...@mt...>]

Not a bad idea Olle.
That should help a few people.

But, the problem is, that method adjusts the subtotal...not the TAX.
I need a way to adjust the tax....not the subtotal.


Cheers !
Roy


On Monday 30 October 2006 8:28 am, Olle Niit wrote:
> I know better way:
> I added new service, no price, no pcs, no VAT.
> Number RO and description Rounding
> 
> Now I can adjust Invoice value as I need, when needed, I add line 
> Rounding with price 0.01, when needed, I add line Rounding with price 
> -0.05 etc.
> Then there is no need for double AP Transaction, what was very painfull 
> for me to remember.
> I think this is the best way to do that.
> 
> Roy W Pennington wrote:
> > I run into this problem with a few vendors depending on how their software handles rounding.
> >
> > What I've been doing is:
> > -Create an additional "AP Transaction" for the vendor invoice in question.
> > -Enter the same vendor name, invoice number, and enter no value other than an overridden  tax amount.
> >  Enter either the tax as a positive or negative amount, and make a comment in the notes about why the transaction is being done.
> >
> > Using the same invoice number groups the two transactions together so that everything shows up correct in the payments screen and in the tax account.
> > This works for me in my jurisdiction. It may work for you. I'm not an accountant.

Re: [SL] Altering transactions after they are flagged as reconciled

[Wallace R. C. <wrc...@gm...>]

On 10/29/06, david <da...@ke...> wrote:
...
> I believe an accountant would tell you that deleting/changing
> transactions after reconciliation is a BAD_IDEA (tm).

Why not simply make an adjusting transaction instead of deleting one?
-- 
Best Regards,
Wallace

Re: [SL] Carrect VAT amount

[Olle N. <ol...@pa...>]

I know better way:
I added new service, no price, no pcs, no VAT.
Number RO and description Rounding

Now I can adjust Invoice value as I need, when needed, I add line 
Rounding with price 0.01, when needed, I add line Rounding with price 
-0.05 etc.
Then there is no need for double AP Transaction, what was very painfull 
for me to remember.
I think this is the best way to do that.

Roy W Pennington wrote:
> I run into this problem with a few vendors depending on how their software handles rounding.
>
> What I've been doing is:
> -Create an additional "AP Transaction" for the vendor invoice in question.
> -Enter the same vendor name, invoice number, and enter no value other than an overridden  tax amount.
>  Enter either the tax as a positive or negative amount, and make a comment in the notes about why the transaction is being done.
>
> Using the same invoice number groups the two transactions together so that everything shows up correct in the payments screen and in the tax account.
> This works for me in my jurisdiction. It may work for you. I'm not an accountant.
>   


-- 
Olle Niit
Teknet Arvutid OÜ
tel 53 767 888
ol...@pa...

Re: [SL] importing csv files

[David R. <le...@re...>]

Quickbooks is pretty much a 'Hotel California' for transaction data. They go 
to great lengths to  prevent you from getting transaction data.
This of course helps the revenue stream because its easier to pay another $150 
this year and upgrade than to do anything else.

I have had a link in the past to a [non-free] package that can convert a QB 
database to Micro$oft Access and I used it once and was able to write a 
conversion for my specific needs. The problem was that on the next Quickbooks 
update, Intuit changed fhe format yet again, rendering the $100 converter 
useless.

I just googled and this sounds like the program that I used:
http://www.synergration.com/accessBooks/default.htm

I seem to remember that the one I used had a free download that would show 
only the first 50 records in each table, so you could get an idea what 
your're getting into and if it will work with your data.

Good luck, and as always -- "your mileage may vary", "Solutions are guaranteed 
to work unless they don't", etc.

--
Dave Ratte
Recreational Mobility

On Sunday 29 October 2006 11:54, Danita Zanre wrote:
> BTW - I see that these are all pretty much "static" info imports - like
> customers, vendors, parts, etc.  I'd be interested if anyone has every put
> together an import tool for importing actual transactions I guess!

Re: [SL] Altering transactions after they are flagged as reconciled

[david <da...@ke...>]

On Sun, 2006-10-29 at 14:11 +0000, Kevin Bailey wrote:
> Hi,
> 
> When going through the reconcilliation there are times when this shows 
> me that an error has occured.
> 
> So sometime I have to delete a transaction.
> 
> If this has not been reconciled can I presume that this will not have 
> any effect.
> 
> What happens if I accidentally delete a transaction which has been set 
> as reconciled?

I finished my quarterly reconciliations about an hour ago, so it's all
very fresh :-)

If you alter or delete any transaction that's been previously
reconciled, the reconciliation will need to be done again (pretty
reasonable really). As a matter of good practice, I always check the old
reconciliation before starting a new period. 

If you delete or alter any transaction from AFTER the period that has
been reconciled, there is no effect at all.

I believe an accountant would tell you that deleting/changing
transactions after reconciliation is a BAD_IDEA (tm). I do it all the
time, but then I'm not an accountant so it's OK. You can use audit
control to lock transactions (somebody correct me if I'm wrong?), but
that's for people who do the job properly.

[SL] ASSEMBLY

[RYAN M. v. G. <lu...@co...>]

Is there a was to list the individual items on the invoice for assemblies?=
=C2=A0 Example i built an assembly called basic system 1 it includes the fo=
llowing parts;=20

case=20
mainboard=20
cpu=20
ram=20
harddisk=20
dvdrw=20

When I=C2=A0email the invoice i only get=C2=A0basic system 1 and no listing=
 of the individual parts i wish to have a listing of the individual parts a=
nd=C2=A0want to be able to modify the discription ie for CPU INTEL P4 CORE =
DAUL as=C2=A0basic parts do not change but models seem to change almost dai=
ly.=C2=A0=20

Am i going about this the wrong way is there a better way?=20

THANK YOU IN ADVANCE=20


--=20
Computer=C2=A0King/CaNMail=20

http://www.computerking.ca=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0http://www.canmail.=
org=20

Sales,=C2=A0Service,=C2=A0and=C2=A0Hosting=20
Email,=C2=A0Data,=C2=A0and=C2=A0Web=C2=A0Packages=20
Ask=C2=A0about=C2=A0web=C2=A0design=C2=A0specials=20

Affiliates=20
http://www.computerking.ca/pages/links/affiliates/affiliates.htm=20

Maybe=C2=A0Computer=C2=A0Science=C2=A0should=C2=A0be=C2=A0in=C2=A0the=C2=A0=
College=C2=A0of=C2=A0Theology.=C2=A0--=C2=A0R.=C2=A0S.=C2=A0Barton=C2=A0=20

Re: [SL] importing csv files

[Roy P <or...@sh...>]

On Sunday 29 October 2006 8:33 am, Danita Zanre wrote:
> > They're here:
> > <http://www.sql- ledger.org/cgi- bin/nav.pl?page=misc/conversions.html>
>
> Okay - so now the next question is, just how flexible are these for a
> non-expert, and can they be used on an ongoing basis.  For example, both
> our shopping cart and our credit card processor will export data in comma
> delimited, tab delimited, Quicken or Quickbooks formats.  Would it be easy
> enough for me to "import" this information into my SQL-Ledger routinely?
>
> Thanks.
>
> Danita

The scripts on that page only import parts, vendor info and customer info.
They don't handle actual transactions. 

This could be done using Sql-ledger API. There has been a few posts on this 
list about developing script that will handle this.

Maybe others on this list who already have scripts like this can give/sell 
them to you..... or can write some for you if needed. 
Of course having Dieter write them for you is an option too.

Cheers

Re: [SL] importing csv files

[Danita Z. <da...@ca...>]

>Okay -  so now the next question is, just how flexible are these for a =
non- expert, and can they be >used on an ongoing basis. =20

BTW - I see that these are all pretty much "static" info imports - like =
customers, vendors, parts, etc.  I'd be interested if anyone has every put =
together an import tool for importing actual transactions I guess!

Thanks.

Danita

Re: [SL] importing csv files

[Danita Z. <da...@ca...>]

> They're here:
> <http://www.sql- ledger.org/cgi- bin/nav.pl?page=3Dmisc/conversions.html>=


Okay - so now the next question is, just how flexible are these for a =
non-expert, and can they be used on an ongoing basis.  For example, both =
our shopping cart and our credit card processor will export data in comma =
delimited, tab delimited, Quicken or Quickbooks formats.  Would it be easy =
enough for me to "import" this information into my SQL-Ledger routinely?

Thanks.

Danita

[SL] Altering transactions after they are flagged as reconciled

[Kevin B. <kb...@fr...>]

Hi,

When going through the reconcilliation there are times when this shows 
me that an error has occured.

So sometime I have to delete a transaction.

If this has not been reconciled can I presume that this will not have 
any effect.

What happens if I accidentally delete a transaction which has been set 
as reconciled?

Thanks,

Kevin

Re: [SL] importing csv files

[Stroller <lin...@my...>]

On 27 Oct 2006, at 22:29, Uri Guttman wrote:
>
> i have data dumped from another ledger program (quickbooks) in csv
> files. it is typical stuff like product orders and customer/vendor
> info. is there any standard way to import these into sql-ledger? or  
> are
> there any relate utility scripts or examples?

They're here:
<http://www.sql-ledger.org/cgi-bin/nav.pl?page=misc/conversions.html>


Dieter:

It took me some time to find these, and I was only able to because I  
knew they existed. Eventually I searched the email folder to which I  
filter this list for "import" and found the link straight away, but I  
was unable to search your site via Google. For instance, <http:// 
www.google.com/search?q=+import+site%3Asql-ledger.org> returns  
nothing, and it seems that in all only 3 pages of SQL-Ledger are  
indexed by Google <http://www.google.com/search?q=site%3Asql- 
ledger.org>. Is spiders.txt the problem? If this is something that  
could be easily resolved then it might be helpful.

Stroller.

[SL] importing csv files

[Uri G. <ur...@be...>]

i have data dumped from another ledger program (quickbooks) in csv
files. it is typical stuff like product orders and customer/vendor
info. is there any standard way to import these into sql-ledger? or are
there any relate utility scripts or examples? i can hack the perl to
suit my needs (parsing cvs, column name munging and such) or even do a
full script if there is a schema and/or some dbi code i can use. any
ideas are welcome.

thanx,

uri

Re: [SL] Email question

[RYAN M. v. G. <lu...@co...>]

----- Stroller <lin...@my...> wrote:
> On 23 Oct 2006, at 02:57, RYAN M. vAN GINNEKEN wrote:
> 
> > Thanks agian for your reply now that i have email working i am  
> > stumped on the logo thing.  I have added my logo to /usr/local/sql-
> 
> > ledger directory it has the following perms and onwerships.
> >
> > -rwxrwxrwx   1 www   www     2425 Oct 22 18:46 logo.png
> >
> > It shows up when i edit my letterhead.html but when i send an email 
> 
> > it is not there just the border I added and one of those browser  
> > palace holder thingys.
> 
> I seem to have just experienced the same thing, but using my logo in 
> 
> invoice.tex
> 
> I had honestly disregarded Mr Van Ginneken's problem as "existing  
> between keyboard & chair" however the problem seems to have  
> inexplicably resolved itself for me, and I can only conclude that  
> something glitchy may sometimes occur with the logo.

Thank for the Vote of confidence hehe as i must admit most of my errors are usually related to something between the chair and the keyboard.

> 
> I have spent some time this morning paying attention to the full  
> format of the .png file - for instance note that:
>    $ file /usr/local/sql-ledger/templates/Service-logo.png
>     /usr/local/sql-ledger/templates/Service-logo.png: PNG image data, 
> 
> 220 x 138, 8-bit colormap, non-interlaced
>    $ convert my_logo.eps foo.png
>    $ file foo.png
>    foo.png: PNG image data, 584 x 576, 16-bit/color RGB,
> non-interlaced
>    $ convert my_logo.eps -depth 8 foo.png
>    $ file foo.png
>    foo.png: PNG image data, 584 x 576, 8-bit/color RGB,
> non-interlaced
>    $
> 
> However in frustration I copied back the original logo and it STILL! 
> 
> didn't work!!?! After making trivial edits in my invoice.tex the logo 
> 
> reappeared, only to remain there when I reverted those very same
> edits!!
> 
> When I copied back my_logo.png, suddenly it worked perfectly!!
> So I am completely unable to explain why the image didn't work in the 
> 
> first place.
> 
> My permissions are the same as Ryan's, and I have changed them at no 
> 
> time.
> I can't believe I have made some stupid mistake - even though that's 
> 
> the only logical explanation! - because I used my bash history to go 
> 
> back to the same `cp working.png /usr/local/sql-ledger/templates/ 
> stroller/logo.png` each time. Likewise, I used up-arrow in bash to  
> edit the `convert` command (ImageMagick), then `file` & `identify` to 
> 
> check the file format.
> 
> So my only suggestion to someone else experiencing this is to copy  
> the original logo back and then try again from scratch. Maybe there's 
> 
> something in the email generation process that caches the logo?

I have try ed this and it did not work for me however i will try it again and again just to make sure.  I will post back to this list with my results in the next few days as i am very busy for the next while.  

> 
> Stroller.
> 
> 
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services,
> security?
> Get stuff done quickly with pre-integrated technology to make your job
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache
> Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users


-- 
Computer King/CaNMail

http://www.computerking.ca     http://www.canmail.org

Sales, Service, and Hosting
Email, Data, and Web Packages
Ask about web design specials

Affiliates
http://www.computerking.ca/pages/links/affiliates/affiliates.htm

Maybe Computer Science should be in the College of Theology. -- R. S. Barton 

Re: [SL] Email question

[Stroller <lin...@my...>]

On 23 Oct 2006, at 02:57, RYAN M. vAN GINNEKEN wrote:

> Thanks agian for your reply now that i have email working i am  
> stumped on the logo thing.  I have added my logo to /usr/local/sql- 
> ledger directory it has the following perms and onwerships.
>
> -rwxrwxrwx   1 www   www     2425 Oct 22 18:46 logo.png
>
> It shows up when i edit my letterhead.html but when i send an email  
> it is not there just the border I added and one of those browser  
> palace holder thingys.

I seem to have just experienced the same thing, but using my logo in  
invoice.tex

I had honestly disregarded Mr Van Ginneken's problem as "existing  
between keyboard & chair" however the problem seems to have  
inexplicably resolved itself for me, and I can only conclude that  
something glitchy may sometimes occur with the logo.

I have spent some time this morning paying attention to the full  
format of the .png file - for instance note that:
   $ file /usr/local/sql-ledger/templates/Service-logo.png
    /usr/local/sql-ledger/templates/Service-logo.png: PNG image data,  
220 x 138, 8-bit colormap, non-interlaced
   $ convert my_logo.eps foo.png
   $ file foo.png
   foo.png: PNG image data, 584 x 576, 16-bit/color RGB, non-interlaced
   $ convert my_logo.eps -depth 8 foo.png
   $ file foo.png
   foo.png: PNG image data, 584 x 576, 8-bit/color RGB, non-interlaced
   $

However in frustration I copied back the original logo and it STILL!  
didn't work!!?! After making trivial edits in my invoice.tex the logo  
reappeared, only to remain there when I reverted those very same edits!!

When I copied back my_logo.png, suddenly it worked perfectly!!
So I am completely unable to explain why the image didn't work in the  
first place.

My permissions are the same as Ryan's, and I have changed them at no  
time.
I can't believe I have made some stupid mistake - even though that's  
the only logical explanation! - because I used my bash history to go  
back to the same `cp working.png /usr/local/sql-ledger/templates/ 
stroller/logo.png` each time. Likewise, I used up-arrow in bash to  
edit the `convert` command (ImageMagick), then `file` & `identify` to  
check the file format.

So my only suggestion to someone else experiencing this is to copy  
the original logo back and then try again from scratch. Maybe there's  
something in the email generation process that caches the logo?

Stroller.

Re: [SL] Printing invoices in landscape format (.tex template / pdf / CUPS)

[Stroller <lin...@my...>]

On 23 Oct 2006, at 18:02, C. Duncan Hudson wrote:

> We don't print invoices landscape, but we do print labels that way.
> Here's what one of our landscape tex files looks like:
> ...
> \usepackage{rotating}
> ...
> \begin{sideways}
> ...
> \end{sideways}

My apologies. Being completely new to .tex I had failed to see the  
significance of this - I do so now!!
I should have read more carefully.
I'll be trying this now.

Stroller.

Re: [SL] Printing invoices in landscape format (.tex template / pdf / CUPS)

[Stroller <lin...@my...>]

Hi Duncan,

Thanks very much for your reply. I am quite stuck on this!!


On 23 Oct 2006, at 18:02, C. Duncan Hudson wrote:

> We don't print invoices landscape, but we do print labels that way.
> Here's what one of our landscape tex files looks like:
>
>
> \documentclass[oneside]{scrartcl}
> \documentstyle[rotate]{article}
> \usepackage[latin1]{inputenc}
> \usepackage[english]{babel}
> \usepackage{rotating}
> \usepackage{array}
> \usepackage{pstricks,tabularx}
> \usepackage{pst-barcode}
> \usepackage[absolute, overlay]{textpos}
> \usepackage[paperwidth=4in,paperheight=2.25in,margin=0.125]{geometry}
> \usepackage{graphicx}
> \usepackage{hyperref}
> \setlength\parindent{0pt}
> \setlength\arrayrulewidth{0.1mm}

I'd tried only this simple change to the default invoice.:

    \documentclass{scrartcl}
    \usepackage[latin1]{inputenc}
    \usepackage{tabularx}
    %\usepackage 
[letterpaper,top=2cm,bottom=-3cm,left=1.1cm,right=1.5cm]{geometry}
    \usepackage 
[a4paper,landscape,top=2cm,bottom=3cm,left=1.1cm,right=1.5cm]{geometry}
    \usepackage{graphicx}

    \begin{document}

    \pagestyle{myheadings}
    \thispagestyle{empty}
   ...

Having examined your header, I added:
    \usepackage{rotating}


However that has made no difference.

> That should give you an idea of what you need to do, but an even  
> easier
> way of dealing with this is to just create a CUPS queue that only  
> prints
> landscape.

Could you explain how to do this, please?

I have this in /usr/local/sql-ledger/sql-ledger.conf:

# available printers
%printer = ( 'HP Laserjet 4 - landscape' => 'lpr -o landscape -P  
HPLaserJet5M',
              'HP Laserjet 4'            => 'lpr -P HPLaserJet5M',
              'Canon IP3000 on funf'     => 'lpr -P iP3000',
              );

But this does not work for my ps or pdf invoices.

After some experimentation it transpires that `lpr -o landscape`  
works great with plain text, but not with postscript documents - all  
that seems to happen is that a sheet of A4 is printed in portrait  
format, with the image halfway down the sheet and falling half off  
the page. It seems that I have the problem mentioned here: <http:// 
marc.theaimsgroup.com/?l=redhat-list&m=103340134024139&w=2>. The CUPS  
manual says that "-o landscape option will rotate the page 90 degrees  
to print in landscape orientation" <http://www.cups.org/doc-1.1/ 
sum.html#4_1_2> but it does not mention that this does not work with  
postscript documents.

The only things I can think right now are to:
1) do an entire .tex layout in portrait with all the text at 90- 
degrees. I have no idea id this is possible?
2) have a virtual printer (I think this could be done with Bash &  
some pipes?) that rotates a postscript or pdf document through 90  
degrees before printing it.

Any other ideas?

TIA for any help,

Stroller.

Re: [SL] Unable to access the archives

[Stroller <lin...@my...>]

On 24 Oct 2006, at 12:38, Melanie McLaughlin wrote:

> I am trying to access this list and cannot view it.
>
> "Private archive file not found"

I don't think the "official archive" has been working for some time.

Try: <http://www.mail-archive.com/sql-ledger- 
us...@li.../maillist.html> (wrapping hopefully  
corrected) or http://tinyurl.com/yxj462

Stroller.

Re: [SL] Unable to access the archives

[Stroller <lin...@my...>]

On 24 Oct 2006, at 12:38, Melanie McLaughlin wrote:

> I am trying to access this list and cannot view it.
>
> "Private archive file not found"

I don't think the "official archive" has been working for some time.
Try: http://www.mail-archive.com/sql-ledger- 
us...@li.../maillist.html

Stroller.

[SL] Unable to access the archives

[Melanie M. <me...@in...>]

I am trying to access this list and cannot view it.

"Private archive file not found"

Please advise what I can do to view the archives.

Thanks
Melanie

Re: [SL] Printing invoices in landscape format (.tex template / pdf / CUPS)

[C. D. H. <Du...@Du...>]

We don't print invoices landscape, but we do print labels that way.  
Here's what one of our landscape tex files looks like:


\documentclass[oneside]{scrartcl}
\documentstyle[rotate]{article}
\usepackage[latin1]{inputenc}
\usepackage[english]{babel}
\usepackage{rotating}
\usepackage{array}
\usepackage{pstricks,tabularx}
\usepackage{pst-barcode}
\usepackage[absolute, overlay]{textpos}
\usepackage[paperwidth=4in,paperheight=2.25in,margin=0.125]{geometry}
\usepackage{graphicx}
\usepackage{hyperref}
\setlength\parindent{0pt}
\setlength\arrayrulewidth{0.1mm}

\begin{document}

\fontfamily{phv}\fontsize{18pt}{18pt}\selectfont
\pagestyle{myheadings}





\begin{sideways}
\begin{minipage}{2in}
\vspace{1in}
\begin{hyphenrules}{nohyphenation}
\begin{center} \textbf{<%notes%>}

\vspace{.5in}

\fontfamily{phv}\fontsize{8pt}{8pt}\selectfont
{\Tiny <%invnumber%>}

\end{center}\end{hyphenrules}
\end{center}\end{hyphenrules}
\end{minipage}
\end{sideways}



\end{document}

That should give you an idea of what you need to do, but an even easier 
way of dealing with this is to just create a CUPS queue that only prints 
landscape.


Dunc

Stroller wrote:
> Hi there,
>
> Is anyone printing their invoices in a landscape format, please? I  
> have a supplier that sends me their invoices laid out in this way and  
> because I usually have few items on an invoice I'd like to do the  
> same - I'd like the extra space for item descriptions & notes offered  
> by the additional width.
>
> I seem to be having some problems changing invoice.tex to landscape  
> format, however, and sending it to a CUPS printer. Emailed PDFs seem  
> to come out fine.
>
> I'll be glad to give more details but I don't think there's much  
> point unless there's someone else on the list who's either using  
> landscape format printing from SL or who happens to be a CUPS expert.  
> Please let me know if you are and I'll explain my problems.
>   

> Thanks for reading,
>
> Stroller.
>
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>   

Re: [SL] Email question

[RYAN M. v. G. <lu...@co...>]

----- Stroller <lin...@my...> wrote:
> On 23 Oct 2006, at 02:57, RYAN M. vAN GINNEKEN wrote:
> > ...
> > It shows up when i edit my letterhead.html but when i send an email 
> 
> > it is not there just the border I added and one of those browser  
> > palace holder thingys.
> >
> > Have this in my letterhead.html what am i doing wrong?
> 
> What format  are you sending the invoice in? There's a drop-down on  
> the email page, the page where you type the email subject & body, to 
> 
> choose html, postscript or pdf. The layout for PDF is controlled by  
> invoice.tex

I am using html format because i cannot get PDF to work at all just gives me a big red error.
I am editing the letterhead.html file which by the look of it is included in several other html templates ie quotos and sales invoice.
> 
> Stroller
> 
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services,
> security?
> Get stuff done quickly with pre-integrated technology to make your job
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache
> Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users


-- 
Computer King/CaNMail

http://www.computerking.ca     http://www.canmail.org

Sales, Service, and Hosting
Email, Data, and Web Packages
Ask about web design specials

Affiliates
http://www.computerking.ca/pages/links/affiliates/affiliates.htm

Maybe Computer Science should be in the College of Theology. -- R. S. Barton