Level 2 - Sprint 3 - INV04 - Distribution center capacity upload

sunilramakumar
sunilramakumar
in Academy Discussions

Hello - I am trying to upload the distribution center.csv. I am not sure how to map the date field. Can you please advise ? There is no date field in the upload csv. I dont think it is needed as the capacity remains the same. But how do I make the date field as not needed ?

 

sunilramakumar_0-1591553414551.png

Sunil

Comments

  • MaartenGijbels
    MaartenGijbels

    Hi Sunil,

     

    It appears that you do have a time range in your module.

     

    I would verify the module, remove the time scale and reload the data.

     

    All the best,

    Maarten.

  • Nivetha
    Nivetha

    Hi @sunilramakumar 

     

    If your data field is not matching the CSV file, either that particular data field is not in the module or in the CSV file. It is mandatory to map all the fields while importing the data into the module. There is no way to ignore the mapping.

     

    You can include a line item as Code[with the formulae as CODE(ITEM('G3 Location'))] in the INV04 - Distribution center capacity and the map the fields while importing. 

     

    Nivetha

  • sunilramakumar
    sunilramakumar

    Hi Maarten - I see Time as a required dimension in the activity

     

    sunilramakumar_0-1591629734431.png

     

    Sunil

  • sunilramakumar
    sunilramakumar

    Hi Nivetha - I dont see a date field in the csv. Please advise

     

    LocationCapacity
    G001105000
    G003110000
    G006105000
    G00890000
    G009145000
    G012110000
    G013180000
    G015100000
    G01890000
    G021110000
    G022110000
    G026110000
    G02890000
    G030140000
    G03445000
    G037120000
    G039

    100000

     

    S

  • Nivetha
    Nivetha

    Hi @sunilramakumar 

     

    Let me guide you through this:

     

    In the module SYS07 Distribution Center Details,  Create a line item Capacity and import the CSV file into this module mapping location(CSV file) to code(line item) and Capacity(CSV file) to Capacity(line item). 

     

    In module INV04 - Distribution center capacity, the line item Distribution center capacity should be referring to module SYS07 Distribution Center Details with the formulae as 'SYS07 Distribution Center Details'.Capacity.

     

    I hope this helps

     

    Thanks,

    Nivetha K

  • sunilramakumar
    sunilramakumar

    Thank you. It helped. I did not properly read the instructions to load the data into SYS07 module. 

     

    Sunil

Categories