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

From AutoCount Resource Center

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

Version : 1.8 / 1.9 / 2.0


Possible Reason :

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


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.




By : Jia Zheng 190214, Lay Swan 190517, P190523



Go to menu

AutoCount Accounting 2.0 & 2.1


AutoCount Accounting 1.8 / 1.9
AutoCount Payroll
AutoCount POS


AutoCount On The Go
AutoCount Accounting Plug-In Documentations