How do you retrieve aggregated inventory number from specific locations with Netsuite?
I have 9 different locations to store inventory on Netsuite.
I created a custom field and I want to assign the total number of stocks in specific 3 locations to this field.
For example, the red squared area in the below image shows each inventory number for specific 5 locations. I want to create a custom field which has combined inventory number from those 5 locations.
I have been trying to achieve this by using workflow but so far it hasn’t been successful.
It would be great if someone can help me out here
I have done this with a report for two of my different locations. Would that work for you?
I think it will only work if your Locations are in the same subsidiary.
Can you share details on how you did this? I know this is SUPER old…but I just found it. Haha
Update the custom field using map/reduce script that runs on a pre-defined schedule.
Depending on your requirement, you can use script (scheduled or map/reduce if you want it running by itself), create a search that will return inventory for each location (you can actually sum it up on the search level) and update your custom field. You can also manipulate on which locations you want your search to pull up data with.
Hope it helps.