why is the amount remaining doubling for a purchase order saved search that is summed for a vendor bill and what can we do to fix it

AI generated answer (using internal Slack threads):

The doubling of the amount remaining in a purchase order saved search that is summed for a vendor bill could be due to the way the saved search is set up. If the saved search is set to sum the amounts of the vendor bills, it might be including both the original bill and any subsequent bills, causing the total to be doubled. To fix this, you could adjust the criteria of the saved search to only include the original bill amount in the sum. This could be done by adding a condition to the saved search to exclude any bills that are not the original bill. Alternatively, you could modify the saved search to use a different field that accurately reflects the remaining amount on the purchase order. For example, you could use the 'amount remaining' field instead of summing the bill amounts. Another possible solution is to create a custom field that calculates the correct remaining amount and use this field in your saved search. This field could be calculated as the original purchase order amount minus the sum of the vendor bills. Remember to test your changes thoroughly to ensure they produce the expected results. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******