Troubleshooting: Import Member error - The value of column AccNo in table Member does not exist in its master file

From AutoCount Resource Center

Question: When I import Member from Excel, error message prompted “The value of column AccNo in table Member does not exist in its master file”. Why?

Version: 1.9 / 2.0

Import member1.png


Possible Reason:

This is a known bug which only happen when the Excel template does not have value in DebtorCode.


Solution:

You may input the DebtorCode to link with this Member and import again.

If there is no debtor to link, a temporary solution is lick on the button “Switch to Old Version” on the top.

Import member2.png


Copy from Excel and Paste from Clipboard to import again.

Import member3.png


By: Benjamin 220713, Lay Swan 220727, P220728



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