Sage 100

I have a test upgrade 4.2 to 4.5.3 where CI_ITEM has several UDF fields. I find that one field - a UDF for Description2 where the UDF seems like it didn't copy but we find that all the others (perhaps a dozen) do. Anyone seen where one UDF selectively doesn't copy?

I just had one from 4.10 where some data didn't copy and we found a IM_90 in the directory for 4.20. There's some type of bug where if it finds this file, it pulls data from that file instead of from ci_item.

We just had a similar occurence in upgrading from 4.2 to 4.5. Many UDF fields did not update properly. Turns out the IM_90 file couldn't even be opened using a custom crystal report. ended up exporting the data and importing to the new udf field locations in CI_item using VI.

We're in the process of testing Dawn's suggestion on a re-conversion. This was an odd one because the customer remembered at one time we had an IM_90 for one single UDF. Then after upgrading they created a boatload more in CI_ITEM. The conversion converted all the UDF fields (we think) except those where there was an IM_90 equivalent. Still have to verify this but it seems like our best explanation as of now.

Dawn's advice to rename the IM_90xxx.SOA to IM_90xxx.OLD worked. I'm guessing this is only applicable to 4.1+ migrations.

That is correct.

Thanks Dawn, Great find!!