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.
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
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