on 06-23-2015 8:48 PM
Hello All,
I created a new company before couple of days ago. Now I am unable to delete one cash G/L from Chart of Account.
With manager's account:
Data > Advanced > Delete is disabled.
On Right click, I am not getting 'Delete' option.
'Title' & 'Active Account' radio buttons are disabled.
Level is '4' which is the lowest one.
How to check whether it is holding any entries?
Please suggest, how to delete it?
Hi,
How to check whether a particular GL has linked to transactions or not?
Open Modules > Financials > Chart of accounts
Chart of accounts window opens in find mode. Enter your account code/ Name and click on Find
Result: Selected GL Account details shown in "OK" mode.
If you can see orange arrow key on Balance field, then this particular GL having transactions.
Or you run below query in query generator. If you get results then its having transactions.
SELECT T0.[TransId] FROM JDT1 T0 INNER JOIN OACT T1 ON T0.[Account] = T1.[AcctCode] WHERE T1.[AcctCode] =[%0]
How to Delete an unused GL Account
Module > Financials > Edit Chart of accounts
Edit Chart of accounts Selection Criteria window opens
Select Drawer in which you need to edit or delete and click "OK"
Edit chart of accounts window Opens
Click on "Find" on tool bar or Click "Ctrl+F" to select your GL Account.
Right Click on account and select Advanced > Delete Account and Click on Update.
Thanks & Regards
Unnikrishnan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for the reply.
Query doesn't generate any result for that G/L code means there is no transaction made on that.
In Edit COA on right click I can see only 'Copy' option, there is no 'Advanced' option available.
Then I tried accessing 'Advanced' from menu option but it's disabled, see below picture.
Is there any script for deleting it from database? I think this is last option left.
if you have transactions on that account, then u cannot delete it.
Frank
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.