Skip to Content
0
Aug 14, 2023 at 03:52 AM

Error in Query Approval (Doctotal < DebitLimit)

99 Views Last edit Aug 21, 2023 at 08:12 AM 2 rev

Hello Guys,

I had written a query approval that whenever the Delivery Doctotal is Less than the Customer Commitment it should promt to approval.

Error is "Could not commit transaction. Error -1 detected during transaction (RDR1).

Both query i did below are giving me error.

1.

SELECT distinct 'True' from ODLN where $[$29.0.Number] < $[OCRD."DebtLine"]

2.

SELECT distinct 'True' FROM ODLN T0 INNER JOIN OCRD T1 ON T0."CardCode" = T1."CardCode" where $[$29.0.Number] < $[OCRD."DebtLine"]

Please help me solve this problem.

Thanks a lot.