L2 - S3 - 3.3.5.5

Yogitha

Want help with this formula. 2022-10-21 (2).png

Comments

Misbah

@Yogitha

You have to reference the line item from TRA01 Shipping Metrics module by looking up on Products and Shipping Methods.

Thanks,
Misbah

Mix Logix

Yogitha

IS THE FORMULA RIGHT?

'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Final Shipping Method]

Yogitha

Other line item updates:

Confirmed PO Delivery and Confirmed Purchase Order Receipt:

Re-direct the formulas for these line items that currently reference the Shipping Time Weeks line item to the Final Shipping Time Weeks line item.

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

Misbah

@Yogitha

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.

Thanks,

Misbah

Miz Logix

Yogitha

So for this also same thing I need to do?

Confirmed Purchase Order Receipt:

Re-direct the formula for this line item that currently references the Suggested Order Amount for the Month line item to the Final Shipment Amount line item.

Yogitha

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

3.3.5.4 -

Confirmed Purchase Order Receipt:

Re-direct the formula for this line item that currently references the Suggested Order Amount for the Month line item to the Final Shipment Amount line item.

so should I replace Suggested order amount for the month with Final Shipment amount?

Misbah

@Yogitha

That's correct!

Quick Links

Recent release news

September 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our September 2025 official release notes. The information below offers supplemental information to that post. Planning experience Improved Keyboard navigation across cards Across Boards, Insights, and Worksheets, tab navigation through toolbars in cards and…
Register for our October 29 platform release webinar!
Anaplan's next quarterly platform release webinar will be held October 29, 2025 at 8 a.m. Pacific Time. During this session, we will explore the latest features so you can optimize your Anaplan experience. Our expert-led session will equip you with a practical guide and live demonstrations to help you get the most out of…