Item Location Name Change

ramakr

Member
Hi List,

We have a requirement on changing the item location name in all locations in the Branch plant. This will require changes in the existing inventory records in the table.

Is there any application/report to do it?

Any inputs on these would be helpful.



Thanks in advance.

Regards,
Menaka
B7333/SP24.1.2
 
No, there is no application to do this.
Consider that its not just the Inventory Location tables that are affected. Any other table that references Item Numbers, Quantities, and locations are also affected, such as Sales Order Detail, Work Order Header and Parts List, etc. Changing the value of the Location fields in the Location Master and Item Locations tables without also simultaneously updating all affected locations in other tables would introduce a severe data integrity problem.

FYI there are 217 tables with the LOCN field in them
wink.gif


Cheers,
 
Hi,

Thanks for your reply. I agree with the data integrity problems you have told.
Are we able to do it using manual updations?

Is it possible to use Item Reclassification application(P4116) to create a new location and map all those records?

Any guidance on this would be helpful.

Thanks,
 
Back
Top