Question on Forms Personalization for PO Form
591060Aug 1 2007 — edited Aug 2 2007Hello All,
I'm looking for some advice on implmenting Forms Personalization on the Purcahse Order form.
The business case is this: We have a custom field in the item master (MTL_SYSTEM_ITEMS) called 'NCNR' (the field is ATTRIBUTE9.) It means that the item is non-cancellable or non-returnable once ordered. When a buyer creates a PO for an item with NCNR = Yes, I want a message box to pop up telling them that it is an NCNR part.
I want to use Forms Personalization for this but I'm not exactly sure how to write the condition. I'm thinking it should be somthing like this:
Trigger Event: WHEN-VALIDATE-RECORD
Trigger Object: PO_LINES
Condition: :'YES' = (select ATTRIBUTE9 from MTL_SYSTEM_ITEMS where SEGMENT1 LIKE PO_LINES.ITEM_NUMBER)
This condition doesn't work... Can anybody give me some idea how the condition should look in order to check the contents of my cutoms field in the item master?
Any advice or insight would be greatly appreciated.
Many thanks,
Mark