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

Highlighted
Contributor

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

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

6 REPLIES 6
Highlighted
Certified Master Anaplanner

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

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.

Highlighted
Contributor

a Re: Level 2 - Sprint 3 - INV04 - Distribution center capacity upload

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

 

sunilramakumar_0-1591629734431.png

 

Sunil

Highlighted
Contributor

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

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

Highlighted
Contributor

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

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

Highlighted
Contributor

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

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

Highlighted
Contributor

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

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

 

Sunil