Discussions
Search Billed Sales Orders
I'm doing a search for billed sales order. I know there are at least 1,700 of them in the system. This very simple code below is returning 0 entries.
The problem appears to be with the status I am setting. Am I not setting in correctly? Should I be identifying billed SOs differently?
Const strTranType As String = "salesOrder"
smsf.operator = netsuite.webservices.SearchEnumMultiSelectFieldOperator.anyOf
smsf.operatorSpecified = True
strTypeArray(0) = strTranType
smsf.searchValue = strTypeArray
tsb.type = smsf
'status
Dim smsf3 As New netsuite.webservices.SearchEnumMultiSelectField, strStatusArray(1) As String
smsf3.operator = netsuite.webservices.SearchEnumMultiSelectFieldOperator.anyOf
smsf3.operatorSpecified = True
strStatusArray(0) = "billed"
smsf3.searchValue = strStatusArray
tsb.status = smsf3