Scripting

Does anyone have an idea about how to trap cost increases caused by a receipt of invoice (or goods)? Column events are not triggered in RoG or RoI when selecting an existing purchase order. Also, no event is triggered when cost fields in CI_Item are modified during the register update. The only idea I can come up with is to save the cost to a CI_Item UDF when either the UI changes cost directly in CI_Item AND when ever a receipt line is deleted due to a register update, but only when the cost is greater than the current UDF. In that way, I have the UDF to compare against to see if the price has changed when a receipt line is deleted. Yuk! There must be a better way. Ehhh - I just realized that if the entire receipt line isn't received, then I won't see the line delete event. Double Yuk!

Would that be a good use of knowledgesync?

Thanks! I'll mention that to the reseller; however I sell scripts, no Knowledgesync.

CI_Item has a field for Last Cost. Could you pass CI Item.Last Cost to the PO Receipt, then evaluate as the PO Receipt line is deleted?

I like the way you think @MichaelNottoli. It turns out that there are detail post write events in RoG and RoI when the PO is brought in. Just no column events. I can work with that.