sql-ledger-users — SQL-Ledger users

Re: [SL] Printing Issues

[David B. <dav...@sb...>]

On Tue, 2006-11-21 at 13:07 -0700, Jon Scottorn wrote:
> HI,
> 
>    I am wondering if anyone could offer assistance.  I am trying to
> print the AR Aging report and I am running into issues.
> When I print that report this is what happens.  We are printing
> thousands of records which when you print it seperates each client into
> a seperate print job so what happens is we get an error saying too many
> jobs for the printer.  What I am wondering is if there was an easy way
> to create one big job with all those thousands of records.  I know the
> job will be very large but I have enough printer memory to handle
> that.  

> Any thoughts or suggestions would be greatly appreciated.
What OS is the server or print server running?  If *Nix...what flavor?
If nix, in /etc/cups/cupsd.conf there is a MaxRequestSize setting that
may be of help to at least allow it to handle that many jobs.  While I
know that you would like to combine the jobs into one instead...that may
be at least a temporary solution.  It may require a some Google, but on
my Debian Sarge machine, this line is commented anyway with notation
that it defaults to 0. Might toy with uncommenting and playing with the
value.  Testing, on the other hand, may be a little more tricky without
wasting some paper or taking the printer offline for a bit.

HTH,
David Boyle



> Thanks,

> Jon Scottorn
> Systems Administrator
> The Possibility Forge, Inc.
> http://www.possibilityforge.com
> 435.635.0591 x.1004
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

[SL] Printing Issues

[Jon S. <jsc...@po...>]

HI,

   I am wondering if anyone could offer assistance.  I am trying to
print the AR Aging report and I am running into issues.
When I print that report this is what happens.  We are printing
thousands of records which when you print it seperates each client into
a seperate print job so what happens is we get an error saying too many
jobs for the printer.  What I am wondering is if there was an easy way
to create one big job with all those thousands of records.  I know the
job will be very large but I have enough printer memory to handle
that.  

Any thoughts or suggestions would be greatly appreciated.

Thanks,

Jon Scottorn
Systems Administrator
The Possibility Forge, Inc.
http://www.possibilityforge.com
435.635.0591 x.1004

Re: [SL] How do projects work, please?

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

On Tue, Nov 21, 2006 at 05:36:49PM +0000, Stroller wrote:
> Hi there,
> 
> I have a number of customers I bill periodically - they call me on a  
> casual basis, ask me to do some work for them (which may only  
> constitute 15 minutes or an hour) and I make a note of the visit in  
> my diary, billing them every month or two, when they've built up a  
> debt worth billing for.
> 
> It was my understanding that SL's "projects" facility could do this  
> "diarying" for me - I expected to be able to open a project for Foo  
> Co., call it "Fourth Quarter 2006" and just enter line items by part  
> number & quantity into the project. Item notes would also be  
> immensely useful, so I could say for instance: "Delivery date:  
> 21/11/2006. Part: LAB001. Description: Labour, 1 hour. Qty: 2. Notes:  
> replacing roof tiles & guttering following storm." When I get around  
> to invoicing 10 hours of work at the end of the month or quarter I  
> expected to be able to just dump all these items into an AR > Sales  
> Invoice.

Use timecards.

then generate sales order from open timecards (sounds like you
want with detail).

then generate invoice from sales order.

m

Re: [SL] How do projects work, please?

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

> Basically I want to add items to different invoices over a period of =20
> weeks, keeping some open whilst others are closed & posted.

I'd like to understand projects too - however, in the interim, I've been =
using "orders" instead.  I just add a new line item to the order each time =
I do work for a customer, and then when I'm ready to invoice them I create =
the invoice.

Danita

Re: [SL] How do projects work, please?

[Dr E. L. <el...@li...>]

Timecard, perhaps?

el

on 11/21/06 7:36 PM Stroller said the following:
> Hi there,
>
> I have a number of customers I bill periodically - they call me on a
> casual basis, ask me to do some work for them (which may only
> constitute 15 minutes or an hour) and I make a note of the visit in
> my diary, billing them every month or two, when they've built up a
> debt worth billing for.
>
> It was my understanding that SL's "projects" facility could do this
> "diarying" for me - I expected to be able to open a project for Foo
> Co., call it "Fourth Quarter 2006" and just enter line items by part
> number & quantity into the project. Item notes would also be
> immensely useful, so I could say for instance: "Delivery date:
> 21/11/2006. Part: LAB001. Description: Labour, 1 hour. Qty: 2. Notes:
> replacing roof tiles & guttering following storm." When I get around
> to invoicing 10 hours of work at the end of the month or quarter I
> expected to be able to just dump all these items into an AR > Sales
> Invoice.
>
> However I have tried this on the demo installations of SL & they do
> not appear to behave as I expected. [1] What am I missing, please?
>
> Is there any other way to do the sort of thing I describe?
>
> Basically I want to add items to different invoices over a period of
> weeks, keeping some open whilst others are closed & posted.
>
> Stroller.

Re: [SL] Adding notes without reposting

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

On 20 Nov 2006, at 11:31, Kevin Bailey wrote:
> ...
> Does anyone have any ideas RE how to add to the internal notes without
> reposting the invoice?

Adding the notes & emailing the invoice to yourself seems to work.

Of course this also adds the email content to the internal notes  
field, so it may be undesirable, but this seems like a useful way of  
adding ITEMNOTES to an already-posted invoice, too.

Stroller.

[SL] How do projects work, please?

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

Hi there,

I have a number of customers I bill periodically - they call me on a  
casual basis, ask me to do some work for them (which may only  
constitute 15 minutes or an hour) and I make a note of the visit in  
my diary, billing them every month or two, when they've built up a  
debt worth billing for.

It was my understanding that SL's "projects" facility could do this  
"diarying" for me - I expected to be able to open a project for Foo  
Co., call it "Fourth Quarter 2006" and just enter line items by part  
number & quantity into the project. Item notes would also be  
immensely useful, so I could say for instance: "Delivery date:  
21/11/2006. Part: LAB001. Description: Labour, 1 hour. Qty: 2. Notes:  
replacing roof tiles & guttering following storm." When I get around  
to invoicing 10 hours of work at the end of the month or quarter I  
expected to be able to just dump all these items into an AR > Sales  
Invoice.

However I have tried this on the demo installations of SL & they do  
not appear to behave as I expected. [1] What am I missing, please?

Is there any other way to do the sort of thing I describe?

Basically I want to add items to different invoices over a period of  
weeks, keeping some open whilst others are closed & posted.

Stroller.





[1] Edmonton <http://abacus.sql-ledger.com/sql-ledger/> gives  
"undefined" errors in various project pages, BTW.

Re: [SL] SQL Version 2.6.19 has been acting up since the last upgrade. We have to keep inputting our password all the time.

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

On 19 Nov 2006, at 23:38, C. Duncan Hudson wrote:
> ...
> My users are all either set to 14400 or 28800 - depending upon  
> their job
> functions.  All of my users have complained about the "immediate
> relogin" issue since going to 2.6.19.

Just a thought - have you tried changing the users' timeout settings  
since the upgrade? Changing from 14400 to 14401 (and even back  
again!) might be worth a go - I have known applications to respond to  
that.

Ironically one of the demo installations of SL <http://neptune.sql- 
ledger.com/sql-ledger/> is exhibiting this problem.

Stroller.

Re: [SL] Refund Checks

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

On Mon, 20 Nov 2006, Dave Snell wrote:

>
> --- Wallace Roberts Consulting <wrc...@gm...>
> wrote:
>
> > On 11/20/06, Dave Snell <bou...@ya...>
> > wrote:
> > ...
> > > "How are you supposed to issue refund checks with
> > SQL-Ledger?"
> >
> > Can you not write one out by hand?
> >
> > Obviously, I'm missing something here.
>
> Nope, I can't.  We use blank check laser stock for all
> of our checks.  Our bank will not clear any hand
> written checks.  Nor will they clear any check that
> prints with a negative dollar amount.  I guess I'm in
> the minority here - nobody else ever gives money back,
> or expects their accounting system to be able to do it
> for them.
>
> Dave

add an AP transaction and print the check

or you could subscribe to support and download v2.7

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

Re: [SL] Refund Checks

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

>> Can you not write one out by hand?
>>=20
>> Obviously, I'm missing something here.
>=20
> Nope, I can't.  We use blank check laser stock for all
> of our checks.  Our bank will not clear any hand
> written checks.  Nor will they clear any check that
> prints with a negative dollar amount.  I guess I'm in
> the minority here -  nobody else ever gives money back,
> or expects their accounting system to be able to do it
> for them.

I find there is another location where not being able to "print" a check =
causes more work - and that's in the "transfers" under cash.  We have one =
bank account that receives all of our credit card receipts.  It is not our =
"operating account" and is used only for credit card receipts.  About once =
a week we write a check from this account (it's in California) to our =
operating account (a different bank in Colorado).  Because "transfer" =
doesn't allow for "printing" a check, I must hand-write all transfers and =
enter them into the system.  Otherwise I would need to set up a "vendor" =
for my company and do an AP transaction.  While that's not the most =
complicated procedure I agree, I would prefer if the "transfer" screen had =
a way to print a check then and there.

Danita

Re: [SL] Refund Checks

[Jeff V. <jv...@ch...>]

On Mon, 2006-11-20 at 08:11 -0800, Dave Snell wrote:
> --- Wallace Roberts Consulting <wrc...@gm...>
> wrote:
> 
> > On 11/20/06, Dave Snell <bou...@ya...>
> > wrote:
> > ...
> > > "How are you supposed to issue refund checks with
> > SQL-Ledger?"
> > 
> > Can you not write one out by hand?
> > 
> > Obviously, I'm missing something here.
> 
> Nope, I can't.  We use blank check laser stock for all
> of our checks.  Our bank will not clear any hand
> written checks.  Nor will they clear any check that
> prints with a negative dollar amount.  I guess I'm in
> the minority here - nobody else ever gives money back,
> or expects their accounting system to be able to do it
> for them.
> 
> Dave

Maybe the simplest way would be to add an account for the refunds as an
expense/income offset account.  
Process the refund as a reduction of income and an increase in the
refund expense account.

Then write the check that reduces (pays) the refund (expense) account
and it should work properly.

Re: [SL] Adding notes without reposting

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

Wallace Roberts Consulting wrote:
> On 11/20/06, Kevin Bailey <kb...@fr...> wrote:
>   
>> Hi,
>>
>> Does anyone have any ideas RE how to add to the internal notes without
>> reposting the invoice?
>>
>> I would rather not repost any transactions as this may affect how they
>> are listed in the reconciliation screen.
>>     
>
> Well...
>
> I suppose you could sniff around in the database a bit, figure out
> which table contains that information, & update it ("update
> relevant_table set notes='notes go here' where key=1234567...").  Of
> course, before doing any of that, you'd want to shutdown SL access &
> backup the DB... just in case you didn't get it right. :-)
>
>   
Not that I condone doing it, but the fields in question here are 
AR.NOTES and AR.INTNOTES.  We add notes to our INTNOTES field to record 
payment history.  Each time a payment is received a trigger fires that 
records the date, time, user amount paid and % paid in the internal 
notes field.  Perhaps you could build a separate table with a trigger on 
it - each time a record was entered it could update & append your note 
to the corresponding invoice record. 

Dunc

Re: [SL] Refund Checks

[Dave S. <bou...@ya...>]

--- Wallace Roberts Consulting <wrc...@gm...>
wrote:

> On 11/20/06, Dave Snell <bou...@ya...>
> wrote:
> ...
> > "How are you supposed to issue refund checks with
> SQL-Ledger?"
> 
> Can you not write one out by hand?
> 
> Obviously, I'm missing something here.

Nope, I can't.  We use blank check laser stock for all
of our checks.  Our bank will not clear any hand
written checks.  Nor will they clear any check that
prints with a negative dollar amount.  I guess I'm in
the minority here - nobody else ever gives money back,
or expects their accounting system to be able to do it
for them.

Dave


 
____________________________________________________________________________________
Sponsored Link

$200,000 mortgage for $660/ mo - 
30/15 yr fixed, reduce debt - 
http://yahoo.ratemarketplace.com

Re: [SL] Refund Checks

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

On 11/20/06, Dave Snell <bou...@ya...> wrote:
...
> "How are you supposed to issue refund checks with SQL-Ledger?"

Can you not write one out by hand?

Obviously, I'm missing something here.
-- 
Best Regards,
Wallace

Re: [SL] Adding notes without reposting

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

On 11/20/06, Kevin Bailey <kb...@fr...> wrote:
> Hi,
>
> Does anyone have any ideas RE how to add to the internal notes without
> reposting the invoice?
>
> I would rather not repost any transactions as this may affect how they
> are listed in the reconciliation screen.

Well...

I suppose you could sniff around in the database a bit, figure out
which table contains that information, & update it ("update
relevant_table set notes='notes go here' where key=1234567...").  Of
course, before doing any of that, you'd want to shutdown SL access &
backup the DB... just in case you didn't get it right. :-)

-- 
Best Regards,
Wallace

Re: [SL] Refund Checks

[Dave S. <bou...@ya...>]

--- David J <ja...@in...> wrote:

> I have a slightly different take on this refund
> issue.
> IMHO there's NO problem with SQL-L, rather the way
> it is
> being used.
> Not meaning to offend, but perhaps PBKAC ?  :-)
> I can see quite a few ways to do this, depending on
> your
> setup.
> (I'm using British English, so menu syntax may vary
> slightly.)
> For example try Purchase, Add Transaction, Sundry
> creditors
> (or Refunds, or whatever you choose to setup) then
> select
> Bank account etc as usual. 
> Select the GL account that you wish to Debit. 
> (Might be
> Sales, Refunds, or again whatever you choose to
> setup.)
> Enter the details, amount, taxes (?), date, etc. 
> Alt-O to
> post and you're done.
> Alternatively, you could use General Ledger, Add
> transaction
> and enter your Dr's and Cr's as needed.  (Not my
> personal
> preference.)
> Or there's some Debit and Credit notes included in
> version
> 2.7.x that might suit your needs.
> If in doubt, ask your accountant what the particular
> procedure and Dr and Cr entries should be for your
> business.
> Hope this helps.
> - David J

The issue is not with the required GL transaction. 
That's the easy part.  The problem is that you can't
print a check from the Receipts screen - so there's no
means to issue a refund check.  Obviously, if we're
wiring money this doesn't apply, nor does it apply if
the customer used a credit card.  But when they
overpay or return goods that they purchased with a
check I need to issue a refund check.  My question
remains - "How are you supposed to issue refund checks
with SQL-Ledger?"

Dave




 
____________________________________________________________________________________
Sponsored Link

Don't quit your job - take classes online
www.Classesusa.com

[SL] Adding notes without reposting

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

Hi,

Does anyone have any ideas RE how to add to the internal notes without 
reposting the invoice?

I would rather not repost any transactions as this may affect how they 
are listed in the reconciliation screen.

Thanks,

Kevin

Re: [SL] Refund Checks

[David J <ja...@in...>]

I have a slightly different take on this refund issue.
IMHO there's NO problem with SQL-L, rather the way it is
being used.
Not meaning to offend, but perhaps PBKAC ?  :-)
I can see quite a few ways to do this, depending on your
setup.
(I'm using British English, so menu syntax may vary
slightly.)
For example try Purchase, Add Transaction, Sundry creditors
(or Refunds, or whatever you choose to setup) then select
Bank account etc as usual. 
Select the GL account that you wish to Debit.  (Might be
Sales, Refunds, or again whatever you choose to setup.)
Enter the details, amount, taxes (?), date, etc.  Alt-O to
post and you're done.
Alternatively, you could use General Ledger, Add transaction
and enter your Dr's and Cr's as needed.  (Not my personal
preference.)
Or there's some Debit and Credit notes included in version
2.7.x that might suit your needs.
If in doubt, ask your accountant what the particular
procedure and Dr and Cr entries should be for your business.
Hope this helps.
- David J

This is an example of SQL-L giving you all the power to
create your own system, that functions the way you want it
to work.  Not tying your hands and forcing a
one-size-fits-all solution.

> >
> > It occurs to me that refunds are negative amounts, yet
> > you copied the  template code where it was printing
> > numbers with the opposite sign?  A  refund in this case
> is just a negative payment of course. >
> > I guess hack the template to negate the sign - the
> > accounting treatment  should probably be fine though...?
> >
> > Out of curiousity did you just change the code to add
> > the template, or  did you use the "plugin architecture"
> to extend the code? He may be missing the boat but isn't
> the ability to issue a refund  something that is
> fundamentally missing from this application?  Has no  one
> here ever issued a refund check before?  Why isn't there a
> refund  template for such purposes?
> 
> Dunc
> ----------------------------------------------------------

Re: [SL] Refund Checks

[Paul T. <pt...@wa...>]

Paul Tammes schreef:
> In Europe we pay by bank or cash instead of cheque.
> Works like a charm and  reduces the number of lies allover (cheque is 
> in the mail, yeah sure!)
> As a last resort you might consider that way. Silly Europe for sure, 
> but if it works ;-)
>
> Also you might want to check and make sure that you have the accounts 
> payable ans accounts receivable the right way round.
OOPS, did not see the credit card part beforehand..
That changes matters considerably:
If I  return  an item, my credit card company refunds my money anyway. 
AND willl deduct it on YOUR next statement no doubt.
Now if you start writing me credit notes as well, I win big time! You 
return me the money, VISA returns me the money, life is wonderfull!
You just invented the free shopping mall principle?

Hth
Paul

Re: [SL] Refund Checks

[Paul T. <pt...@wa...>]

In Europe we pay by bank or cash instead of cheque.
Works like a charm and  reduces the number of lies allover (cheque is in 
the mail, yeah sure!)
As a last resort you might consider that way. Silly Europe for sure, but 
if it works ;-)

Also you might want to check and make sure that you have the accounts 
payable ans accounts receivable the right way round.
>>  use the "plugin architecture" to extend the code?
>>     
> He may be missing the boat but isn't the ability to issue a refund 
> something that is fundamentally missing from this application?  Has no 
> one here ever issued a refund check before?  Why isn't there a refund 
> template for such purposes?
>
> Dunc
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>
>   

[SL] Hot Keys on Firefox 2

[Penguin P. <pen...@gm...>]

Many Thanks David

 That sorted me out. Didn't have a clue about "about:config" but googled it
and got my self sorted and learnt something new into the bargain. Thank you
for taking the time to reply to my query

Tim

From: "David J" <ja...@in...>
Subject: Re: [SL] Hot Keys on Firefox 2
To: sql...@li...
Message-ID: <455...@in...>
Content-Type: text/plain; charset="iso-8859-1"

Tim
This is really a browser issue, rather than SQL-L (although
I do understand why you choose to post here).
This issue has been discussed (thrashed ?) in the Firefox
forums.
The best info I can find for you is here.
http://forums.mozillazine.org/viewtopic.php?t=446830&postdays=0&postorder=asc&postsperpage=50&start=0
Hope it helps you get it sorted.
Presume you know how to use about:config in Firefox.
Cheers
- David J

> Hi
>
> I recently upgraded to Firefox 2.0 and have found that the
> Hot Keys ie. Alt-I, Alt-u or Alt-s etc now dont work  on
> Sql-Ledger. If I put the Cursor over the relevant button
> it still shows the Hot Key Alternative but it is not
> active. Is there something I need to activate on firefox
> to allow me to use the hot keys? I realise I most probably
> am missing something obvious but cant seem to see it.
>
> Many Thanks
> Tim

Re: [SL] Refund Checks

[Steve R. <roy...@co...>]

hi

On a similar thread to refunds, I have the following two invoices
the second ordered as part of the first service.  But both of these
show up in "AR Outstanding" report.

Date        Invoice    Total    Paid
05-07-2006  3775       88.00    100.00
25-07-2006  3784      170.50    158.50
                       258.50    258.50


So what is the proper way of doing this

Steve

Re: [SL] Refund Checks

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

Ed W wrote:
> Hi
>
>   
>> So I'm
>> printing checks with negative signs in them. 
>> Obviously I'm doing things wrong - there's no way
>> nobody is issuing refund checks and certainly nobody
>> is giving out checks with negative payments.  Right?
>>   
>>     
>
>
> It occurs to me that refunds are negative amounts, yet you copied the 
> template code where it was printing numbers with the opposite sign?  A 
> refund in this case is just a negative payment of course.
>
> I guess hack the template to negate the sign - the accounting treatment 
> should probably be fine though...?
>
> Out of curiousity did you just change the code to add the template, or 
> did you use the "plugin architecture" to extend the code?
He may be missing the boat but isn't the ability to issue a refund 
something that is fundamentally missing from this application?  Has no 
one here ever issued a refund check before?  Why isn't there a refund 
template for such purposes?

Dunc

Re: [SL] SQL Version 2.6.19 has been acting up since the last upgrade. We have to keep inputting our password all the time.

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

Stroller wrote:
> On 17 Nov 2006, at 20:41, Tom Diehl wrote:
>   
>> On Thu, 16 Nov 2006, Dave Snell wrote:
>>     
>>> I've noticed since going to to 2.6.19 that there have
>>> been some timeout issues too.  Many days I'll logon
>>> and then immediatly be presented with a timeout /
>>> please logon screen. ...
>>>       
>> You are not the only one. Sometimes it gets into a loop and asks for
>> the passwd everytime I try to get another screen. logging into
>> BOTH the meny frame and the main frame seems to satisfy it.
>>     
>
> I had this upon upgrading to 2.16.19, too.
>
>   
>> ...The timeout is set for
>> 9999999999999999999 and the browser is firefox.
>>     
>
> I seem to recall that I too had a silly timeout figure. It was either  
> 99999999999999 or 0 - setting it to comething like 3600 (in admin.pl  
>  > username) resolved the issue for me.
>   
My users are all either set to 14400 or 28800 - depending upon their job 
functions.  All of my users have complained about the "immediate 
relogin" issue since going to 2.6.19.

dunc

Re: [SL] choosing fonts on invoice

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

On 17 Nov 2006, at 03:24, William Hamilton wrote:

> How can I choose which font appears in the heading of LaTeX  
> invoices?  A
> client would like to use their corporate standard "Century Gothic"  
> in the
> letterhead.

The best answer I can give you is to take a look at The LaTeX Font  
Catalogue [1] - I don't know whether there are any fonts in the CTAN  
repository [2] that aren't listed there.

I have tried converting TrueType fonts for use with LaTeX, but the  
results were VERY unsatisfactory - I am sure I followed the  
instructions (I found several guides on the web) to the letter, but I  
think the problem is that the kerning / hinting / font-whatever isn't  
converted properly.

AFAICT LaTeX is very successful at "printing beautiful documents" if  
you use a font that has been designed (or at least well-prepared by  
hand) for it. I don't know much about font names & foundries, but I  
suspect you might find that the exact font your customer use is not  
already available in a TeX format. From the sounds of it you will do  
well with Avantgarde, however. The Font Catalogue says that "the font  
that is actually provided is URW Gothic (An Avantgarde clone)" and  
when I look Century Gothic up on Wikipedia [4] I find that it "takes  
inspiration from Sol Hess's Twentieth Century typeface drawn ... as a  
version of the successful Futura typeface [but] is more closely  
related to Avant Garde Gothic".

IE: I don't think you should tell your customer that you're not using  
"their font", because you are likely to be able to choose a font  
indistinguishable.

If you choose AvantGarde then I think you'll find that it's part of  
the Adobe core fonts installed with your LaTeX system. Otherwise try  
the avantgar package at CTAN [5]. So you should just be able to  
compile & view avantgarde.tex [6] on your system & Bob's your  
mother's brother.

The Font Catalogue always gives the package name for a font in its  
page's "usage" section. I think you'll nearly always be able to find  
that package at CTAN. I find installing packages from CTAN non- 
intuitive, and it's annoying that my distro's package-manager  
includes some CTAN packages, but not many others. Consequently I used  
my distro's package-manager to install the MiKTeX package manager (on  
Gentoo: `emerge mpm`); thereafter one can search for packages using  
`mpm --list | grep packagename`; `mpm --install packagename`.

You then have to tell various utilities where to find the new  
font's .map files. I could write a deal more about this, but it would  
take me forever because I don't yet understand it all fully myself -  
my two pieces of advice are to look in your system's updmap.cfg (/var/ 
lib/texmf/web2c/updmap.cfg here) and run rubber on the "LATEX source  
of PDF sample" of your chosen font taken from the Font Catalogue.  
When dvipdf spits about missing fonts I run `updatedb && locate  
whatitsbitchingabout` and this usually allows me to find the .map  
file to add to updmap.cfg. You will need to run `updmap-sys` and  
`texhash` at some point.

I am a complete n00b at LaTeX, and only started using it for the  
first time perhpaps 10 days ago, specifically to layout invoices for  
SL. The .tex samples from the font catalogue will give you the basic  
usage, I think, enough to get you going on any particular font, and  
you should always compile this sample on your own system before  
integrating into your invoice.tex. This is what the comp.text.tex  
newsgroup calls a "minimal example" and when you have problems in  
LaTeX creating a minimal example seems to be particularly helpful.

I've been long enamoured of Verdana - I think it's a very clean font,  
and I like its spacing - but in LaTeX I'm finding Arev (a very  
closely related font) to be just as pleasing (certainly far more  
pleasing than was my attempt to convert Verdana to Type1!!). I also  
use the "hand-written" Augie on my invoices, using it to indicate to  
my customers the implications of <%itemnote%>  & <%notes%>; it too  
works VERY well. I would not be ashamed to send you one of my invoices.

The file you need to edit to change the design of your Postscript /  
PDF invoice is "/usr/local/sql-ledger/templates/Stroller/ 
invoice.tex". You mention that it is the font of the letterhead that  
you're interested in & by default invoice.tex uses an include or  
import statement to pull in letterhead.tex (in the same directory).

I'm sorry I can't direct you better, however (it is late and) I have  
tried to brainstorm all the things I wish I'd known a week or 10 days  
ago. The comp.text.tex newsgroup is very helpful.

Stroller.



[1] http://www.tug.dk/FontCatalogue/
[2] http://www.ctan.org/
[3] http://www.tug.dk/FontCatalogue/avantgarde/index.html
[4] http://en.wikipedia.org/wiki/Century_Gothic
[5] http://www.ctan.org/tex-archive/fonts/psfonts/corelpak/avantgar/
[6] http://www.tug.dk/FontCatalogue/avantgarde/avantgarde.tex
[7] http://www.tug.dk/FontCatalogue/arev/index.html
[8] http://www.tug.dk/FontCatalogue/augie/index.html