Define return prompts to create default values for specific prompts. For example, if creating an inter-warehouse transfer issue with a prompt for requisition number, requisition line, and outstanding quantity, set up a trigger to search and automatically populate outstanding quantity with a value. Define triggers using SQL statements.
-
Select Administration > Data Collection > Monitor Interface.
-
Open the Transaction Type form.
-
Select the transaction type for which to define return prompts, and then click the Return Prompts tab.
-
Click Add Return Prompt.
-
Specify this information:
Source Prompt - Enter the number corresponding to the prompt sequence number that triggers the return prompt when you leave or tab out of the field.
Target Prompt - Enter the number corresponding to the target prompt sequence number that receives the default value.
Target Prompt must be greater than Source Prompt.
Query Code - Enter the code identifying the SQL statement that calculates the default value for the target prompt. The system automatically populates SQL Statement.
-
Click Submit.