Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Results Not Showing Because One Field Is Null
I thought my issues were over once Herdi Rana-Oracle successfully solved my previous issue regarding this Saved Search.
The Search is to gather data on invoices.
My final issue is as follows.
Order field causes my search to exclude invoices that are not tied to a sales order.
We do have invoices that are not related to sales orders.
Criteria:
Main Line is true.
Type is any of Invoice, Credit Memo
Result fields are as follows:
Order
Customer (Main Line): ID
Customer (Main Line): Name
Date
Status
Document Number
Est. Extended Cost (Transaction)
Formula (Currency) NVL({netamount},0)-NVL({shippingamount},0)-NVL({taxtotal},0)
Jay Schwausch
P.R.I. - KACE Valves, NetSuite Administrator