have a problem in periodic billing. We use quarterly billing. Here we need the first bill till the nearest financial quarter end and then next bills should be regular as per the the quarter. The system calculates the quarter as the third month from the current date. But the customer needs the bill as per the financial quarter.
E.g. The contract period is from 14 may 09 to 30 Apr 2010. System calculates the quarter as 14-05-2009 to 31-07-2009.
But we want the end date to be 30 Jun 09 as this is the next financial quarter end. Then next quarters should be from 01 July 09 to 30 Sept. 09 and so on.
How this can be done? please suggest