Skip to Content
0
Former Member
Nov 05, 2011 at 11:20 PM

Query approval procedures issue

22 Views

Hi all

I'm creating a query for approval procedure in Sales orders. This query is working fine:

 SELECT DISTINCT 'TRUE' FROM ORDR T0 
WHERE CAST ($[ORDR.DocTotal] AS decimal(19,6))>= $[ORDR.U_Credito] 

But the one above give the following error get an error: Could not commit transaction: Error -1 detected during transaction

  SELECT DISTINCT 'TRUE' FROM ORDR T0 
WHERE CAST ($[ORDR.DocTotal] AS decimal(19,6))>= ($[ORDR.U_Credito]*0.2) 

How can i multiply that field to get 20%.

The field ORDR.U_Credito is type amount

Kind Regards,

Margarida Pedroso

Edited by: Margarida Pedroso on Nov 6, 2011 12:21 AM

Edited by: Margarida Pedroso on Nov 6, 2011 12:23 AM

Edited by: Margarida Pedroso on Nov 6, 2011 12:42 AM