Want help with this formula.
You have to reference the line item from TRA01 Shipping Metrics module by looking up on Products and Shipping Methods.
IS THE FORMULA RIGHT?
'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Final Shipping Method]
Other line item updates:
Confirmed PO Delivery and Confirmed Purchase Order Receipt:
Before you continue, review and update the Summary Method settings for the line items.
WHAT SHOULD I DO WITH THE ABOVE INSTRUCTIONS? I AM CONFUSED
In these two line items, you must have used Shipping Time Weeks before. Well, now you will have to replace Shipping Time Weeks with Final Shipping Time Weeks and that's it.
So for this also same thing I need to do?
Confirmed Purchase Order Receipt:
My formula for "CONFIRM PURCHASE ORDER RECEIPT"
IF Confirmed PO Delivery > 0 THEN OFFSET(Suggested Order Amount for the Month, -Shipping Time Weeks, 0) ELSE 0
so should I replace Suggested order amount for the month with Final Shipment amount?