While there is an Item Location Configuration type of Saved Search its fields are a bit limited and the specific result that you want is currently not available in the standard NetSuite account. This is currently an enhancement request logged on Enhancement #24401 Item Location Configuration search > Be able to use or expose the Item Fields
You can go to SuiteIdeas page to vote for the enhancement.
————————————————————————
If the “configure” link is showed, means the item location configuration record for the item & location pair has not been created yet.
So what you can do is to create 2 SS and then check manually in excel then use csv import to mass create.
1. Create a item saved search for item with inventory balance per location
In Criteria Tab:
Add Formula (Numeric) field = NVL({locationquantityonhand,0) is not 0
In Result tab:
Add Name, Inventory Location, Location On Hand fields
And a Formula (text) = {name}||’-‘||{inventorylocation} , Custom Label “Item+Loc”
2. Create a item location Configuration saved search
In Result tab:
Add Name, Item, Location fields
Add a Formula (text) field = {item}||’-‘||{location}, Custom Label “Item+loc”
P.S. Somehow I can’t add a formula (Text) field with formula in my account. You can try, if cannot can add this column in the downloaded excel later.
3. Download both SS results to excel
Use vlookup formula in excel to check “Item+Loc” field from #1 not found in the same field in #2 excel
4. Create a csv import template to Add Item Location Configuration record
Those rows in #1 that are not found in #2 are the one you need to add in Item Location Configuration record.
In the csv mapping, do map the name = Item+Loc field in excel, so that you can use the name field for cross checking with the Item+Loc field in future. (You may want to update the current item location configuration name if required)
——————————————————————————————-
From what I know, usually we don’t have to configure for all the item location whenever new locations or new items record are created. Unless your company has a requirement to set specific reorder point or preferred stock level or any other stocktake or demand/supply related settings for each item + location pair.
Item cost are usually auto computed based on the stock in and stock out transactions posted in each location. If you are using inventory adjustment to add inventory balance then the unit cost field value should manually specify instead of taking the default value in the field.
—————————————————————————————
You can try a “Item Location Configuration” Saved Search or Work Book.
image.png
If you do it from a Work Book, then you do a Join the “item location configuration” table to the item table to obtain its data.
————————————————————————————————
How can I access Item Location Configuration table from Item saved search
Per further checking, it seems that this is a current system limitation and is logged as:
Enhancement # 524401 Item Location Configuration search > Be able to use or expose the Item Fields
Since the Item fields are not exposed on the Item Location Configuration search, the same is true for the Item Search wherein the Item Location Configuration fields are not exposed as well.
At this time, the only documented alternate solution is to:
Create two searches > Export to Excel > Perform Lookup function