I have been tasked to provide a warning to users if they attempt to create a Purchase Order line/blanket line/Blanket Release for an item that has D1-4426 processor flow-downs
Since a PO can be generated via four different methods (firm from Planning Detail, generate from material planner workbench, generate from Purchase Order Lines/Blanket Lines/Blanket Releases, or generate from Job Materials as a xref purchase order) I need some kind of flag that the Form Script can reference from any of those locations.
Currently, I want it to be based on the presence of a System/User Note applied against the item record for the purchased item. The Note Subject will be "D1-4426%" (where the first seven characters are always D1-4426), which allows my purchasing manager to add new notes over time depending on what specific process applies to a particular purchased item.
So I'm thinking I could create a custom view that associates an Item to a boolean variable that recognizes if one or more D1-4426 notes are present on the item record, then have that view populate a hidden derived field on those four forms so when operators take actions related to generating purchase orders, the warning event can trigger.
My fear is, I'm making this too complicated. Anybody else ever have to warn users for some reason at PO Line/Release generation that has a better idea?