Level 2 - Sprint 1 Activity 1.3.6.4 Create Import Distribution Center Details Saved View

akrem
akrem
in Modeling


Hello,


For the SYS07 Location Details I believe we need to have some formula to populate this table. This is a little tougher because these are flat lists that are not linked via hierarchy. Can anyone guide me help how to generate the country, region and distrubtion center in SYS07 ?


image.png
image.png
image.png
image.png


Comments

  • BrunoRodriguez
    BrunoRodriguez

    Hello @akrem ,

    You should have a file that can be imported into SYS07. I think it was called "Locations.csv" and you should be able to identify each Location with its code populating the other items as column headers.

    Cheers!

  • akrem
    akrem

    Hello,


    It worked partially, is there a way to get it to update based on code instead of updating Country Flat list ?

    Error

    Item not located in Country Flat list: Canada

    Item not located in Country Flat list: Mexico

    Item not located in Country Flat list: Brazil

    Item not located in Country Flat list: Brazil

    Item not located in Country Flat list: UK

    image.png


    image.png
    image.png


    ty

  • BrunoRodriguez
    BrunoRodriguez

    Hello again!

    it seems like your Country list was not properly populated. Have a look back at the import to ensure that all the items are being added to the list.

    Cheers!

Categories