Finance | Project Operations, Human Resources, ...

Cannot create a record in Items (InventTable). The record already exists

(0) Share

Report

Posted on by Paras mehan

3,518

Hello Everyone,

I am done with import of the product master and after this when i am trying to import the released products for the same then i am facing the error 'Cannot create a record in Items (InventTable). Item number: xxxxxx0232, 10001.
The record already exists.

Will wait for your valuable response.

Best Regards

Paras M

All responses (6)

Answers (0)

André Arnaud de Cal... 291,431 Super User 2024 Season 2 on at

Like (0)

Report

RE: Cannot create a record in Items (InventTable). The record already exists

Hi Paras,

It will be helpful if you can explain how you imported the global products. Have you checked in the table browser if the InventTable has records? It could be the case, that this table has records, but related other tables not. In that case, the records are not visible on the released products form.
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Cannot create a record in Items (InventTable). The record already exists

Hello Paras M,

Do you operate D365FO or AX2012?

Best regards,

Ludwig
Suggested answer

SouravDam 11,721 on at

Like (0)

Report

RE: Cannot create a record in Items (InventTable). The record already exists

Hi Paras Mehan,

Let me just clear with you.

--- You have uploaded the products in system.

--- While uploading released products; you are getting this error.

--- But there is no such duplicate released product available as you mentioned.

Would like to know; are you uploading through 'Excel' ? Which data entity you are using to upload released products in ERP ? I believe; you are using the entity Released products V2 right !

In this data entity, you will find 2 tables named as ItemNumber and ProductNumber.

Bear in mind; if your item and product numbers are same, then just copy the product numbers and paste in both "ItemNumber" and "ProductNumber" columns in the datasheet which you are using for uploading purpose.

For example; if product number = 1001; then same will be used for item number.

In case if product and corresponding item numbers are different; then you need to arrange your data accordingly in your datasheet.

For example; if product number = 1001 but corresponding item number is 1005; then write '1001' in the ProductNumber column and '1005' in the corresponding ItemNumber column in your datasheet.

Again; as Zain Mehmood mentioned; please make sure you are not preparing your data with an item number which is already created / available in the system. Otherwise you will get error while uploading the data.

Kindly check and update us on this.

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.
Suggested answer

Zain Mehmood 2,715 on at

Like (0)

Report

RE: Cannot create a record in Items (InventTable). The record already exists

Hi Paras,

You will need to delete from product Master as well. Because you are using the entity products for uploading the item & it has both item number & product number in it.

Please mark YES against the answer that helps you. Thanks

Warm regards,

Zain
Paras mehan 3,518 on at

Like (0)

Report

RE: Cannot create a record in Items (InventTable). The record already exists

Hi Mr. Zain,

Thanks for response!

None of the product is existing with same Numbering in Released Products. It is only in Product Master form.

If i changed the number for importing of released products then how it will linked with product master?
Suggested answer

Zain Mehmood 2,715 on at

Like (0)

Report

RE: Cannot create a record in Items (InventTable). The record already exists

Hi Paras,

This means that you already have an item number xxxxxx0232, 10001 in the invent table. If you want to upload then you will have to change the numbering of the item or delete the items which already opened with this number sequence.

Please mark YES against the answer that helps you. Thanks

Warm Regards,

Zain