[jshepler]

Related to my other post, I’m doing a search to find open creditmemo records on a billing account, but my filter on status isn’t working. If I add the filter, I get 0 rows returned. If I remove the filter and add the status column to the results, it clearly shows that it matches my filter.

Code:
var billingAccountFilter = search.createFilter({ name: “billingaccount”, operator: search.Operator.IS, values: “512” });
var statusFilter = search.createFilter({ name: “status”, operator: search.Operator.IS, values: “open” });
// var openCreditsSearch = search.create({ type: search.Type.CREDIT_MEMO, filters: [billingAccountFilter, statusFilter]});
var openCreditsSearch = search.create({ type: search.Type.CREDIT_MEMO, filters: [billingAccountFilter], columns: [“status”]});
var results = openCreditsSearch.run().getRange(0, 1000);

return results;

[
{
“recordType”: “creditmemo”,
“id”: “2784”,
“values”: {
“status”: [
{
“value”: “open”,
“text”: “Open”
}
]
}
},
{
“recordType”: “creditmemo”,
“id”: “2784”,
“values”: {
“status”: [
{
“value”: “open”,
“text”: “Open”
}
]
}
},
{
“recordType”: “creditmemo”,
“id”: “2784”,
“values”: {
“status”: [
{
“value”: “open”,
“text”: “Open”
}
]
}
}
]

What am I doing wrong?

I’ve tried “Open” and “open”, I’ve tried the operator “ANYOF” and passed the array [“open”] to values.
This is a cached copy. Click here to see the original post.

[Veda]

hi,

internal id for CreditMemo Open Status is: CustCred:A

Pls see: https://netsuite.custhelp.com/app/an…0memo%20status

thanks,

Veda.

[jshepler]

That worked, thanks.

[Author]

Posts