MB Level 2 Sprint 1: 1.5.2 Activity: Import Data into Beginning Inventory

DarrenS

Hi, I currently trouble importing data into the DAT01 Beginning Inventory module. Kindly advise.

Misbah

@DarrenS 

 

What kind of trouble? Can you please be more specific?

DarrenS

What should the mapping be like? This is what I've done. 

Misbah

@DarrenS 

 

Change the mapping of Line items from Fixed Line item to Column Headers. 

DarrenS

I've tried this before but there is no data being imported into the module. 

Misbah

@DarrenS 

 

Can you please share the module outlook. And also share the screenshot of every mapping tab. 

DarrenS

Here you go. There is something wrong under "Mapping2.JPG". Appreciate your advice. Thanks. 

CommunityMember126793

@DarrenS , check your location list (and eventually list subset).. is it blank?

If so then pls populate that list first with appropriate data before proceeding with this import.

Shahenaz

Hello There

I have subset populated but still there are no data populating for my import. Please advise mapping. 

Thank you!

Shahenaz

Never mind, I found it, data is actually importing but because of the distribution center where data is not applicable is on screen, it is not visible, try to change location & play around, it should be there

Julia2020

I have the same issue. mapping is good for 2 dimensions, but only first upper level data imported. I try to select "All Location", it is only bring me one location "US". I checked both sub list matched. Please advise.

ademmagatur15

I have same issue. Please advice

AjayM

Hi @ademmagatur15 ,

Can you please share your source view snapshot and action mapping?

As mentioned in the above comments, hope you have made sure you got distribution center subset populated.

mathallica

i did but i have different problem with numbers.

For example data is 13,000 but import as 13.

How can i fix

mathallica

@ademmagatur15

adayalina

Hi, @mathallica i am having the same issue as you rn, and only the 1st row is being imported. How did you solve this problem? 😥

AllamSriram

I am facing the issue only the 1st row is being imported. How did you solve this problem?

ctapia

I have the same problem…and I have the mapping correct

But ignored all the registers, because I have empty the Location Flat Distribution Centers?, and I don't know how to populate this information first.

I tried import the Distribution Center with some of the save views of Location, but I couldn't.

Can someone help me, please.