Confirmed PO Delivery (3.3.5.2 Inventory Ordering Module Formulas)

Options
SPelot
SPelot Member, ALL USERS Posts: 5 Occasional Contributor
in Anaplan Community

I am trying to find the right way to set the Confirmed PO delivery in Level2 sprint 3.

I have set boolean for Submit Purchase Order request?, then I set PO submitted to 1 or 0 depending on boolean.

Then for Confirmed PO delivery I set formula: IF Submit Purchase Order Request? THEN 1 ELSE 0

 

For me as boolean is checked for Week1 then PO submitted is equal to 1 and shipping times week is 2 I was expecting Confirmed PO delivery to be 1 for Week3... I must have missed something but what?

Tagged:

Comments

  • SPelot
    SPelot Member, ALL USERS Posts: 5 Occasional Contributor

    Hi Timmy, 

    I followed your advice and read the post attached but unfortunately, I didn't manage to set the formula working.

    For the confirmed PO delivery I set the formula as :

    IF PO Submitted = 1 THEN POST(PO Submitted, Shipping Time Weeks) ELSE 0

     

    As the boolean is ticked on week1 then PO submitted = 1 then as shipping time for week1 is 2 I was expecting the value of confirmed PO delivery in week3 (Week1 + 2 weeks of shipping) to be =1 (=the value of PO submitted in week1).

    There is something I must be missing even with the Post function...

Categories