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

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

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.

Copy from Excel and Paste from Clipboard to import again.

By: Benjamin 220713, Lay Swan 220727, P220728

Go to menu

AutoCount Accounting 2.0 & 2.1 AutoCount Accounting 2.0 What's New AutoCount Accounting 2.0 Help File AutoCount Accounting 2.0 FAQ (Application) AutoCount Accounting 2.0 FAQ (Troubleshoot) AutoCount Accounting 2.0 Others AutoCount Accounting 2.0 Release Note AutoCount Accounting 2.1 Release Note

AutoCount Accounting 1.8 / 1.9 AutoCount Accounting 1.8 FAQ (Application) AutoCount Accounting 1.8 FAQ (Troubleshoot) AutoCount Accounting 1.8 / 1.9 Release Note

AutoCount Payroll

AutoCount POS

AutoCount On The Go

AutoCount Accounting Plug-In Documentations