FAQ / + What is the format of the MAN Comma Separated Value (.CSV) Xref import file

For all the MAN modules simply requiring the OLD Code and NEW Code, using a product such as Microsoft Excel, place the OLD Codes in the first column and the associated NEW Codes in the second column:











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:







Posted in: Information, Manipulation, Technical