Payment every year

Options
manuebilly
manuebilly Member, ALL USERS, GroupMember, Community Member Posts: 5 Occasional Contributor
in Planning & Modeling

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

Tagged:

Comments

  • manuebilly
    manuebilly Member, ALL USERS, GroupMember, Community Member Posts: 5 Occasional Contributor

    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.

  • manuebilly
    manuebilly Member, ALL USERS, GroupMember, Community Member Posts: 5 Occasional Contributor

    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

     

    Capture.PNG

Categories