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.
Transaction search questions
We are creating a reporting program in c# that requires querying transaction records of type salesOrder and of type cashSale.
I set up a search that will grab those two record types within a certain date range. However, the program also requires that we filter out cashSales that were created by a sales order. Is there any way to achieve this?
here's a snippet of where I search for salesOrder and cashSales
//limit to only sales orders and cashSales SearchEnumMultiSelectField sm = new SearchEnumMultiSelectField(); sm.@operator = SearchEnumMultiSelectFieldOperator.anyOf; sm.operatorSpecified = true; sm.searchValue = new string[2] { "_salesOrder", "_cashSale" }; salesOrderSearch.type = sm;
I was poking around the object browser in VS 2005 and noticed a createdFrom field available in cashSales.
0