Pseudocode for inserting repeating invoices
For all in Template i = int((date()-Template.lastbilldate)/Frequency.everyxdays) while i > 0 Addbill(Template.templateID) end End Function Addbill(int Template.templateID) Insert into Bill(Amount.AmountID, Date(), "Membership Fees", Template.memberID End