Accounting wants to show unapplied payments and credit memos applied to an invoice

Our Accounting department wants a better way to show when we apply an unapplied payment or a credit memo to a specific invoice. They know they have the Customer Statement that they want to start using as well, likely monthly, but they want to be able to show what all was applied to an invoice to reduce the amount owed on that particular invoice. Something like:

Invoice Amount

  • Credit Memo and/or unapplied payments
    equals “Amount Due”

Try using the AR invoice balance report. You aren’t relaying the info to the customer, correct? Just the accounting dept? It comes out like a transaction register.

Actually, they want it to show on the invoice going to the customer.

That would be a customization.

If you are referring to an SSRS customization, yes, you are correct. I was hoping that someone may have already figured out how to do it or a direction to point me in for how to do it.

I would look at the customer statement to examine how it is done there, add any necessary tables to the Invoice with the linkages and start there.