Hi, I have created a stored proc to be able to search Drs Trans as well. The client specifically wanted to be able to look for amounts on payments that they can allocate to the correct Invoice.
The proc seems to be working in principle but there are 2 issues :
1. The Drill downs don't work. Gives 'Error:Debtor batch Transaction not found' I presumably need to pass the SOURCE parameter to the drill down, how can this be done. I have checked the other procs 'SO Lines' etc but they don't show the Drs selection.
2. The last select statement for 'Amount' gives an error converting numeric? 'Error:Error converting data type varchar to numeric'
I have added the convert option :
WHERE (CONVERT(varchar(MAX), DB_Trans.Amount) LIKE '%' + @SearchTerm + '%')
which runs fine in management studio BUT errors in Jiwa?
Any help would be appreciated. St proc and screenshots attached.