Confirmed PO Delivery - OFFSET
126.96.36.199 Create Inventory Ordering Module
I'm having the hardest time understanding which line item to use in the Confirmed PO Delivery formula. The threads I've read keep referring me to the POST function, but I'm not at that point in the training yet.
The following set of instructions are confusing me:
- Set the Confirmed PO Delivery line item to use the PO Submitted 1 value and OFFSET it based on the number of weeks between the order and delivery.
For example, if a PO Submitted has a value in Week 1 and the Shipping Time Weeks has a value of 2, there would be a value of 1 in the Confirmed PO Delivery line item in Week 3.
- Use the OFFSET function and reference the Shipping Time Weeks line items (should pull the value from the periods prior)"
My formula is:IF PO Submitted = 1 THEN OFFSET(-Ending Inventory, Shipping Time Weeks, 0) ELSE 0
I guess I don't understand how the output of this value relates to the user story or why we need it, or perhaps I could figure out which line item to use.