From Purchase Order to Asset Table

[alexcharleswort]

Hey friends. So we are trying to roll out asset management, one baby step at a time. One of our hurdles right now is that our AP dept. reports on assets that are deemed "capital". My goal here is to add a "capital" true/false on the line item request:

and then have a capital true/false column to show up on the table where all the assets are going. I am not sure how to get that value onto the all asset table.

I know that the values on the all asset table are being pulled both from the purchase order form and the purchase order line item form.

my capital variable details are as follows:

Any ideas on how to get this variable from the form to the All Asset table?

Thanks for your help in advance!!

[Pradeep Sharma]

Hi Alex,

If I understand your question correctly, I think you can use dot-walking to get the field on the form from the reference table.

Dot-Walking - ServiceNow Wiki

[alexcharleswort · Accepted solution]

Yeah, I knew I needed to dot-walk but the issues I was having was following the trail. None of the combos I tried worked so I found a work around. I just ran the report I needed to off of the line item table and the parent table.