while adjusting starting value, the inventory was duplicated for some reason and while importing excel file, some items were duplicated. I made all such items as inactive but now my inventory shrinkage has appeared in P&L adding up to a huge amount.
so how can I remove all these inactive items from the inventory, in order to get rid of the shrinkage.
You cannot delete anything with activity, even if inactive. You will have to reactivate each item - remove all activity by deletion - then you should be able to delete the items. But be careful if any of these are not duplications or in error then any activity in these accounts could be correct and deleting them will just make things worse