
Hi folks,
This customisation is so special so that I urge to ask for your help. My boss wants me to ‘recreate’ our invoice template so that it will show past due invoices. If the aging bucket are not available to the invoice form, we may have to add past due invoices at the bottom of the form where the arrow pointed to i.e
Invoice # Invoice Date Invoice Due Date Invoice Amount
1234 11/01/2013 11/30/2013 $500.00
4567 11/25/2013 12/25/2013 $500.00
He also wants to add next to the total column the current balance and past due balance columns.
Any suggestions?
*This post is locked for comments
I have the same question (0)The problem with doing this is reserving the amount of space for the list. A statement (which is what you want) will print on multiple pages if there are enough open invoices. Now I know you only want past due ones but the spacing could be tricky.
What I would suggest is create SSRS invoice forms and use something like Accountable's Forms Printer to launch them. You could have one document with header information, then a sub report for the invoice data, followed by a second sub report with the past due invoice information. The main report would then close the footer of the form.