Hi,

I've been trying to find a way to run a report of open items owed to a customer, but filtered by shipping location.

Example: I have a customer that has 5 shipping locations throughout the US. I would like to run a report that shows all of the items that we owe to that particular location. I can't seem to find anything in the filter lists that will let me get to that info.

I was hoping including any of the address info would be enough, but that seems to go only by the billing. The problem being the billing address is the same for all locations.

I have just recently upgrade from 2018 Premier M&W to 2021 Premier M&W and was hoping that would be one of the new things included, but sadly, no dice.

The only thing I haven't tried is classes. If that is my only option, does anyone have a good guide on setting those up properly. Note: I also want/need to have combined data. I only really need the data split by shipping location for ease of getting shipments ready. i.e. Print out everything we have for a certain location to make sure those get prioritized together. Right now we do this with the combined list and use colored highlighters to make it a bit more easy to take in. I guess the other option is exporting that report to excel and manipulating the data there, but that seems like more work for something that should be easily done in QB. Hope I'm just missing something!

Thanks in advance for any help!!