What's everyone doing for their ticket headers in V11? Noticed today that households print the household name (ie, Tom Jones Household) for the data element "Customer Name1". Are you using Salutation here?
We also switched over to sort name, which worked great for just the name, but not on our custom ticket header.
On our custom one - we replace the first name line with a name in the notes area after a certain character string - so that we may be able to do a pick up under a different name. Previously it was pulling last and first names separately but with sort name it is a combined field - so the special code we have is getting lost.
And I just can't see the solution - I am having a serious case of the 'Mondays' :-)
if @ude_no = 1 and @design_type = 'H'
begin
-- declare @notes varchar(255)
select @notes = ord.notes
from t_order ord
where ord.order_no = @order_no
if substring(@notes, 1, 2) = 'xx'
declare @end int
select @end = charindex(';', @notes) - 3
if @end <= 0
select @end = 30
select @ude_value = substring(@notes, 3, @end)
end
else begin
select @cust_type = cust_type from t_customer where customer_no = @customer_no
if @cust_type in (1, 6, 11)
select @fname = isnull(fname, fname2),
@lname = isnull(lname, lname2)
from t_customer where customer_no = @customer_no
select @fname = isnull(fname2, fname),
@lname = isnull(lname2, lname)
select @ude_value = rtrim(@lname) + ', ' + rtrim(@fname)
------------------------------------------------------------------------------------
if @ude_no = 4 and @design_type = 'H'
select @ude_value = ''