search for vendor bills paid in full because a credit memo has been applied

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that there isn't a straightforward way in NetSuite to show a list of vendor bills that are paid in full because a credit memo has been applied. However, there are a few workarounds that you can consider: 1. Include Paying Transaction: Type in your search: This method involves including the 'Paying Transaction : Type' in your search and then grouping your search to deal with multiple entries. 2. Use Applied To/Applied From in the Saved Search: This method involves using the 'Applied To'/'Applied From' fields in the saved search. However, this might multiply the results and if the goal is to show a YES/NO in a list, it might be tricky. 3. Use a Script or Scheduled Workflow: This method involves using a script or scheduled workflow to update the bill if it was paid in full by a credit memo and set some body level checkbox. This way, you can search off of it. 4. Use a Complex Formula in Saved Search: This method involves creating a formula that writes NO/YES starting from applied transactions. This does not multiply data nor require a script. Remember, these are workarounds and might not work perfectly in all scenarios. It's always a good idea to test these methods thoroughly before implementing them. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******