Customised Approval Procedures
I am trying to create an approval procedure such that on entry of an SO by Logistics or Sales, the approval should go to the respective manager to whom the customer account belongs to.
The query is:
SELECT 'TRUE' FROM OCRD T0 where T0.OCRD.U_AT_PC = 'Central'
on trying to create an approval Template using the above query, the error i get is "No ratio defined"
Please comment on why this error is generated.
Also Will the above query work?
Peter Juby replied
Go to the Approval Templates Setup and select the Terms TAB. Make sure that none of the tick boxes are ticked under "When the following applies" and only your query is added on line 1 under "Terms based on user queries".