Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Outer Join for Customers and Invoice transactions
I am having trouble creating a saved search that will display ALL customers with a custom checkbox that is set as TRUE and show the sum of all invoice transactions as of a certain date. There are customer records with the checkbox selected that have no invoices.
SELECT customer_name, city FROM CUSTOMER
WHERE {customer.checkbox=TRUE} AND {transaction.transaction_date}>03/01/2016 AND {transaction.transaction_type}="invoice"
Excuse the syntax, but the above is what I am trying to do, but I need ALL of the customers to display where the checkbox is selected (even if they have no invoice records).
0