Item code 'ABC-016' already exists [Message 3504-19]

[former_member183402]

Hi all,

I have a problem in Asset Master Data.

When I create an Item which has ItemCode like 'ABC-016' I get the following error message, Item code 'ABC-016' already exists [Message 3504-19]. I tried to query OITM where ItemCode='ABC-016' there is no result, I tried to query all the tables which have prefix of @BA_ I don't find 'ABC-016'. Different ItemCode will be created successfully

How can I solve that problem?

Please anyone can help me

[former_member183402]

I did it, thank you

[Johan_Hakkesteegt]

Hi,

I have seen similar problems posted on the forum. Could you please share your solution? It will help others with similar problems.

Regards,

Johan

[former_member678528]

Thank you! Those tables are logs I suppose. Could you please send me the same for Business partners. I will be really grateful.

[ANKIT_CHAUHAN]

Hi klarina,

This issue might occur because of a database corruption. If you have a company database where you can reproduce "Already Exists" error message for Items or Business Partners, I would ask you to raise an incident for SAP Business One Support Team to get it investigated.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[former_member678528]

Could you please give me a solution? I have the same problem.

[ANKIT_CHAUHAN]

Hi klarina,

Does any of the query return you the result? Change the ItemCode accordingly:

select * from OITM where ItemCode = 'A00001'
select * from ITM1 where ItemCode = 'A00001'
select * from ITM2 where ItemCode = 'A00001'
select * from ITM3 where ItemCode = 'A00001'
select * from ITM4 where ItemCode = 'A00001'
select * from ITM5 where ItemCode = 'A00001'
select * from ITM6 where ItemCode = 'A00001'
select * from ITM7 where ItemCode = 'A00001'
select * from ITM8 where ItemCode = 'A00001'
select * from ITM9 where ItemCode = 'A00001'
select * from ITM10 where ItemCode = 'A00001'
select * from ITM11 where ItemCode = 'A00001'
select * from ITM12 where ItemCode = 'A00001'
select * from ITM13 where ItemCode = 'A00001'
select * from OITW where ItemCode = 'A00001'
select * from AITM where ItemCode = 'A00001'
select * from AITW where ItemCode = 'A00001'
select * from OILM where ItemCode = 'A00001'
select * from OIVL where ItemCode = 'A00001'

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[fabioalmeida1]

Good morning!

I was facing this same error recently, when performing these queries we identified that the record existed in tables ITM4, ITM12 and ITM10.

As we are in a QA environment I did the Delete for validation, after deleting these records it was possible to add the item. However, I am still evaluating the possible impacts of this delete within SAP and the correlation of these tables with the item.

Sincerely,
Fábio Almeida

[Abdul]

It happens when user created the item with same code and removed by right click in this way system maintains code in log tables which through this error.

First check all log tables if there is no such result then go to help > support desk > restore numbering file. Remember restoring a numbering file without any support consultants advise is not rerecorded and always first deploy all solutions in test alfter checking the results go for live environment.