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

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

Level_2_Sprint_3_reciept_checkbox_yes_99560.PNG

Level_2_Sprint_3_receipt_99560.PNG

Accepted answers

ChrisAHeathcote

@CJHKGZZ

Its great that you managed to find a solution.

A negative number in a POST does not post it forward....its posts in backwards!

A great way of thinking about the difference between POST and OFFSET with regard to the reference is the following;

Think of POST as pushing data the source time period to the target time period.

Then think of OFFSET as pulling the data from source to target.

A negative in POST will push the data back in time while it will be pulled forward in time when used in an OFFSET

Good luck the remainder of the training.

Chris

All comments

rob_marshall

@CJHKGZZ

You might want to look at this thread:

https://community.anaplan.com/t5/Anaplan-Platform/Line-Item-Confirmed-PO-Delivery-Sprint-3/m-p/85062#M18734

Rob

CJHKGZZ

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

ChrisAHeathcote

@CJHKGZZ

The query in the IF statement is greater than zero ( >0 ) at no point does this condition return a true result so the IF returns zero.

Change the formula to be >=0 and the IF statement will follow the OFFSET outcome and push the data forward by the corresponding number of week periods.

If the IF query is correct then find a product in which 'Confirmed PO Delivery', is greater than one and the OFFSET should work.

Chris

riyazpasha

HI @CJHKGZZ ,

I think the formula for confirm purchase order receipt - IF Confirmed PO Delivery <> 0 THEN POST(Final Shipment Amount, Final Shipping Time Weeks) ELSE 0

If you need the data to be posted to ahead as per the weeks use the post function. the values will be posted based on the Final Shipping Time weeks.

CJHKGZZ

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

ChrisAHeathcote

@CJHKGZZ

Its great that you managed to find a solution.

A negative number in a POST does not post it forward....its posts in backwards!

A great way of thinking about the difference between POST and OFFSET with regard to the reference is the following;

Think of POST as pushing data the source time period to the target time period.

Then think of OFFSET as pulling the data from source to target.

A negative in POST will push the data back in time while it will be pulled forward in time when used in an OFFSET

Good luck the remainder of the training.

Chris

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…