I am working with a client to implement Sage 100 (version 2017), and bring historical data from their prior system.

When I try to create a VI import job into this file, I only have 4 fields available: Item Number, Warehouse, Fiscal Period, Fiscal Year.  There are not any fields where I can upload Sales Units, Sales Dollars, etc.

I remember in older versions of Sage, this file was not available at all in VI, and the data had to be uploaded to the IM Transaction file and then updated into the proper period through the IM Transaction Update program...this was a lot of work and it was very easy to cause issues.

Does anyone know if this is a bug that these other fields are not available in VI or if it's that way by design?

P.S. Also a similar issue with the IM_ItemCustomerHistoryByPeriod file.