I have created a database to record all my clients / customers contract details.
we are invoicing our customers after every quarter from the starting date of contract till the end of contract.
Like Start Date : 01-01-2012
End Date : 31-12-2012
Payment : Quarterly
1st Quarter = 31-03-2012
2nd Quarter = 30-06-2012
3rd Quarter = 30-09-2012
4th Quarter = 31-12-2012
i want to create a report every month which shows the due payment of each client for the particular month.
Hope some one can understand what i am trying to do
thanks in advance