I've been asked to build a saved search that I'm currently not certain how to execute, but will be reporting my progress and asking for help here.
My colleague wants to be able to look at a location and for the search to go "I see that in this/these location(s) you have 2 wheels, 1 frame, 200 chain links, 1 pair of front brakes, 1 pair of back brakes and thus you would be able to build X number of bikes."
We are using a manufacturing template of NetSuite, but we mostly use it for managing BoMs and Assembly items which we send to our suppliers. So perhaps there's already a feature in NetSuite that can do this for me if configured?
Otherwise, curious to hear thoughts on what kind of search/report I should be trying to build for this. Gonna be continuing my own research in the mean time.
Thanks!
Resources:
___________________
I can't seem to follow the insturctions in the above article as the navigation to Customization > Lists Records, & Fields > Other Sublist Fields isn't appearing.
___________________
I found the below post, but it doesn't actually detail how to turn it on and most of the links are broken.
The SuiteAnswer referenced in the post also doesn't appear to exist anymore.
___________________
Found this:
Which mentions that the Centre is in a defected state and to use the direct url to nav to Other Sublist FIelds:
https://YourAccountNumber.app.netsuite.com/app/common/custom/othersublistfields.nl?whence=
_____________________
Progress
Now I need to input the correct BoMs I'm searching for and figure out how to limit the search to use only the components in a particular location and/or subsidiary.
_____________
Really uncertain how I can limit the search to a particular location. I think I may need to set various BoMs that are each restricted to individual locations.
_____________
Tried restricting the BoM to a subsidiary and location, but the BoM revision is still looking for inventory from all locations and subsidiaries. There doesn't seem to be a way to restrict the BoM Revision on where the components are to come from, that seems dumb.
______________________________
Thanks @Tris Mendoza-Oracle , perhaps I can use a script and leverage the Bill of Material Inquiry to pull the information I need.