nmascia
Certified Master Anaplanner

Level 2 Model Building - SYS08 module

Is there a step missing detailing how we should build the formula for the 'supplied by' line item for the SYS08 SKU details module?

1 ACCEPTED SOLUTION

接受的解决方案s
ChrisMullen
Community Boss

@nmascia

The model should match the Data Hub, there is an error in the model that is downloaded. The Default shipment for Nutzo bar_EN is New York. Upload the SKUs.csv file into the Supply Chain model SYS07 Distribution Center Details to correct this. This is a file you downloaded for the Data Hub. It will correct it.

Sorry for any confusion, I am fixing this now.

Thanks,

Chris

View solution in original post

12 REPLIES12
ChrisMullen
Community Boss

@nmascia

Level 2 Model Building is designed to be a little less prescriptive over level 1 model building. There will not be as many formulas given. However, think about each situation. Is this an input, and therefore doesn't need a formula? Is this value calculated somewhere else and I want to reference it?

nmascia
Certified Master Anaplanner

Hi Chris,

Thanks for your response. The problem was that I made a mistake when importing the SKU file into SYS08. That line item did not get loaded.

I loaded the file correctly and am still having an issue. Nutzo Bar_EN has New York as it's supplied by distribution center in the data file.

clipboard_image_2.png

Which means it's shipping method is 'Air':

clipboard_image_1.png

However, in Sprint 3, the section labelled 'Activity: Test the Shipping Cost Formulas', Anaplan provides a screenshot of what INV01 should look like. It is giving Nutzo Bar_EN shipping method as 'Road' and not 'Air':

clipboard_image_3.png

ChrisMullen
Community Boss

@nmascia

The model should match the Data Hub, there is an error in the model that is downloaded. The Default shipment for Nutzo bar_EN is New York. Upload the SKUs.csv file into the Supply Chain model SYS07 Distribution Center Details to correct this. This is a file you downloaded for the Data Hub. It will correct it.

Sorry for any confusion, I am fixing this now.

Thanks,

Chris

nmascia
Certified Master Anaplanner

Thanks Chris,

I made SYS07 in the supply chain model match SYS07 in the Data hub model. New York now has 'Road' as its default shipping method

mata.israel08@gmail.com
Occasional Contributor

How did you make it match?
nmascia
Certified Master Anaplanner

mata.israel08@gmail.com

I believe I imported SYS07 from the DataHub into SYS07 in the supply chain model. I do think that the files have been updated though. At the time I was taking Level 2, the 2 files for SYS07 for the DataHub and supply chain were not in sync.
L.A.Foster
Community Boss

helennie
Frequent Contributor

This note should probably be added tohttps://learning.anaplan.com/mod/page/view.php?id=12100Review the INV01 Line Item Formulas and Summary Method settings, as it comes before the 12107 and shows screenshots with Road indicated.

nicole.johnson
Frequent Contributor

The locations correct should be noted prior to this section. Instead, it is first applicable when checking answers here:https://learning.anaplan.com/mod/page/view.php?id=12100