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:

SCAM_Xref_import

 

 

 

 

 

 

 

 

 

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:

SPAM_Xref_import

 

 

 

 

 

 

 

 

 

Saving this as a Comma Separated Value (.CSV) to be used by the MAN Xref import process would look like this:

SPAM_Xref_import_CSV

 

 

 

 

 

Posted in: Information, Manipulation, Technical