Is there any solution out there for generating a customer statement that shows the customer their open transactions (usually invoices, but also credit memos and deposits; anything with an 'amount remaining') and the activity on those transactions? We've been working on a custom solution that looks something like this:
Customers can see, for example, that
- for invoice 0610138-IN there was 73.51 applied from their payment with check # 34938, but they still owe 8.15;
- or for invoice 0621008-IN we applied 192.30 from their credit memo 0610704-CM, but they still owe 15.38;
- and they have a credit memo 604054-CM that hasn't been applied to any invoice yet.
We send out statements monthly, and most of our customers want to see the status of their invoices and this kind of statement (which is what our previous ERP system provided) prevents a lot of inquiries coming in to our AR department.
The problem with doing this in Netsuite is credit memos. Unlike for payments, there is no transaction created when a credit memo is applied to an invoice in Netsuite, so the date the amount was applied is not recorded, and so we can't use that data to backdate when generating a statement like this.
Is this a problem that has been solved in some other way, or is there a workaround or module or add-on that we might not be aware of? Please let me know if I can explain more thoroughly (it does get pretty complicated, and I'm sure I haven't covered all A/R scenarios) or if you have any suggestions.
Thanks,
Paul
