Defining return transaction prompts

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.

To define return transaction prompts:

  1. Select Administration > Data Collection > Monitor Interface.
  2. Open the Transaction Type form.
  3. Select the transaction type for which to define return prompts, and then click the Return Prompts tab.
  4. Click Add Return Prompt.
  5. 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. The system automatically populates the source prompt description.
    Target Prompt
    Enter the number corresponding to the target prompt sequence number that receives the default value. The system automatically populates the target prompt description.
    Note:  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.
  6. Click Submit.