I'm trying to do some scripting to recreate the FAM record creation process, but I can't tell how Asset Proposal manages to fill the Original Cost (custrecord_propassetcost) field. Where does this value come from?
Is it simply taking the average cost of the item?
I've tried searching through the various instances of custrecord_propassetcost in the scripts of the bundle, but that gave me no insight.
If I receive the items from a vendor, I get that it has a value on that PO, Item Receipt or Payment. But if I create a transfer order to move those inventory items to another location I can then generate an Asset Proposal from that transfer order on which the items will have no reference back to the original PO, so how does it still know the Original Cost for the items? I can only assume it's coming through the GL impact, or is it something else?
And if it is the GL impact, then is there a way to identify which item is which? As the GL impact could show 5 different lines all for the same type of assets but different items when none of those 5 lines mention which item they belong to. I'd test it myself but I'm not even sure how to join in a script from the Item Receipt to the GL impact, anyone know how to do this?
The items on the item receipt
Manage proposals page showing the Original Cost of the suggested Asset
GL Impact of the IF showing the similar items of the same asset type.
Appreciate your insights on this!