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

From AutoCount Resource Center
Jump to navigation Jump to search

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

Import debtor error1.png


Possible Reason :

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

Import debtor error2.png


Solution :

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

Remove the contents for DebtorCode column.

OR ignore the DebtorCode column by copy the templates start from Company Name, but make sure the ‘Auto-create Debtor Code’ is enabled.

Then you should be able to import without Error.

Import debtor error3.png


Import debtor error4.png


Import debtor error5.png


By : Jia Zheng 190214, Lay Swan 190517, P190523



Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS
Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations