Asset Management Suite

 View Only

Report POs with Serial Number of Assets Received 

May 21, 2008 11:52 AM

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

Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Comments

May 22, 2008 03:36 PM

....back in August 2007. My team was stumped on how to generate all of the necessary information on 1 report. I am happy to have this tool for future use, probably in the next few weeks. I'll let you know how it turns out or if I run into any snags along the way. I appreciate the knowledge-share.

Related Entries and Links

No Related Resource entered.