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

[sunilramakumar]

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 ?

Sunil

[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.

[sunilramakumar]

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

Sunil

[Nivetha]

Hi@sunilramakumar

如果你的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 asCODE(ITEM('G3 Location'))] in theINV04 - Distribution center capacity and the map the fields while importing.

Nivetha

[sunilramakumar]

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

Location	Capacity
G001	105000
G003	110000
G006	105000
G008	90000
G009	145000
G012	110000
G013	180000
G015	100000
G018	90000
G021	110000
G022	110000
G026	110000
G028	90000
G030	140000
G034	45000
G037	120000
G039	100000 S

[Nivetha · Accepted solution]

Hi@sunilramakumar

Let me guide you through this:

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

In moduleINV04 - Distribution center capacity,the line itemDistribution center capacityshould be referring to moduleSYS07 Distribution Center Detailswith the formulae as'SYS07 Distribution Center Details'.Capacity.

I hope this helps

Thanks,

Nivetha K

[sunilramakumar]

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

Sunil