Troubleshooting: Unable to delete account no. xxx-xxx. The reason is account no. xxx-xxxx. has been used in Cash Book Detail

From AutoCount Resource Center
Jump to navigation Jump to search

Question : When I try to delete account code 491-0000 in Account Maintenance, an error message prompted: Unable to delete account no. 491-0000. The reason is account no. 491-0000 has been used in Cash Book Detail…… but I couldn’t find any transaction of this account ?

Version : 1.8 / 1.9 / 2.0


Used in cbdtl1.png


Used in cbdtl2.png


Possible Reason :

The account has been used in Cash Book Entry but the transaction is cancelled.


Solution (1) :

1) Go to G/L > Cash Book Entry > Print Cash Transaction Listing.

Used in cbdtl3.png


2) Click on Advanced Filter…., make user No Filter is selected for Cancelled Document, under Detail Search Fields, select Account No 491-0000, and click on Search.

Used in cbdtl4.png


3) Here shows the result of documents that involved the account code.

Used in cbdtl5.png


4) You may double click on it to open the document. It is a cancelled document, if you wish to delete the account code 491-0000, you will need to delete this document first, or change the account code for this document.

Used in cbdtl6.png


Solution (2) :

You may find out the document involved using AutoCount Management Studio.


1) Login Auto Count Accounting Management Studio.


2) Go to Tools > SQL Query. System will prompt you a warning message, just click onYes. A blank SQL Query box will be prompted.


Used in cbdtl7.png


Used in cbdtl8.png


3) Type the following SQL query:

select * from cb where dockey in (select dockey from cbdtl where accno = '491-0000')

After that, click on Execute.


Used in cbdtl9.png


4) From the result, you get the Doc No PV-000006. You may login to AutoCount, open the document from Cash Book Entry and delete the document or edit account number before you can delete the account code from Account Maintenance.


By : Fatin 200323, Lay Swan 200326, P200327


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