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

From AutoCount Resource Center
Revision as of 07:24, 31 May 2019 by LaySwan (talk | contribs) (Created page with "'''Question :''' Error message prompted “These columns don't currently have unique values.” when Import Debtor thru Excel? File:Import debtor error1.png <u><b>Possi...")
(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?

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