Does anyone know the relationship between an invoice and support case? We are trying to write a script to update all invoices tied to support cases to put a message on them and can't find the relationship. In the UI we see the transactions related to the case but using XML=t I cant see anything on either side.

Do a search and use the transaction join

var invoiceSearchObj = search.create({

type: "invoice",

filters:

[

["mainline","is","T"],

"AND",

["type","anyof","CustInvc"],

"AND",

["case.internalid","noneof","@NONE@"]

],

columns:

[

"tranid",

search.createColumn({

name: "internalid",

join: "case"

}),

search.createColumn({

name: "createddate",

join: "case"

})

]

});

Thanks!