Double check your work, you didn't fill in the template correctly.

the first tab, you need  

The second tab you need

We double checked the template and everything is there and it is loading the line just not the actual numbers. 

Both tabs need lines

Yes, I populated the import exactly as the export showed.

you didn't put int the location.....

Yes, because we need it for all locations and the export sample showed blank for all locations, or a specific location number. Is there a "location" number for all locations?

in that case, on the first tab you need the ORDERFOR column and set the value to "2"

We never use the "for all location" 

Yes, we I have "2" on the first tab in ORDERFOR column.  

get rid of all the other junk.  just have the 3 columns on the first tab.  

When I did that it wouldn't load, I received an error message.

I just did it and it worked fine.  use my file below as an example

.qi.xlsx

I changed our import to match yours column for column and it failed.

look at your part numbers.  on the first tab you have S78P  on the second you have S70P

I always fill in the second tab first, then just copy the Item and location columns to the first.

Start over, you're making a simple mistake, this is a simple process

Cannot believe I missed that, too many test files. It worked!! Thank you!

no problem.  That's what this forum is supposed to be for:  Helping each other out.  I could just keep telling you that you are doing it wrong, but that's not going to help you.  Good thing I'm not a consultant..... 

Mike - so glad you were on today to help out. Looked at this data a hundred times and just couldn't see the glaring issue on that last test. But nice to see that I do not need those extra columns.

It is working in sample company SAGE 300 2019 PU2. I haven't filled the location. 

Yes, thank you. We found an answer, it worked when I only used the first three columns on the first tab.