Confirmed PO Delivery (3.3.5.2 Inventory Ordering Module Formulas)

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?

Confirmed_PO_Delivery_136849.JPG

Comments

TimothyThomas

Hi @SPelot ,

You are definitely on the right track! I would recommend you check out this similar question posed in this Community post: Link

@smithevan18 has an excellent explanation in the linked post. I'd suggest taking a look and perhaps trying out the POST function instead of OFFSET, and seeing if that helps get you the right result.

Let me know if you have further questions!

Thanks,

Timmy

SPelot

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

TimothyThomas

Hi @SPelot,

You're really close! The section of your formula containing the POST function looks great. I think the only thing left is to get rid of the conditional statement. Logically, since you are "posting" a number into the future, it shouldn't matter if the PO Submitted line is 0 for the period you are looking at. From your example of looking at Week 3, the PO Submitted for Week 3 is 0, but we still want the 1 to come forward from Week 1. Since you have the conditional set up, it's not allowing the 1 to come forward from a previous period. If you keep just the POST part of your formula, I think you will have it working correctly.

Hope that makes sense, let me know if that works!

Thanks,

Timmy

Quick Links

Recent release news

June 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our June 2025 official release notes. The information below offers supplemental information to that post. Security and administration New 'Application Owner' security role Tenant administrations can assign the Application Owner role to users in their tenant.…
Register for our July 30 platform release webinar!
Anaplan's next quarterly platform release webinar will be held July 30, 2025 at 8 a.m. Pacific Time. During this session, we will explore the latest features so you can optimize your Anaplan experience. Our expert-led session will equip you with a practical guide and live demonstrations to help you get the most out of new…