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

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

Delete debtor error1.png


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.

Delete debtor error2.png


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

Delete debtor error3.png


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


  AutoCount Accounting 1.8 / 1.9
  AutoCount Payroll
  AutoCount POS


  AutoCount On The Go
  AutoCount Accounting Plug-In Documentations