On Wed, 26 May 2010, David Godfrey wrote:
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 :(
Could that not be solved with an if statement?
<%if contact%><%contact%><%end contact%>
<%if not contact%><%name%><%end contact%>
There may be an else syntax which would make that simpler, and it's been a
while since I've been aware of the proper SL syntax for this sort of
thing, but maybe something like that will work.
Luke
_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger
