How do I populate a custom field on a check payment form with the vendor balance of the vendor that is selected on the form? Is there a way to do this with sourcing or seach?

AI generated answer (using internal Slack threads):

To populate a custom field on a check payment form with the vendor balance of the vendor that is selected on the form, you can use a combination of a saved search and a custom field. Here are the steps: 1. Create a summary saved search that calculates the vendor balance. Make sure to include the vendor as a filter in the search so that it returns the balance for the specific vendor. 2. Create a custom field on the check payment form. In the sourcing and filtering section of the custom field definition, select the saved search you created in step 1 as the source. 3. Make sure to check the 'Store Value' option on the custom field. This will ensure that the value is stored and displayed on the form even if the vendor balance changes after the form is saved. Please note that the custom field will only display the vendor balance at the time the form is saved. If the vendor balance changes after the form is saved, the custom field will not update to reflect the new balance. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******