undelete Inventory ID

[houssem_temimi1]

hello:

I delete an Inventory ID,

I need to undelete

can you help me to do this?

thank you

[alexander_teslyuk]

Hello Houssem,

Should you decide to make manual changes, you'll need to delete a corresponding record in ID_USED table. After that the system will probably allow you to create an Inventory with the same ID by means of Floor Stock Receipt as Evgeniy mentioned above.

Br, Alex.

[Former Member]

Hello,

It is not possible as record is deleted from database.

Alternatively you can create a new Inventory with the same number by means of Floor Stock receipt.

Thank you,

Evgeniy Ulitin

[former_member182330]

I've just tried adding a new inv with same ID, but system doesn't allow it.

Thus - unfortunately there is no option to recreate Inv ID in the system.

Regards,
Konstantin

[former_member182330]

Hello,

Which ME version do you use? How did you delete the inventory id?

If you did it through Maintain Floor Stock - then it's impossible to undelete it in GUI as actual records get deleted from INVENTORY and INVENTORY_LOG tables.

The only way is to add the records back manually, but that would be not supported option.

Regards,
Konstantin

[houssem_temimi1]

hello:

ME version is: 6.0.4.35

I deleted from maintain floor stock

how can I add records manually , is there a request for this?

[former_member182330]

Create a INSERT statements for INVENTORY and INVENTORY_LOG and take some other records from these tables as examples.

Also, as Alex suggested, you can delete the record for the inventory id from ID_USED table and try to create new inventory id with the same name via Floor Stock Receipt.

Regards,
Konstantin