Association between Purchase Orders and Software Licenses
Updated: 22 May 2010 | 2 comments
Dear All,
I am trying to make a report of Software Licences and Purchase Orders and I cannot find the link between them so that I can make a report!
I know that Software Purchases are Resources and they are associated with Software Licenses via the Resource Association table, but I cannot find any table that links Software Purchases to Purchase Orders!!! 
Does anyone have any ideas?
Regards,
QuietLeni
discussion Filed Under:
Comments
Hi,
Are you on Asset v6.5? If so, the purchase orders are linked to Software Purchases in the Cost Items dataclass - have a look at it on the UI, and you should see the column 'Purchase Order' in the cost items dataclass on the accounting tab.
When you look in the database, in the Inv_Cost_Items table, you will get the GUID of the purchase order.
hth,
Hilary
Thanks for the reply, Hilary.
Yes, I have found the same and I can see it in the GUI, but I cannot (currently) find a query to link the Software Purchase to the Purchase Orders.
Regards,
QuietLeni
I stand by the accuracy of my Inventory of the organisation. Don't blame me for the picture that it presents...
Would you like to reply?
Login or Register to post your comment.