Create Shipping Export Module and Create a Saved View; Final Line Items for INV01 Inventory Ordering

Hello All -

I am still having a frustrating time figuring out the final formulas for the above mentioned modules. And this is after reading and re-reading the directions provided and getting hints or even answers provided by the community, I'm still not getting the results provided by the instructions. Is there anything obvious I'm doing wrong? Could someone please check my answers and formulas to see if I am correct or incorrect? Screenshots below:

All INV01 and Formula for Beginning Inventory:

All INV01 and Formula for Beggining Inventory.jpg

All Hidden Line Items in INV01:

INV05 Directions:

All INV05 and Formula for Shipping Costs:

INV05 Expected Results:

INV05 My Current View:

I hope someone can help me with this, I should be done by today but I'm unable to figure out these specific issues. Issues such as; errors in formulas, errors in displays/pivots, and confusion over directions. Any help is appreciated! Thank you!

Accepted answers

devrathahuja

@jcarbo - Is the edit option activated?

Enter & edit cell data

All comments

devrathahuja

Hi @jcarbo ,
Can you post snapshots of your mapping module SYS08 SKU details as well as of the source data module? INV01 Final Shipping Costs?

jcarbo

Hello @devrathahuja -

Here is what you asked for, hopefully. If it's not and you need more, let me know!

Source data models

SYS08 SKU Details

SYS08 SKU Details Blueprint view

SYS01 Final Shipping Costs

Thanks in advance!

jcarbo

@devrathahuja Also, here is the Model Calendar and Time Ranges:

Model Calendar:

Time Ranges:

devrathahuja

Hi @jcarbo ,
I see that the submit purchase order request is false for that month. Do you have any step in the training where you're asked to turn it to true or provided with a file to upload? Since that might be causing the final shipment amount to be 0 which in turn is leading to 0 shipping costs.

jcarbo

Hi @devrathahuja -

I still can't get anything to work and what I mean by that is, every Boolean is grayed out and unable to be checked. Even in the published page, end users are not able to check boxes. Here are the scree shots:

Grayed out Booleans - Red Rectangles.jpg

SYS01 Time Settings by Week - Blueprint.jpg

is there anything here that could be causing an issue? Thank you!

devrathahuja

@jcarbo - Is the edit option activated?

Enter & edit cell data

jcarbo

@devrathahuja Yes, it is. I believe I've solved the issue. I will create another Question if need be. Thanks for all of your help!

devrathahuja

@jcarbo - Great! What was causing the issue?

jcarbo

@devrathahuja I believe I just needed to refresh the data and re-check the "Enter Cell Data" because I remember turning it on, but it must've been turned off after I recreated the Grid element. Silly mistake!

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…