Erp Forum: The Sage Forum Site

I have done an import from sage mms 2.2 to sage 200.
The Analysis fileds have become corrupted.

In mms I have the analysis field as nwsales and it is coming through in Sage 200 as nwsanwsales

How can this be corrected? has sage released an upto date import module?

I had the same problem

use sql script to correct. something like

update SYSTraderAnalysisValue
set Name = substring(Name,5,30)