Sprint 3 - INV01 - Confirmed PO line item formula

ankitaga2000

Hi All,

I am stuck up on building the formula Confirmed PO Delivery .

I searched on the forums and it says to use line item "Final Shipping Time Weeks" . But it is saying no where to create that line item. I am super confused

Regards,

Ankita

Comments

JaredDolich

@ankitaga2000

It's a good callout. Level 2 will really stretch you. Here's the formula they want you to explore on Anapedia.

Confirmed PO Delivery = POST(PO Submitted, Final Shipping Time Weeks)

Let's break that down:

We want to take our purchase order quantity and have it be "received" in the future week based on the leadtime of the shipping method chosen.
POST function is a good choice because it will take a line item value and move it forward on the calendar based on the value that you provide.
POST(Line Item, Leadtime)

This is a SUPER powerful function for supply chain solutions. Take a look at the Anapedia page. You'll be amazed what you can do with this function.

Misbah

@ankitaga2000

Ultimately you too will have to create Final Shipping Time Weeks Line item but just don't follow what is being discussed on the Forum. Every query has its own context.

If you go sequentially in Level 2 you will be using Shipping Time Weeks Line item first and then in later lessons you will be asked to create Final Shipping Time Weeks Line item.

Please go ahead and follow the instructions in the L2 course. Good Luck

Misbah

ankitaga2000

Then I am not able to find the formula without final shipping item . Please guide me by using offset @Misbah @JaredDolich

Misbah

@ankitaga2000

I think it will be OFFSET(Final Shipment amount, -Shipping Time Weeks,0) Not certain though

Quick Links

Recent release news

November 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our November 2025 official release notes. The information below offers supplemental information to that post. Intelligence Anaplan Forecaster: General enhancements Anaplan Forecaster now supports list subsets for the item ID list and custom time, list format…
October 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our October 2025 official release notes. The information below offers supplemental information to that post. Planning experience Combined Grids This new capability gives page builders the ability to combine multiple modules into a single, unified grid on a UX…