Sprint 3 - INV01 - Confirmed PO line item formula

ankitaga2000
Frequent Contributor

Sprint 3 - INV01 - Confirmed PO line item formula

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

ankitaga2000_0-1616075601351.png

Regards,

Ankita

4 REPLIES 4
JaredDolich
Moderator

Re: Sprint 3 - INV01 - Confirmed PO line item formula

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


Jared Dolich
Misbah
Moderator

Re: Sprint 3 - INV01 - Confirmed PO line item formula

@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
Frequent Contributor

Re: Sprint 3 - INV01 - Confirmed PO line item formula

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

Misbah
Moderator

Re: Sprint 3 - INV01 - Confirmed PO line item formula

@ankitaga2000 

 

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