Activity 3.3.5.1 Create Inventory Ordering Module - 0 as shipping time

Options
hannaaberg
hannaaberg Member, ALL USERS Posts: 5 New Contributor
in Planning & Modeling

Hi,

 

I am having issues with getting the correct values for Shipping Time Weeks in INV01 Inventory ordering model. The formula used for this is 'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method] and that should be correct I think. See below screenshot for the module.

hannaaberg_0-1658319030144.png 

hannaaberg_1-1658319050675.png

 

I have checked and I have imported data to DAT02 Shipping Metrings correctly (value should be 2)

hannaaberg_2-1658319100992.png

The TRA01 Shipping Metrics by Week looks like this with the formula YEARVALUE('DAT02 Shipping Metrics'.'Shipping Time (Weeks)') due to the timescale being different. Do I need to consider this when going from TRA01 to the INV2 module (where weeks is the time scale)? What could be causing the 0 values?

hannaaberg_3-1658319130438.png 

hannaaberg_4-1658319221322.png

 

 

 

 

 

Tagged:

Comments

  • hannaaberg
    hannaaberg Member, ALL USERS Posts: 5 New Contributor

    Hi, Thanks but I think I need more guidance on this. From what I have seen in the forum everyone is using the same formula as me, without lookup for year so my guess is that this is not what is causing this. But I agree that it seems like there could have something to do with taking values from Year to Week?

     

    Below screenshot is for the Time System modules for week, i.e. not any value for year. I don't think that I should be able to understand that I should create new line items in the systems module to be able to solve this in a Module Builder 2 course.

     

    Do you have any other ideas of what is behind this?

    hannaaberg_0-1658325239041.png

     

Categories