Level 3 - Sprint 3 Testing of Override Amount and Shipping Method
The first screen seems to be working fine with the override amount. However, on the second screen, when the the override amount and shipping method were initiated, the override amount did not get into the 'Confirm Purchase Order Receipt'.
I re-checked the formulas but still did not manage to get it to work. I have defined the formulas at the bottom but if it is easier to view my screen, I'd be happy to share.
The formulas for the respective lines are:
1) Confirm Purchase Order Receipt = IF Confirmed PO Delivery > 0 THEN OFFSET(Final Shipment Amount, -Final Shipping Time Weeks, 0) ELSE 0
2) Final Shipment Amount = IF NOT Submit Purchase Order Request THEN 0 ELSE IF NOT Override Suggested Order Amount THEN Suggested Order Amount for the Month ELSE Override Amount
3) Final Shipping Time Weeks = 'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)'[LOOKUP: Final Shipping Method, LOOKUP: 'SYS08 SKU Details'.Product]