Hi. Is it possible to connect fully applied bill credits to bill payments? It seems to me that it is not possible as these bill credits are only connected to bills and not bill payments (Bills > Related Records > Full Amount is applied against credits, no Bill Payments) . However, I'm wondering how come the Bill Payments and its related standard payment voucher shows all these details including the bills and the fully applied bill credits (the Bill Payment was used to fully apply these credits) but these cannot be pulled to a report or saved search?
I initially created a bill saved search wherein it shows all the applying transactions related to that bill. It is showing both bill payments and bill credits but I could not reference or filter a Bill Payment to show everything that has been applied for that Bill Payment/Check alone. When I do that, fully applied bill credits do not show up. Basically, I need the info per payment voucher. It's weird if it cannot be pulled via report but the system can do it in a payment voucher or in the UI. I also tried using Datasets and Workbook but I don't think it works also as there is no way I can group the data by Bill Payment Number considering the same issue above. The credits isn't just connected to the bill payments.
Any ideas or anyone who have tried any workarounds on this?