Hi Walter,
Ledger does not have any knowledge of firstname vs lastname, this is a
function of the way your company has entered data.
Fortunately some forethought has been used, and the "company name"
stores the information in lastname/firstname order while the "contact"
field contains the information in the opposite order.
This means that the solution (for you) is simple....
In the template where it has <%name%> you will need to replace it with
<%contact%>
Be aware that if the contact field for a particular customer is empty,
you will not have a name on the check :(
Mind you, I suspect that an empty contact field will cause other things
to be a problem too.
BTW: It is possible that the latest version of SQL Ledger does have
firstname/lastname fields but I have not seen any recent versions so I
can't comment further there.
Regards
David Godfrey
Walter Zamora wrote:
Rich:
Thank you for your prompt response.
I check the templates, but only a field "name" is in them, no last or
first. As a mater of fact, the tables customer and vendor only have a
column for name, not first and last. When looking into reports for AR
or AP, the customer/vendor is also listed as lastname firstname.
Any other thoughts?
Walter
-----Original Message-----
*From*: Rich Shepard <[email protected]
<mailto:rich%20shepard%20%[email protected]%3e>>
*Reply-to*: SQL-Ledger Users <[email protected]>
*To*: SQL-Ledger Users <[email protected]
<mailto:sql-ledger%20users%20%[email protected]%3e>>
*Subject*: [SQL-Ledger] Re: name order in check or invoice printing
*Date*: Tue, 25 May 2010 10:55:46 -0700 (PDT)
On Tue, 25 May 2010, Walter Zamora wrote:
I am trying to start using the print function for checks but SL writes
lastname firstname, I need it to write firstname lastname. In the tables
vendor and customer, it shows lastname firstname as customer or vendor,
but it shows firstname lastname as contact. Could someone please tell me
where this is configured?
Walter,
Take a look at the LaTeX code in your templates directory (check.tex).
Switch the sequence of the two fields in the template and you'll get the
printing the way you want. You can also use \hspace and \vspace to adjust
the position of text on the check.
Rich
_______________________________________________
SQL-Ledger mailing list
[email protected] <mailto:[email protected]>
http://lists.ledger123.com/mailman/listinfo/sql-ledger
------------------------------------------------------------------------
_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger
_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger
