Well basically if you have a few thousands Items with wrong inventory value due incorrect Inventory Adjustments with zero amount(for specific locations(each location is a different costing center))... you don't have any

automatic/reliable

way to remove those adjustments lines(

you can do with script

) and re-value your inventory for that location(

no reliable or automatic way

) and re-create the adjustment(

possible with script

...)...