AnsweredAssumed Answered

recurring payments calculations

Question asked by jonnyt on Dec 21, 2009
Latest reply on Dec 22, 2009 by jonnyt

Title

recurring payments calculations

Post

Hi there,

 

 

I am trying to set up a recurring payments system.

 

I have set up the following fields:-

 

StartDate

frequencyOfPayment

numberOfPayments

nextInvoiceDate

lastPaymentDate

 

What calculations can I use to calculate nextInvoiceDate and lastPaymentDate??

 

Some sort of date function I imagine.

 

Could anyone also recommend how I can automaticallly add a recurring payment thats payable to an invoice table?? Perhaps using a script that runs every day on the server (we have filemaker server 10)

 

Many thanks for your kind help.

Outcomes