Have you ever wanted to generate a report of purchase orders and the serial numbers of the assets created by those purchase orders? Here you go:
/*List PO, Receiving Slip Number and the Assets that were created when receiving process is used. Software items are not reported. */ select j.name as 'PO', j.Description, i.name as 'Receiving Slip', k.name as 'Asset', va.[Serial Number], va.[Asset Type], va.* /* Remove the two dashes at the beginning of the next line of code to get more detail on the PO and Receiving slip. */ --, rec.*, li.*, i.*, k.*, j.* -- more detail from inv_parent_lines rec join item i on rec.[_resourceguid] = i.[guid]-- Receiving slip join Inv_Line_Items li on rec.[parent line item id]=li.[line item id] -- PO join item j on li.[_resourceguid] = j.guid join vReceivingSlipAssoResource rs on i.guid = rs.parentresourceguid join item k on k.guid = rs.childresourceguid -- Asset join vAsset va on rs.ChildResourceGuid = va._ResourceGuid join vItem vi on vi.Guid = va._ResourceGuid