cancel
Showing results for 
Search instead for 
Did you mean: 

changing site for an Inventory ID

houssem_temimi1
Participant
0 Kudos

hello

we created 2000 Inventory ID in a wrong site

how can we change sites?

NB: the 2 sites are local .

is there any way to do it.

ME version: 6.0.4.46

Houssem

Accepted Solutions (1)

Accepted Solutions (1)

sergiy_katerinich
Active Contributor
0 Kudos

I would set WIP.INVENTORY.QTY_ON_HAND for all of them to zero by means of a direct query to the database. Then archiving will move them to ARC tables.

And you can re-create all those Inv IDs at a necessary site because those IDs should be unique within a site only but not cross-site.

If you want to move the IDs from one site to another, I would not recommend that way because you will have to update all *_BO fields of at least 5 tables (if none of the Inv IDs has been used so far).

Regards,

Sergiy

sergiy_katerinich
Active Contributor
0 Kudos

Or instead of a manual update to the database, you can try Scrap method of InvenotyService PAPI.

Answers (0)