Is there a way to pull Bill Payments and show both the vendor bills and vendor credits on the applied transaction ? no matter what I do, I can only get vendor bill payments with the bill breakdown, but not pull the credits.

I'm guessing that's because I don't think the credit is technically associated with the payment. I think what's happening in the background when you generate a payment using both a bill and a credit is that the system is applying the credit to the bill and then the payment to the bill. You could try an Analytics workbook to see if you can do multi-joins to get the credit and payment on the same line as the bill.

Thanks I'll try a workbook. I sort of got there with a saved search where I pulled applying transaction: applied transaction then when I had it in excel I did a lookup to get the document numbers but it's annoying to do on a go-forward basis