Skip to Content

Row UDF Approval Procedure Does Not Work | SAP B1 HANA

Hello experts:

On SAP Business One 9.1 PL: 08 for HANA

I am trying to do an approval procedure that works when there is a value greater than zero in a UDF of the sales order lines, but I do not get it to work.

It gives me internal error and then the document is created.

I have tried these 4 ways:

---1---

Select distinct 'true' from dummy where ((select count(*) from dummy where $[RDR1."U_forfree".Number] > 0 ) > 0 )

---2---

Select distinct 'true' from dummy where ((select count(*) from dummy where $[RDR1."U_forfree".1] > 0 ) > 0 )

---3---

Select distinct 'true' from dummy where ((select count(*) from dummy where $[$38."U_forfree".Number] > 0 ) > 0 )

---4---

Select distinct 'true' from dummy where ((select count(*) from dummy where $[$38."U_forfree".1] > 0 ) > 0 )

.

Someone can help me please.

Thank you.

Ivonne.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers