INV01 " Confirmed Purchase order receipt" line item formula - Level2 - Sprint 3

Highlighted
New Contributor

INV01 " Confirmed Purchase order receipt" line item formula - Level2 - Sprint 3

Hi,

 

I enjoyed L2 Model building, but I am stuck with Confirmed Purchase Order Receipt formula in INV01. Can you please check my formula and suggest what I am missing?

 

Correct results are showing when I used below formula but not working in exam

IF Confirmed PO Delivery > 0 THEN POST(Suggested Order Amount for the Month, Final Shipping Time Weeks) ELSE 0

 

I also tried below formulas in exam, but it did not work.

IF Confirmed PO Delivery > 0 THEN POST(Suggested Order Amount for the Month, Shipping Time Weeks) ELSE 0

Try best practice

IF Confirmed PO Delivery > 0 THEN OFFSET(Suggested Order Amount for the Month, -Shipping Time Weeks, 0) ELSE 0

IF Confirmed PO Delivery <= 0 THEN 0 ELSE POST(Suggested Order Amount for the Month, Final Shipping Time Weeks)

POST(Suggested Order Amount for the Month, Final Shipping Time Weeks)

4 REPLIES 4
Highlighted
Master Anaplanner/Community Boss

Re: INV01 " Confirmed Purchase order receipt" line item formula - Level2 - Sprint 3

@ramas 

 

If you are following the instructions from Level 2 document it asks you to pick up Suggested Order Amount for the Month initially and later when you create an override line item it asks you to replace Suggested Order Amount for the Month with Final Shipment Amount. Your second last formula is somewhat close but not right

 

Few Corrections:

It should be IF Confirmed PO Delivery > 0  and not <=0 because maximum times it will be > 0

In POST syntax first parameter should be Final Shipment Amount & not Suggested Order Amount for the Month

In POST syntax second parameter should be Final Shipping Time Weeks

 

Hope that helps

Misbah

Highlighted
Occasional Contributor

Re: INV01 " Confirmed Purchase order receipt" line item formula - Level2 - Sprint 3

Yes, it helped. Thank you so much 🙂

Highlighted
New Contributor

Re: INV01 " Confirmed Purchase order receipt" line item formula - Level2 - Sprint 3

I had an issue as well. Here is the formula I was using.

 

IF Confirmed PO Delivery > 0 THEN POST(Final Shipment Amount, Final Shipping Time in Weeks) ELSE 0

 

Please let me know how far off I am. thanks.

Highlighted
Occasional Contributor

Re: INV01 " Confirmed Purchase order receipt" line item formula - Level2 - Sprint 3

Your formula is correct, looks like the line item name is wrong "Final Shipping Time in Weeks"

Remove "in" and then try it again.

 

Hope this helps!