search if bill has applied payment to the whole bill but show per item

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that the user is trying to create a saved search for bill payments and wants to include the account/item from the associated bill. However, they are having trouble retrieving this information. One suggestion provided was to remove the criteria that limits the search to Bill Payment records. This could potentially allow the bill information to be displayed. However, the user reported that removing the criteria did not change the output. Another user suggested creating a search from the Vendor Bill instead of the Bill Payment and then linking to the applying transaction of the Bill Payment. This is because the item information is a separate sublist on the record and the bill payment is only "applied" to the header information (AP account), which leads to a multiple join limitation. In another thread, a user found a solution by searching bills by the paying transaction. They also mentioned that using the applying transaction worked even better. In a different scenario, a user wanted to show which vendor bills are paid in full because a credit memo has been applied. A solution was found by creating a complex formula in a saved search that writes NO/YES based on applied transactions. This solution did not multiply data nor require a script. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******