RE: 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
Update the custom field using map/reduce script that runs on a pre-defined schedule.
