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

jcarbo

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 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!

devrathahuja

@jcarbo - Is the edit option activated?

Enter & edit cell data

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:

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

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!