Skip to Content
0
Former Member
Sep 27, 2008 at 08:27 AM

Query for PO Approval

231 Views

Dear Sir / Madam;

Please Help, We try to made Query for PO Approval with condition if PO Type "ITEM" have to approve by Purchasing Manager, but for PO Type "SERVICE" have to approve by General Affair Manager.

We Create Query for this condition " SELECT * FROM OPOR WHERE T0.[DOCTYPE]='I'

We already create the stage, and this query is not work. But if try to set the total Doc greater than 1000000, it is work.

Dear Sir / Madam, please help me to send me the right query ?

Thanks for your help

Regards

Petrus