Sprint 3 3.3.5.2C Purchase Order Line Items - Confirmed PO Delivery
Hi,
When i am testing submit purchase order request for Cookie Crumbs_EN. In Week 9 FY20, select the Boolean for Submit Purchase Order Request?
Comitted PO delivery should be enabled for Week 13, instead it is enabling for week 5
Please find the formulas i have added below, don't know where i made a mistake,
sharing all the references.
Shipping method - 'SYS07 Distribution Center Details'.Default Shipping[LOOKUP: 'SYS08 SKU Details'.Supplied By]
Shipping Time Weeks - 'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method]
Confirmed PO recepit - IF Confirmed PO Delivery > 0 THEN OFFSET(Suggested Order Amount for the Month, -Shipping Time Weeks, 0) ELSE 0
others you can see in the screenshot,
also adding relevant attachments
I would really appreciate someone's help
Thanks,
Srikar Allena
Answers
-
You should find in previous weeks.
OFFSET(PO Submitted, -Shipping Time Weeks, 0)
2 -
Thank you so much
0