That's an error message I have not seen in a very long time.  I suspect that the data exceeds the record size. You are trying to put a record with more than 50 characters into a 50 character field.

Thanks for the reply. As is shown in the first image of the actual contents of the import file the Comment_Size field is being set to a value of  "0000" with a empty "" Comment_Text. I've also tried exporting the current contents of the extended description table then using that to attempt to import a record back in and get the same error.

The import is the same as the old import into the legacy Inventory extended description. The "000" record indicated how big the extended description is and the description is broken into 50 character chunks each with it's own sequence number.  In the "000" record there is not description just the comment size which is 4 characters meaning it can only be 9999 characters.

On the Records tab you indicate how to tell which record is the Comment Header and which is the Comment Line. Normally on the Comment Header you say that the sequence field is equal to "000" and on the Comment Line you indicate the sequence field is not equal to "000"

I had it setup that way in records tab and it correctly identified the header vs comment when I test with a 2 line import (pics below). Still when I attempt to do an actual import if fails with that error. I hate to be a bother but if you had an example of a VI import job like you were talking about previously for inventory ext descriptions I may be able to use it to spot what I've screwed up on my job.

Small update. Had more time to mess with it a bit ago. Still haven't sorted out the problem. I created another job that has all fields set to "assign" and what i believe to be good values as the default. Test passes. Still fails actual import. Screenshot of data tab below.

Make a backup or copy of WO4 and apply KB64124 from our knowledgebase, but instead expand record size of WO4 from 70 to 71 - hopefully that will fix your error.

You may need to append ~;~ at end of your descriptions you are importing to avoid Error 47's.

For Legacy files, I always recommend exporting all fields of the file you are importing into and examine the log details of manually entered entries to see how the data was written to the file.

Thanks for the reply and suggestion but unfortunately we do not have an active support contract for Sage 100 to download said KB. Is this a known issue that the above update will correct? If so I may be able to pry some funds out of accounting's kung-fu grip :P

I contacted Sage support for assistance and if needed to add a care plan but they told me that I should be able to access that KB without an active care plan and in fact I can if I'm not logged into the KB but if I'm logged in it just tells me my account doesn't have access to the website.. odd.

I reviewed the KB article and you recommended increasing the record size of WO4 to 71. I expected the KB would involve an application update because I thought the record lengths were hard coded. If I'm mistaken and there is a way to modify this myself that would be great and would appreciate further instruction.