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
Possible Reason :
You’ve maintained item price book for this debtor.
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
|AutoCount Accounting 2.0
|AutoCount Accounting 1.8 / 1.9
|AutoCount On The Go
|AutoCount Accounting Plug-In Documentations