I am hoping that someone can please help me!
I have a saved search for one client’s invoices (main line = true) with their payment status and amount paid. For invoices that had a deposit applied to them, I would like the report to display the prepayment deposit number. For example, Prepayment 232 was applied to seven invoices. If I pulled a list of all the invoices, these seven invoices would have a column with a Prepayment 232 and the amount that was applied (not necessarily the invoice amount). Thank you!