View source for Troubleshooting: Import Debtor error - These columns don't currently have unique values

'''Question :''' Error message prompted “These columns don't currently have unique values.” when Import Debtor thru Excel?

<b>Version :</b> 1.8 / 1.9 / 2.0

[[File:Import debtor error1.png]]


<u><b>Possible Reason :</b></u>

One or more column(s) in excel templates were not correctly maintained. 

[[File:Import debtor error2.png]]


<u><b>Solution :</b></u>

You cannot have <<New>> in the column of DebtorCode.

<span style='color:red'>Remove</span> the <span style='color:red'>contents</span> for <span style='color:red'>DebtorCode</span> column.

OR ignore the DebtorCode column by <span style='color:red'>copy the templates start from Company Name</span>, but make sure the <span style='color:red'>‘Auto-create Debtor Code’</span> is enabled.<br/><br/> 
Then you should be able to import without Error.

[[File:Import debtor error3.png]]


[[File:Import debtor error4.png]]


[[File:Import debtor error5.png|1150px]]


By :  Jia Zheng 190214, Lay Swan 190517, P190523


{{NavigateForUser}}

[[Category:Users]]