Sage 100

Has any one come up with an invoice form showing all payments made to that specifc invoice, showing balance remaining? I know I have looked at this before and struggled with it. I keep getting requests for this type of invoice. It is not good enough to just send a statement.

I've done some but not with payment detail, if there are multiple payments. I'm just subtracting balance from invoice total to get the payment.

We've done something like this to show all outstanding invoices on the bottom of the invoice (subreport to AR_OpenInvoice). Based on your summary, I would do a subreport based on AR_TransactionPaymentHistory to get what you want. In this case, an unposted invoice would have nothing and a reprinted invoice from AR Invoice History would have the details of payments, credits, etc

Ok, bit the bullet and spent the time. I used the sub report, need to test some more, but the project I needed it for worked.