on 2016 May 03 7:57 AM
Hi Expert,
We want to set approval procedure for cancellation document.
Can anyone correct my Query
SELECT distinct 'true' FROM [dbo].[OPCH] WHERE $[OPCH.CANCELED]='C'
When we are trying to cancel document not going for approval.
Regards,
Mukesh
Hi Mukesh,
Did you find a solution for this problem?
thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
It is not possible to add approval for cancelling document.
You have to control through authorization.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Try this
SELECT distinct 'true' FROM [dbo].[OPCH] WHERE $[OPCH.CANCELED]='Y'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mukesh,
I am not approval work when cancelling document but still you can give a try with below query.
if $[OPCH.Canceled] = 'C' Select 'true'
Let me know the result please.
Thanks,
Harshal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
105 | |
8 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.