Does anyone know how to show and search the Location_no field on the Inventory Parts screen.
We have some parts where the default location is set but that part doesn’t show on the ‘parts in stock’ tab of the warehouse navigator. As a result, the warehouse staff cannot delete the location because that default location exists on another part. The user has no way to find out what part is stopping them from deleting the location.
Thanks
Hi,
I would think the quickest / easiest solution would be to request a quick report - typically provided by IT. A quick report commonly can be created by advanced users, but typically managed by IT.
The default locations (could have multiple per part) may not be best type of attribute to add to the inventory parts screen where 1 record is shown per part. A quick report would present the data in an easy way such that you can search for the location.
Best regards,
Thomas
+20
CONTRACT || PART_NO IN (SELECT CONTRACT || PART_NO FROM INVENTORY_PART_DEF_LOC WHERE LOCATION_NO = 'xxxxx')
The user running this search must have permissions to view INVENTORY_PART_DEF_LOC, so this may need run under the Appowner ID.
+13
Could you not just get a Custom Field added to retrieve Default Location?
+20
Could you not just get a Custom Field added to retrieve Default Location?
It would need to be a field in which multiple values would be strung together as one inventory part can have up to three default locations; one of type Arrival, one of type Picking/Floor Stock/Production Line, and one of type Quality Assurance.
As noted in the response above, if a User just wants to search in the Inventory Parts page to ‘find all parts that have ‘xxxx’ listed on the Default Locations tab’, the User will need permissions to view INVENTORY_PART_DEF_LOC. Without this permission, I am not sure if the User would see any data in the custom field.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
