Dear Anaplaner,
I would like to forecast the payments of supplier contracts.
Example:
-a contract should be paid every year starting Nov 19.
-so next payment would be, Nov 20, Nov 21, Nov 22....
I would like to use boolean to indicate which month should be paid ?
Thank you for your help.
Solved! Go to Solution.
How many payments will be needed or does that change? If it is fixed, then the Next Payment? formula would be '1st payment ?' + 12. and then you can have another line time for 3rd payment which would be '1st Payment' +24
Dear Rob,
I've thought about this solution but I have other types of payments (quarterly, semesterly...)
I would like it to be automatic: if I add 5 years in my model I will need to add many line items.
Thank you Rob & Dameyer.
I've found a solution :
A- payment ?= '1st payment ?' OR Next payments ?
B- next payments ?:
IF Payment frequency = Payment frequency.Yearly AND Payment # - 1 = 12 THEN TRUE ELSE IF Payment frequency = Payment frequency.Yearly AND Payment # - 1 = 24 THEN TRUE ELSE IF Payment frequency = Payment frequency.Yearly AND Payment # - 1 = 36 THEN TRUE ELSE IF Payment frequency = Payment frequency.Yearly AND Payment # - 1 = 48 THEN TRUE ELSE IF Payment frequency = Payment frequency.Yearly AND Payment # - 1 = 60 THEN TRUE FALSE
Emmanuelle