PO Numbers

[mantsop]

Hello and Happy New Year's!

Under Asset contracts -> Purchase Orders, is there any way to bring up a Purchase order and see what computers are under that PO? We are entering PO numbers for our desktops and laptops but have no way of looking at the entire PO. Any help is appretiated.

thank you

[brad_hicks]

You will need to create a new relationship under System Definition -> Relationships. Give it a name that you would like to see it called as a related list within your Purchase Order form. In my example I just called it PO Computers. Then, choose the Purchase Order table in the "Applies to table" field and choose the Computer table in the "Queries from table" field. Leave the Advanced field unchecked. In the script field, put the following:

current.addQuery('po_number', parent.number);

Once you have created the relationship, you can then go to the Purchase Order form and right-click to choose Personalize -> Related lists. On the left-hand side of the slushbucket you will see the new relationship that you created. Just move it to the right hand side and choose to save. You should now see within the related list a list of computers that have the same purchase order number as the current record.

[mantsop]

this is awesome. Works like a charm. Thanks for your help!