LEVEL 2 - Sprint 3 - 3.3.5.2 Inventory Ordering Module Formulas - Order Receipt

Options
CJHKGZZ
CJHKGZZ Member, ALL USERS, Partner Posts: 5 Occasional Contributor
in User Experience

Hello

 

I have been stuck on this for a little while now, would appreciate some guidance.

I am trying to get confirmed purchase receipt to show 2 weeks ahead like the learning portal answer but mine keeps only shows two weeks before. Been reading other posts about this and they all eventually switch to post and add a new line item called final shipping time at this stage I am not supposed to do that and want to get a better understanding of what is wrong.

 

Thanks

 

 

Tagged:

Comments

  • CJHKGZZ
    CJHKGZZ Member, ALL USERS, Partner Posts: 5 Occasional Contributor

    @rob_marshallthanks for showing me but i already saw that thread. I am still unable to understand it. The line item that I am asking for is order receipts not the order delivery.

  • CJHKGZZ
    CJHKGZZ Member, ALL USERS, Partner Posts: 5 Occasional Contributor

    @ChrisAHeathcote  @riyazpasha 

     

    Thanks for replying. I figured it out in the end.

    Later in the chapter it does require me to change to IF Confirmed PO Delivery > 0 THEN POST(Final Shipment Amount, Shipping Time Weeks) ELSE 0

    But I realized that when I was using OFFSET, I had to write this OFFSET(Final Shipment Amount, -Shipping Time Weeks, 0) ELSE 0

    I did not fully understand that I had to use the negative sign to make it go forward in time.

Categories