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

@smelanson In the Inventory Parts page, in the SQL Where expression in the Advanced search, enter your location no. in place of xxxxx:

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.

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.