Skip to Content
0
Former Member
Oct 20, 2010 at 04:09 AM

Approval Procedure Query

5558 Views

Hi, all

I create U_Dept at document header and I want have an approval base on this U_Dept input. For eg, U_Dept input = A or B. I save 2 queries as below:

Query A

-


SELECT distinct 'true' from OQUT T0

WHERE T0.U_Dept = 'A'

Query B

-


SELECT distinct 'true' from OQUT T0

WHERE T0.U_Dept = 'B'

2 Approval Stage created = manager A and manager B

2 Approval Template created =

Template 1 put in Query A, approve by manager A

Template 2 put in Query B, approve by manager B

Both template with same originator

When I simulate the transaction, prompt 2 approval templates either I choose Dept A or Dept B. The result that I wish to reach is if I choose Dept A, template 1 prompt else if I choose Dept B, template 2 prompt. Can this be done?

Regards

Cheh Lu