Hello all,
I wondered if anyone had any experience of displaying CSI information on a ticket or receipt? I'm new to the whole ticket design process and am looking for a bit of guidance on if this is possible or whether I need to look to find an alternative method.
Many thanks
Jamie
Hi Jamie
If you have access to SQL skills, you can put pretty much anything you like on a ticket, really, so long as it fits into the 30-character limit of a ticket element.
There is a localisable stored procedure , [LP_TICKET_ELEMENTS] which will let you define up to six elements that you can place onto tickets, based on a variety of values, like the customer_no, or the order _no.
Takes a bit of investigation and some knowledge of Tess data structures to find your data in the CSI tables, as well as some possibly creative SQL, but you should be able to pull the data that you want. There is some sample code included in the proc to get you going.
Ken
Hi Ken,
Thanks for this, it helped point me in the right direction. I experimented with some new ticket design and how to display some of the information.
I think we may now be heading in a different direction, but it's always good to understand this for the future.
Regards