Advanced Retail (UK) Ltd
Company Wiki

–Searches all suppliers with name
Select TOP 10 * from transactor where company_name LIKE '%%'

–Search for PO using supplier guid's
Select * from [dbo].[purchaseorder_create_hdr] where guid_supp = ''
Order By datetime_created desc

–Update “Craete_State” to 1 where currently set to 3 which states void
update purchaseorder_create_hdr set create_state = 1 where row_id = ?