I am just after people suggestion / tips / experiance for this one, I ahve come up with a high level issue, i not sure of a solution to yet.
I have 2 custom modules, Sites and Plots. (building company)
A site can have many plots
Plots will have their status changed to complete once they are finished. Then once a month we need to generate a invoice for sites that have had plots finished that month. All plots invoiced for the same site needs to be on the same invoice. Then the plot status will need to be changed to invoiced.
It may take serval months to invoice all plots for a site. At any one time there is multiple sites and lots of plots, so this can’t be a manual process. Ideally this process needs to be kicked of by a user each month.
The main issue I think is trying to get all the plots invoiced on the same invoice for each site. If this was not a requirement i was just going to use a pdf tempate on plots and have the user do a batch action once a month.
Any ideas how this can be achieved?