Best way to implement a sublocation of a Stockroom.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-16-2022 05:16 PM
I am new to ServiceNow and our Business is moving from Spreadsheets to ServiceNow Assets and Requests. ( YAY!)
I can see people create fields and then transform Map these fields to other tables but as I said I'm very new to ServiceNow and cannot code/ script anything to save my life.
Kind regards

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-16-2022 06:15 PM
There isn't any OOTB detailed location on assets.
It's possible to use location and create a hierarchical structure (by specifying "parent") to support bay, isle, row, and shelf. The downside of this approach is it may be difficult to find the exact location because there's only one location field related to an asset so it may be difficult to distinguish between "shelf A" in row 1 and "shelf A" in row 2.
Another option is to add a field of type "select box" with options such as bay, isle, row, and shelf to the location table. Then add fields bay, isle, row, and shelf in asset table that references the location field with a reference qualifier to only show the appropriate type.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-16-2022 08:32 PM
Cheers
We have gone and just made a stock Room for each Draw for now which works fine but just makes allot of records in the stockroom table and makes the dropdown list on the asset huge. but gets me out of a bind
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-17-2022 06:56 AM
A solution that might be worth a look:
https://www.prnewswire.com/news-releases/velocity-smart-technology---smart-collect-is-servicenow-built-on-now-certified-301195898.html

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-21-2022 01:58 PM
To me the key here is to have a proper hierarchy and well thought out and clearly defined naming convention in your Locations table. You may have to work with platform admins on creating this. There is a ‘Full Name’ field that contains the full hierarchy for each record, but most references and lookups from other tables are tied to the ‘Name’ field.
As an example, the name for the location of a Drawer should be Drawer 1 Stockroom A Building 100 City XYZ (etc). Each location node in the name being a child of the tier above. Stockroom is the parent of Drawer. Building is the parent of Stockroom. See the example below. These somewhat verbose titles help make functional sense of the data and help it be more usable within the platform.
The 'Stockroom' would be at the level of storage locker. When the ‘State’ of an Asset is “In Stock”, ‘Stockroom’ becomes a mandatory field. There is a client script that populates ‘Location’ from the ‘Stockroom’ record. However, you can manually update ‘Location’ after selecting ‘Stockroom’. In my example, select a “Drawer” location that is a child of the stockroom’s location. The benefit here is you maintain reporting integrity for both locations and stockrooms and can utilize stock rules to help manage inventory.