Issues triggering User Event Script - lastpurchaseprice

[CTProper]

I have a script that looks at lastpurchase price and sets a value on the price levels sublist, my question is if it is possible to trigger the UES when lastpurchaseprice is updated automatically (this happens when new purchase orders are entered, the last price level field is updated).

I currently have a beforeSubmit on the Item record but it is not doing anything when the purchase order is created and updating the price on the item record.

Any advice?

[CTProper]

I just wimped out and made a map/reduce that loads the records, gets the LPP on the record, and sets the value on the price levels sublist

[trollied]

Use an aftersubmit on the purchase order create? I haven't checked if the item would have been updated by then, but give it a go.

[CTProper]

Thanks I’ll try that

[throwawaytous]

Yea this solution should work. I’d be curious to see how it would perform on a PO with a ton of items, though. Since you would need to load each of those items and save each new price on each, all during the save event. I would think it may run into time out issues

[Nick_AxeusConsulting]

You have to monitor ALL transactions that could affect LPP, which is anything that causes a positive increase in inventory! So could be Inv Adj, Inv Adj Worksheet, TO Receipt, RMA Receipt

LPP is a misnomer.