Hi,
We receive quite a few vendor emails where we have had to raise tickets on our customers behalf, instead of them going into the 0 account, ideally I would like them to go into the ticket that we have on our system.
I though that if we had a UDF called something like “Vendor Ticket Ref” and the engineer put the reference of the third part ticket into it, MSP could search the UDF to see if there is a match.
I could obviously do a query for each vendor specifically but we deal with so many it would be huge.
Perhaps a query that would extract any number in the subject greater than 5 digits and search the UDF for that number?
Any ideas appreciated.