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
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.