Create Shipping Export Module and Create a Saved View

In Level 2 Model Building : Conclusion, there's an 'Activity: Prepare Data Exports' that tell us to Create Shipping Export Module and Create a Saved View. I've made the formula and choose the format and summary method but I'm not sure if it was right.

Here is the blueprint of my INV05

And here is the screenshot of the learning that asked me to not use the formule for the code and make a saved view

I don't know how to show the code in the line item without using formula and I don't know which summary method to use to make the saved view. Can you tell me how to do it all? and what do you think of my subsidiary and all of the formula that I use? please reply to this ASAP ( I've been so late to pass my level 2.

Comments

jagadishdash

@NadiaSafarah

For INV05 Shipping cost: this will be the formula .

The best practice is use formula(Calculate) once and reference many time. Don't put code(item(G3 location)).

Code will be referred from sys location module directly.(Refer the screen shot)

This will be the saved view for export. Refer the screenshot and if any clarification need let me know.

Thanks,

NadiaSafarah

thank you again for replying for my question! done it 😄

jadefortunato

Honestly it's not just you. I was completely confused as to what they were asking me to do. The way it was phrased I thought they were saying I should be recreating each code unless that specific code was elsewhere, which sent me into a whole tangential loop of "do I have all the codes I need, yes, so why are they saying this?"

jagadishdash

@jadefortunato Yes, it's little confusing. But they mentioned clearly don't create if already exist. Anyway you got it! That's great.

If it's helpful for you, Accept the answer as solution.

Thanks,

jadefortunato

It’s already been accepted; I was just chiming in for moral support.

Yogitha

@jagadishdash

I am attaching my screenshots and let me know about the formulas and I need help regarding the saved view 2022-11-02 (1).png

Jrayford

Can someone explain to me how you all came up with the formula for shipping cost?

DKeren

@Jrayford Like any module you want to think about it in a logical sense. The first way is to understand what you're looking for. You need to pull in shipping costs for you inventory, which should lead you to look in the INV01 Inventory Ordering module. Here you have 2 options: Shipping Costs and Final Shipping Costs line items. The verbiage here may not be super clear because normally the instructions are explicit but in real life scenarios, you'd usually going to pick the final option (which is why I mentioned thinking about it logically before). From there you now need to think about mapping this value to the location. Since the INV01 Module is dimensioned by P3 SKU and Time (weeks) you this leads you use one of the mapping functions (LOOKUP or SUM) and in this case it's SUM. The location can be found in the SYS08 SKU Details module. This is usually how I like to think through my formulas, piece by piece, then writing them out becomes simplified. Hope this helps!

Quick Links

Recent release news

August 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our August 2025 official release notes. The information below offers supplemental information to that post. Planning experience Multi-browser tab syncing When changing context or data on a UX page, you can now view real-time data updates across up to five…
July 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our July 2025 official release notes. The information below offers supplemental information to that post. Planning experience External URL navigation button Page builders can configure navigation action buttons to link to external URLs, including non-Anaplan…