Customer Credit note doesn't print due to wrong trans type

Hi,

I cannot get the pdf report customer credit note to show(print):
The error with the query = "...WHERE trans.trans_no='8917' AND trans.type='10' AND trans.debtor_no=cust..."

The issue I believe is that customer credit notes should be trans.type='11'

Can somebody please tell me how to remedy this situation?