Sage 100

I'm trying to import to IM_ItemWhseHistorybyPeriod. As we all know, Sage is supposed to be making all fields available for import but while we are waiting on that, I used @AlnoorCassim 's excellent knowledge and made quantity and dollars available for import. I can see them in VI now but the import log doesn't show any values and IM_ItemWhseHistorybyPeriod is empty of any records, even though it tried to import 1,500. Is there a step I'm missing?

Why would you need to import into this file?

Hi Dawn. This new client is looking for some immediate history information in the new system. They only need to know quantities and dollars sold for the previous year so this file seemed like a good fit as opposed to importing complete inventory transaction history. I'm trying to go the easy route and probably made it 10x harder, I know.

I also went as far as importing everything into 4.3 where it works fine - then migrating to 4.5. No such luck, 4.5 file is empty after conversion.