error in creating new dimension (Cannot create a record in Inventory dimensions (InventDim)The record already exists)

(0) Share

Report

Posted on by xain

491

Hello every one

i am trying to post movement journal, we have enabled new dimension fields(location,inventory status,license plate), so when we are trying to post it , we are getting Cannot create a record in Inventory dimensions (InventDim). Dimension No.: CSTG-000899, 5637169657.The record already exists. any lead what could be problem child here. thanks

All responses (6)

Answers (1)

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

Like (0)

Report

RE: error in creating new dimension (Cannot create a record in Inventory dimensions (InventDim)The record already exists)

Hi xain,

Thanks for coming back with your own answer. I have marked this one to close the thread with the status 'Answered'.
Verified answer

xain 491 on at

Like (0)

Report

RE: error in creating new dimension (Cannot create a record in Inventory dimensions (InventDim)The record already exists)

Hello every one,

thanks all for the messages, sorry for the delay, yes i get it resolved, it was Sync issue, i sync the tableI(inventDim) and it works like charm.
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: error in creating new dimension (Cannot create a record in Inventory dimensions (InventDim)The record already exists)

Hello xain,

Have you been able to get your issue resolved or do you need any other help from the community?

Best regards,

Ludwig
Suggested answer

Junaid Idrees on at

Like (0)

Report

RE: error in creating new dimension (Cannot create a record in Inventory dimensions (InventDim)The record already exists)

Hi Xain,

It seems like, you would have some problems with number sequences. Please Check your inventory module number sequence 》》 "Dimension Number". Right click on this numbering sequence and make sure It is non continous and no number is stuck in status list.
HenryXie on at

Like (0)

Report

RE: error in creating new dimension (Cannot create a record in Inventory dimensions (InventDim)The record already exists)

Hi Xain, you can use InventDim::FindorCreate(_invDim) function to create invent dimension.
André Arnaud de Cal... 291,735 Super User 2024 Season 2 on at

Like (0)

Report

RE: error in creating new dimension (Cannot create a record in Inventory dimensions (InventDim)The record already exists)

Hi xain,

Can you check if the dimension number was already used before? So, is the number sequence having the correct next value?

Can you tell if there are some other customizations in your environment, like a security policy in this table?