Level 3 - Sprint 3 Testing of Override Amount and Shipping Method

Highlighted
Regular Contributor

Level 3 - Sprint 3 Testing of Override Amount and Shipping Method

Hi

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.

 

Star_1-1587426705209.png

 

Star_2-1587426866864.png

 

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]

 

 

 

 

2 REPLIES 2
Highlighted
Frequent Contributor

Re: Level 3 - Sprint 3 Testing of Override Amount and Shipping Method

Hi @Star,

 

I think yo miss in Confirmed Purchase Order Receipt, in course you need change OFFSET to similar function (LAG / POST / LEAD)

 

Panji_0-1587436381287.png

 

Regards,

 

Panji

Highlighted
Regular Contributor

Re: Level 3 - Sprint 3 Testing of Override Amount and Shipping Method

@Panji
I tried with POST. It worked. Thank you.