Automatically derivation of value set value in a Requisition Header DFF
Is it possible to create a table-type value set that will automatically populate the supplier payment terms when creating a Purchase Requisition?
Requirement:
Create a value set for a Descriptive Flexfield (DFF) field — Supplier Payment Terms — which should default to the payment terms defined at the supplier site level. When a Purchase Requisition is created, the DFF should automatically display the payment terms associated with the selected supplier site.
I created a value set and updated the FROM clause and WHERE clause parameters; however, it is displaying a list of values instead of defaulting the value automatically.
FORM Clause - POZ_SUPPLIERS_V psv,POZ_SUPPLIER_SITES_V pssv,AP_TERMS_VL atv