We would like to assign item records to locations to be able to filter them out in a report. The report would filter out by each location and display which items are at which locations. We just acquired a bunch of locations and would like to update via csv import ideally. Is there a way to assign item records to specific locations? Certain locations would have the same item records assigned to them. Thank you!

There is a

default location

field natively on item records. Perhaps you could use that

hmm certain items would fall under several different locations

multi-select fields in general are kind of a nightmare to deal with

Would using the inventory settings by location help with this. Assigned locations will have a Preferred Stock Level >0. Other locations will have PSL=0.

@Netsuite Tragic i actually thought of this as well.. might be my best bet thank you both!