Troubleshooting: Unable to delete Debtor – The value of column AccNo in table ItemPrice does not exist in its master file

From AutoCount Resource Center

Question : When I want to delete a debtor, system prompted message “The value of column AccNo in table ItemPrice does not exist in its master file.” I’ve checked there is no any document issued to this debtor, but why still cannot delete?

Version : 1.8 / 1.9 / 2.0


Possible Reason :

You’ve maintained item price book for this debtor.


Solution :

1) Go to Stock > More Stock Maintenance > Item Price Book Maintenance.

2) Filter the debtor and click on Edit.


3) You will see there are some items have set fixed price. Check the checkbox of delete and click on OK.


4) Back to your Debtor Maintenance, now you are able to delete this debtor.


By : Cheryl 190104, Lay Swan 190111, P190114


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