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

From AutoCount Resource Center
Revision as of 11:17, 30 July 2022 by LaySwan (talk | contribs) (Created page with "'''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 File:Import member1.png <u><b>Possible Reason:</b></u> This is a known bug which only happen when the Excel template does not have value in DebtorCode. <u><b>Solution:</b></u> You may input the DebtorCode to link with this Member and import again. If there is no debtor to link...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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 1.8 / 1.9
AutoCount Payroll
AutoCount POS


AutoCount On The Go
AutoCount Accounting Plug-In Documentations
Retrieved from "https://wiki.autocountsoft.com/wiki/Troubleshooting:_Import_Member_error_-_The_value_of_column_AccNo_in_table_Member_does_not_exist_in_its_master_file?oldid=21128"