We are trying to link hardware assets to associated purchase orders. We want to open a hardware asset, access the Purchases tab and see the linked purchase order.
We have input the hardware assets into FNMS using a business adapter. We have also put some test purchase orders into FNMS using a business adapter. We are now trying to use the "Link Purchase Order Line - Asset" object in a business adapter to link the appropriate asset to PO. However, we have not been successful in linking the asset to purchase order using this object.
Is there a way to use a Business Adapter to link hardware assets to purchase orders since we have thousands of assets to link to purchase orders?
Apr 13, 2020 03:45 PM
See attached screen shot. This is what you should be seeing when Asset is in front of "Link PO Line to Asset"
Apr 15, 2020 01:16 PM
A Hardware Asset is linked to a Purchase Order Line - not a purchase order.
So your data source needs to have fields to match and find a Hardware Asset (typically the Serial Number) and fields to match and find a PO Line (Typically the PO Number and the Line Number).
You can then link the asset to the PO Line.
Apr 13, 2020 04:25 PM
Hi kclausen:
Thanks so much! I will work to identify the appropriate PO line number and link there.
Thanks,
Darryl Stracner
Flexera FNMS and Data Platform
Apr 14, 2020 07:37 AM - last edited on Apr 14, 2020 08:03 AM by KPBussey
I have created a Business Adapter and attempted to link Purchase Order Line to the Asset Serial Number. Adapter is now Completing with Errors. I am getting a rejection message:
"Field Serial Number has unrecognized integer value; "
I've attached the log.
Would greatly appreciate suggestions.
Apr 14, 2020 01:11 PM
Can you test your adapter with dummy values limiting to a single line item import? This will rule out a data specific and perhaps formatting issue. From the error it seems a little hard to isolate on the surface so my suggestion is to get you to the fastest route to a fix.
BTW this can be done the trick is the relationship 99% of the time.
Apr 14, 2020 08:49 PM
Will give that a try. Thanks so much!
Thanks,
Darryl Stracner
Flexera FNMS and Data Platform
Apr 15, 2020 07:45 AM - last edited on Apr 15, 2020 08:10 AM by KPBussey
I have tried the "Link Purchase Order Line - Asset" object with both existing assets & PO Lines within FNMS and while importing new assets and new PO Lines in the same Business Adapter at the same time trying to link.
1. Will the "Link Purchase Order Line - Asset" object link data (Asset & PO Line) already in FNMS?
Where I seem to be held up now is at the "Asset ID" node of the "Link Purchase Order Line - Asset" object. I have tried the object both above and below the Asset and PO Line object. I keep getting a "Field Serial number has unrecognized integer value;" when choosing Serial number to match in the "Asset ID" node.
2. Should the "Link Purchase Order Line - Asset" object be above or below Asset object?
3. What should my Value choice be for "Asset ID" node?
Apr 15, 2020 12:43 PM
Yes, the Asset object needs to be placed before the Asset-->PO Line object.
For the Asset object, since your input file as the Asset Serial Number, then you need to match to the Serial Nbr field within the Asset object.
Then, in the Asset--PO Line object for the AssetID, from the drop down select Asset_AD (not anything from your input file)
Apr 15, 2020 12:51 PM
Apr 15, 2020 01:08 PM
Apr 15, 2020 01:25 PM