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

JimMcL
New Contributor

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_1-1597954805883.png

 

11 REPLIES 11
Ajinkya
Contributor

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

Hi @JimMcL ,

 

The image shared by you suggests 'beginning inventory' is already mapped. Request you to elaborate more on the exact ask for me to help accordingly.

 

There is also another way to get the 'beginning inventory' line item mapped shown in the below manner,

1. Have a close look at the black highlighted mappings in the image,

Pic 4.png

2. Choose 'Beginning Inventory' line item under 'DAT01 Beginning Inventory Line Items' tab,

pic 5.png

Regards,

Ajinkya

JimMcL
New Contributor

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

I had tried that before and this is the result I get. All of the data is ignored.

JimMcL_0-1598014147820.png

 

einas.ibrahim
Master Anaplanner/Community Boss

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

Hi @JimMcL 

 

Could you please share with us a screenshot of your Mapping tab?
Also, I believe the source selection for DAT01 Line Item should be Column header, then in the Line Items tab ensure that the Beginning Inventory is mapped.

Finally, I am curious to see the information in the Details tab of the import result screen. If you scroll all the way to the right, there should be a column with more information about any error or issue encountered.

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"
JimMcL
New Contributor

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

Here are a number of screen shots. I ran the import with column header mapping the dist center as well. Happy to try it again.

 

JimMcL_0-1598016717766.pngJimMcL_1-1598016761415.png

JimMcL_2-1598016801794.pngJimMcL_3-1598016835876.png

 

einas.ibrahim
Master Anaplanner/Community Boss

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

Hey @JimMcL 

 

Why is your location list empty? It's returning "No Item"?

 

Also, can you please look into what's in the last column on the Details tab as highlighted below?

 

image.png

 

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"
harshininitw@gmail.com
New Contributor

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

How did you solve this I got same issue
Cynthia1
New Contributor

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

Hi Anaplaners, did anyone managed to solve this? I got the same issue here. Thanks.

kevin.cho
Certified Master Anaplanner

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

Hi @Cynthia1 

 

If you're having the exact same issue as above, can you please take a screenshot of the "Location Flat" list in the Grid View? 

 

My guess is that the subset was not populated, and as such the values were not being mapped across. The subset needs to be populated first. 

Cynthia1
New Contributor

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

Hi @kevin.cho I am so happy to hear from you! Finally someone came to my rescue! 🙂

Here's the screenshot: 

Screenshot 2021-01-12 at 11.34.52 AM.png

 How does it looks?

 

BR, Cynthia