We do not currently have status field for items that are assigned to subinventories and had to add a DFF, which is for information/reporting purposes only. We need to have functioning item status field at subinventory level to plan/perform cycle counts correctly and update/clean-up inventory over time (standard Inventory functionality). We cannot delete items from subinventory to maintain data integrity and our system integration with Maximo. Maximo does not allow deletion of items once an item is assigned to a storeroom, we can inactivate items but not delete.
This
is causing issue as we cannot ignore/exclude subinventory items in inactive
status in our cycle count because we are using a DFF.