cancel
Showing results for 
Search instead for 
Did you mean: 

Delete G/L Account (Current Asset > Cash)

Former Member
0 Kudos

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?

Accepted Solutions (1)

Accepted Solutions (1)

former_member212181
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Unnikrishnan,


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.

former_member212181
Active Contributor
0 Kudos

Hi CP,

I think, it is older version of SAP (Version 7 or below).

I don't have same environment to check here.

Please try Modules > Financials > Chart of accounts > Select GL Account and Remove in tool bar.

Thanks

Unnikrishnan

Answers (1)

Answers (1)

frank_wang6
Active Contributor
0 Kudos

if you have transactions on that account, then u cannot delete it.

Frank