Skip to Content
0

Row UDF Approval Procedure Does Not Work | SAP B1 HANA

Sep 18, 2017 at 08:03 PM

13

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers