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

From AutoCount Resource Center
Revision as of 01:45, 24 February 2020 by LaySwan (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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

Version : 1.8 / 1.9 / 2.0

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 & 2.1


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