Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Invoice Location vs. Shipping Location
I need to create a report that shows me all the invoices for a given period that have a location that is different from the location the items were shipped from. We call them "ship and bill" orders. Here is the scenario spelled out as simply as I can think of it:
1. Order is placed in location X.
2. Item is located in location Y, so location Y is chosen as the location on the line level, NOT the header level.
3. Item ships from location Y.
4. Invoice is created with location X in the header.
I need to identify all of these transactions in a saved search. I've tried using the location from the fulfilling/receiving transaction fields, but it does not work. I don't see a way to pick the location of a line as an option, only the header location.