Skip to Content
0
Former Member
Aug 05, 2016 at 10:31 AM

Approval Template Not Applied Consistently

21 Views

Hi all,


I am hoping someone can help me with the problem below -

I have set up a new query to send PO’s for QA approval if the supplier status is Red or Awaiting Classification, in a UDF I created on the Master Data tab.

The query is as follows:

SELECT DISTINCT 'TRUE'

FROM OPOR T0

INNER JOIN OCRD T1 ON T0."CardCode" = T1."CardCode"

WHERE T1."CardCode" = $[$4.0] AND (T1."U_Approval_Status" = 'Awaiting Classification')

But when I am testing it, it’s working for some suppliers and not others, and I have no idea why? E.g. Trying to create a PO for S1004, you get the pop up in the attached image Example 1.

But trying to create a PO for S1005, you get the pop up in the attachment Example 2.

Both have the same approval status in the OCRD UDF (Example 3).

If anyone has come across this before or knows what else I can look at, it would be really helpful. I am running SAP Business One HANA version 9.1.


Thanks a lot.


Ali

Attachments

Example 3.png (4.5 kB)
Example 2.png (8.1 kB)
Example 1.png (9.0 kB)