Modify the query of getting data for the serial field in Valid Tickets and change it to LEFT(C.xml_data_value,1) then regenerate the XML file to refresh the data and check if the serial field now correct