cancel
Showing results for 
Search instead for 
Did you mean: 

This entry already exists in the following tables 'G/L Accounts' (OACT) (ODBC -2035) [Message 131-183]

Former Member
0 Kudos

Hi !

I update name of chart of account on chart of account form. SAP shows error:

This entry already exists in the following tables  'G/L Accounts' (OACT) (ODBC -2035)  [Message 131-183]

if I update the name in Edit chart of account, it's ok.Some account I can't update in Chart of account form. I don't know why

Regards,

Hong Bich

Accepted Solutions (1)

Accepted Solutions (1)

jitin_chawla
Advisor
Advisor
0 Kudos

Hi,

What is the Version you are working with?

Kind Regards,

Jitin

SAP Business One Forum Team

Former Member
0 Kudos

Hi Jitin!

I use SAP B1 version 9.0 PL4

Regards,

Hong Bich

jitin_chawla
Advisor
Advisor
0 Kudos

Hi,

Please check the following query and if results are obtained, check the list if the G\L Account which you are trying to edit is appearing in the list:

select datasource, ActId, AcctCode from OACT

where ActId <> AcctCode

Kind Regards,

Jitin

SAP Business One Forum Team

Former Member
0 Kudos

Hi Jitin

THe result as belows:

datasourceActIdAcctCode
O11211112101
O11214112103
O11215112104
O11216112105
O11217112106
O641264112
O641364113
O641464114
O641564115
O641764117
I6412136412
N641276413
N641356414
I641a6415
N641506417

Regards,

Hong Bich

jitin_chawla
Advisor
Advisor
0 Kudos

Hi,

Is your affected Account also coming in the list ?

If yes, then it would be better to log a support ticket to SAP using the Service Market Place to get the issue investigated further.

Kind Regards,

Jitin

SAP Business One Forum Team

Former Member
0 Kudos

HI Jitin!

Can I update OACT set =AcctCode=ActId?

Regards,

Hong Bich

jitin_chawla
Advisor
Advisor
0 Kudos

Hi,

Updating without support approval is not advised. It is better if you contact SAP Support for the query and sought approval to run the solution provided.

Kind Regards,

Jitin

SAP Business One Forum Team

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi Hong,

Not allowed to update/insert/delete any table in SAP. If any inconsistency in DB, SAP will not support.

Please raise ticket to SAP support.

Thanks & Regards,

Nagarajan

Answers (5)

Answers (5)

Former Member
0 Kudos

Hi Hong Bich,

These parts of unmatched codes are troublesome. They probably cause you may only update the name from edit GL account menu.

O          6412          64112

O          6413          64113

O          6414          64114

O          6415          64115

O          6417          64117

I          641213          6412

N          64127          6413

N          64135          6414

I          641a          6415

N          64150          6417

Thanks,

Gordon

Former Member
0 Kudos

Hi Gordon!

That's application error. my scenario as belows:

1. create account 6415 in Chartof account

2. SAP shows error

3. I create 641a sucess

4. I update 641a on chart of account to be 6415. update sucessful

Regards,

Hong Bich

Former Member
0 Kudos

Hi Hong Bich Tran,

check whether you  has G/L Account with same code already in system.

You can update name of G/L account anytime, Also you can update G/L code if no entry is posted in G/L Account

regards,

raviraj

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi Hong,

Run the query and check result. There is no validity mentioned in above SAP note.

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Hi Nagarajan!

There are no result with query in SAP note

Regards,

Hong Bich

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi Hong,

Please refer SAP note:

1026027 - Error when adding new Account to the Chart of
Accounts

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Hello,

You can update the 'NAME' of the accounts in 'Chart of Accounts' window.

Thanks,

Priya