I accidentally ended up with almost duplicate Inventory ID’s for some products.
Correct Inventory ID - HEMWPAAD2027 - not associated with any other records
Incorrect Inventory ID - HEMWPAAD02027 - SO’s and inventory all associated with this ID.
Difference is the 0 after the D.
I am trying to delete HEMWPAAD2027 as a tock item, which it looks like it does.
Then I want to Change ID on stock item HEMWPAAD02027 to the now deleted (but correct) ID of HEMWPAAD2027.
I hit delete, and it appears that this item is now deleted.
I try to change ID on HEMWPAAD02027 to the ID I just deleted, but get this error:
I hit OK and it somehow goes back to the Inventory ID I just deleted.
I’m not sure what to do. How do I go about deleting and changing the ID’s?
Thanks,
Page 1 / 1
Can you rename HEMWPAAD02027 then delete it, then rename the other one?
HI @nathankeating
Are there any transactions associated with the incorrect item? Sales Orders, PO’s, Inventory transactions?
@kandybeatty49@jbuddecke71
Thank you for your responses. Yes, the incorrect item ID, HEMWPAAD0202, is the one with all the transactions associated with it so it cannot be deleted whether I change the ID to anything else or not.
After “deleting” HEMWPAAD2027, I can’t search it or find it anywhere in ACU. As far as I can tell, it is deleted. That is until I try to change the ID of HEMWPAAD02027 to HEMWPAAD2027, then all of a sudden it gives the error in screenshot 2 and when I hit OK, it resorts to the “deleted” record in screenshot 3.
Is there a way to permanently delete a stock item that I’m missing?
Hi @nathankeating
The system will not allow you to change the ID to an item that has been deleted.
@kandybeatty49 thanks for clarifying. That seems weird and not the answer I wanted, but thank you for answering none the less.
@kandybeatty49 thanks for clarifying. That seems weird and not the answer I wanted, but thank you for answering none the less.
Happy to help!
@kandybeatty49 - is it possible to “un-delete” a deleted item?
@kandybeatty49 - is it possible to “un-delete” a deleted item?
Hi @mikeho once an item is deleted, you can not recover it.
@Kandy Beatty Do you know of a way to safely delete the marked as deleted inventory ID from the database if it isn’t associated with any other records? We are having a similar issue here, and I am comfortable working with SQL but I don’t want to just delete something like this without a script.
@Kandy Beatty Do you know of a way to safely delete the marked as deleted inventory ID from the database if it isn’t associated with any other records? We are having a similar issue here, and I am comfortable working with SQL but I don’t want to just delete something like this without a script.
HI @tararosenthal
If there is nothing associated with the record, you should be able to delete it. If not, you will need to run a script. Otherwise, I would suggest reaching out to your partner or Acumatica for assistance.
Hi @nathankeating
Check this thread. This approach should let you use deleted entity ID.
The system will not allow you to change the ID to an item that has been deleted.
Is acumatica for real with this logic? What if I create a stock item in error, Delete it and now want to recreate it...im just out of luck and can’t use the same Item ID again? Who is making these calls at Acumatica because that is not logical at all. If the stock item is not related to ANY transactions I should 100% be able to delete it and recreate it with the same exact item code.
