Level 2 Sprint 3.3.5.5 Final Shipping Method and 3.4.3 Country Made in

No matter how hard I try I am not able to the right formula for Final Shipping Method, so far my formula is "IF NOT Override Shipping Method OR ISBLANK(Override Method) THEN Shipping Method...

Another query is do I have to give a formula for Country Made In line item...if so can anyone give me a hint?!

Thank you in Advance

Regards

Winter

Accepted answers

BrunoRodriguez

Hello @Winter01 ,

With regards to the formula provided, you are quite close. If fact the formula is about the same:

In essence, when Shipping Method is not overridden and Override Method is blank - meaning the shipping method remains the same as defined- and this nature will be the most frequent, the value provided should be the original Shipping Method.
If it is overridden, provided Override Method.
IF NOT Override Shipping Method? OR ISBLANK(Override Method) THEN Shipping Method ELSE Override Method

As for Country Made -within SYS08- you have the location and you are looking for the country right?, which in essence is the parent of the location. If you were to create an line item and use a formula to identify the parent from "Supplied by", what would happen?

Hope everything above was clear!

All comments

BrunoRodriguez

Hello @Winter01 ,

With regards to the formula provided, you are quite close. If fact the formula is about the same:

In essence, when Shipping Method is not overridden and Override Method is blank - meaning the shipping method remains the same as defined- and this nature will be the most frequent, the value provided should be the original Shipping Method.
If it is overridden, provided Override Method.
IF NOT Override Shipping Method? OR ISBLANK(Override Method) THEN Shipping Method ELSE Override Method

Hope everything above was clear!

Quick Links

Can you help?

Unanswered questions

How have you from-scratch built lot-level, geo-based Inventory Consumption?
We’re working on modeling inventory consumption at the lot level, accounting for shelf life considerations, since we need visibility into which lots may not consume—both for risk reporting and E&O analysis. Each item may have customers with different shelf life requirements. For example, item A may need 270 days for some…
How to bring Row data into Columns?
Hi, Can you help me, how can we get row data into columns using Unique ID? Per attached below first snapshot, I want to bring rountingOrder 4, RecipientName, Sent and Completed dates in 1 row as show in sanpshot 2. Do I need to create Hierarchy list and Map?
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…