Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
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.