Ticket Headers

I thought we where using salutations but it looks like we have made the same mistake!!  We will have to use customer salutations going forward

Yep, we've switched to Salutation1 from Customer Name1 due to the 'Household' issue as well.

- Heather

I'm finding that the our standard Header/Envelope seems to have a character limitation of 28.

For instance, in my first test print the header for my order printed, as many have found out, the Household name:
Christopher and Rachel Short (Household)

However, the Salutation has 33 characters, which would make for an awkward looking header that would read:
Mr. and Mrs. Christopher L. (Short)

Items in parentheses do not print on the header.

We're also finding this problematic in our general ticket design as we have previously printed LastName1 on the tickets and that is also pulling the household name rather than the Last Name.  The salutation wouldn't really work here as we were hoping to save some real estate.  Does anyone else employ these items in their ticket designs?

Thanks!
Short

Hi Chris,

We've run into the same issue with Lname1 on the Ticket.  And since we don't have the real estate to print the full salutation, I had hoped to find a new canned element for 'Sort Name'.  Unfortunately, that doesn't exist so we have allocated one of our precious UDEs to get the portion of sort_name before the '\'

We had the same issue too. Info here was very helpful. Thanks :)

We used following to get sort name into one of the user defined ticket elements:

   select @ude_value = sort_name

   from T_CUSTOMER

   where customer_no = @customer_no

Thats the last of our user defined elements used up.

Would be great if the sort_name could be added to the standatd list of elements.

ta, Dara

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'

      begin

            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)

      begin

            select      @fname = isnull(fname, fname2),

                  @lname = isnull(lname, lname2)

            from t_customer where customer_no = @customer_no

      end

      else begin

            select      @fname = isnull(fname2, fname),

                  @lname = isnull(lname2, lname)

            from t_customer where customer_no = @customer_no

      end

      select @ude_value = rtrim(@lname) + ', ' + rtrim(@fname)

      end

end

------------------------------------------------------------------------------------

if @ude_no = 4 and @design_type = 'H'

begin

      select @notes = ord.notes

      from t_order ord

      where ord.order_no = @order_no

        select @ude_value = ''

      if substring(@notes, 1, 2) = 'xx'

      begin

            select @cust_type = cust_type from t_customer where customer_no = @customer_no

            if @cust_type in (1, 6, 11)

            begin

                    select    @fname = isnull(fname, fname2),

                            @lname = isnull(lname, lname2)

                    from t_customer where customer_no = @customer_no

            end

            else begin

                    select    @fname = isnull(fname2, fname),

                            @lname = isnull(lname2, lname)

                    from t_customer where customer_no = @customer_no

            end

            select @ude_value = rtrim(@lname) + ', ' + rtrim(@fname)

      end