For all the MAN modules simply requiring the OLD Code, NEW Code and optionally the NEW description, using a product such as Microsoft Excel (as per the below image), place:
– the OLD Codes in the first column
– the associated NEW Codes in the second column
– the optional NEW descriptions in the third column
and then save the spreadsheet as a CSV (Comma delimited) (*.csv) format which will be able to be imported into the required cross reference module.
The StockCode ProductClass Account Manipulation (SPAM) module requires OLD Product Class, Stock Code and NEW Product Class and would therefore require three columns with the OLD Product Class in the first column, the Stock Code in the second column and the NEW Product Class in the third column:
Saving this as a Comma Separated Value (.CSV) to be used by the MAN Xref import process would look like this: