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

From AutoCount Resource Center
(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...")
 
No edit summary
 
Line 1: Line 1:
 
'''Question :''' Error message prompted “These columns don't currently have unique values.” when Import Debtor thru Excel?
 
'''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]]
 
[[File:Import debtor error1.png]]

Latest revision as of 01:45, 24 February 2020

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


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