Level 2 Sprint 1 User Story 3 Import Data into DAT01 Beginning Inventory

Highlighted
New Contributor

Level 2 Sprint 1 User Story 3 Import Data into DAT01 Beginning Inventory

Anaplan2.pngAnaplan1.png

My upload doesn't work. Should I manually map all numbers to the Beginning Inventory? Is my mapping looking right? I think I'm missing something.

11 REPLIES 11
Highlighted
Certified Master Anaplanner

Re: Level 2 Sprint 1 User Story 3 Import Data into DAT01 Beginning Inventory

Hi @qchen 

 

You should change the mapping of the DAT01 line item from column 3 “Beginning Inventory” to Column Header.

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
New Contributor

Re: Level 2 Sprint 1 User Story 3 Import Data into DAT01 Beginning Inventory

Thanks much Einas!

Highlighted
New Contributor

Re: Level 2 Sprint 1 User Story 3 Import Data into DAT01 Beginning Inventory

I am having an issue with the import. Any reason the beg bal is not being picked up in the file.

 

JimMcL_0-1597857236548.png

 

Highlighted
New Contributor

Re: Level 2 Sprint 1 User Story 3 Import Data into DAT01 Beginning Inventory

These screenshots show how I am importing the beg bal. Not sure what the issue is.

 

JimMcL_0-1598121826560.pngJimMcL_1-1598121856949.png

JimMcL_2-1598121894018.pngJimMcL_3-1598121936288.pngJimMcL_4-1598121968243.pngJimMcL_5-1598121999323.png

 

Highlighted
Certified Master Anaplanner

Re: Level 2 Sprint 1 User Story 3 Import Data into DAT01 Beginning Inventory

Hi @JimMcL 

 

First a general note to all:
I suggest new issues should be posted in a new thread. I believe it is more efficient to post new issues separately instead of tagging it to another issue that may or may not be relevant. Sometimes even though the 2 topics are related to the same module/import/line item .... etc, the issues in each are different.
I believe this way when a community member is searching for an answer to his/her question they can easily find it.

 

 

Now to the main issue:

From the screenshots you provided, it looks like the locations are not mapped. That's the reason why Anaplan doesn't know where to place the data for Beginning Inventory since we need both a location and SKU.

So your focus should be on why the locations are not mapped?
It seems that the Location - and hence the list subset - may not be populated. So start from that list.

This is the same answer given in your other post here

   

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
New Contributor

Re: Level 2 Sprint 1 User Story 3 Import Data into DAT01 Beginning Inventory

Sorry if I am missing something simple. Here is the G3 list which was already populated. Thank you for your help.

 

JimMcL_0-1598199617646.png

 

Highlighted
New Contributor

Re: Level 2 Sprint 1 User Story 3 Import Data into DAT01 Beginning Inventory

I figured it out. Thanks again.

Highlighted
Certified Master Anaplanner

Re: Level 2 Sprint 1 User Story 3 Import Data into DAT01 Beginning Inventory

@JimMcL 

 

Great!👍

 

could you please briefly write what was the issue and what was the solution. 
That will help others who may face the same issue in the future. 

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
New Contributor

Re: Level 2 Sprint 1 User Story 3 Import Data into DAT01 Beginning Inventory

I had the same issue. The subset "s Location Flat:Distribution Centers?" on the Location Flat list was not populated. Once the subset was populated, the import worked correctly.