Vista Customization Example: Restrict PO Expense GL Accounts

Scenario: Looking to restrict the valid expense accounts during PO entry to specific accounts.

Example Solution:

  1. Add a custom validation in UD User Validation
  2. In the SQL tab, insert the code found here. Customize code to use your list of acceptable accounts.
  3. Press the compile button.
  4. In PO Purchase Order Entry, Press F3 on the GL Account field.
  5.  In the System Overrides tab, set Validation level to 2-Show error, disallow save or your choice.
  6. In the Procedure field find the custom validation you created.
  7. In the parameters field, input 115, 155 to pass the linetype and GL Account to the validation.
  8. Test the validation in a test environment to make sure if functions as expected.

Leave a Reply

Your email address will not be published. Required fields are marked *