I've spent quite a few days trying to get my head round this and can't work out a solution, can anyone help?
I run an events business and host shows where business pay to exhit, I have each of my events listed as items so I can run a report and see which customers are booked into each show and financials etc.
I have two different sorts of customers:
Pay As You Go customers where I raise the invoice at the time of booking, they pay and it's sorted, happy days.
Contract customers like to spread their payments over 12 months, I have been raising recurring invoices but therein lies my problem.
On the recurring invoice I list the item (event) and alter the amount so the total invoice amount shows as the monthly direct debit figure which is due. My problem is when I run a sales by item report the recurring invoices don't show up!
Any ideas how I can get around this, moving forward more and more of my customers are asking to switch to a contract system which is good but it's giving me a real headache to try and keep on top of it!
Thanks
Stephanie