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

From AutoCount Resource Center
Jump to navigation Jump to search

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?

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

IconAcc20.PNG AutoCount Accounting 2.0


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