Cancellation Document Approval

[MukeshSingh]

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

[former_member729264]

Hi Mukesh,

Did you find a solution for this problem?

thanks

[kothandaraman_nagarajan]

Hi,

It is not possible to add approval for cancelling document.

You have to control through authorization.

Thanks

[MukeshSingh]

Hi Nagarajan Sir,

We can control through authorization but we want to make approval procedure document wise.

If we give authorization then user can cancel all marketing document but we want to set approval document wise & user wise.

Any other way to set approval process.

Regards,

Mukesh Singh

[KennedyT21]

Hi

Try this

SELECT distinct 'true' FROM  [dbo].[OPCH] WHERE $[OPCH.CANCELED]='Y'

[MukeshSingh]

Hi Kennedy,

Your approval query not working. because when we adding the document cancelled status should be "C" not "Y".

Regards

Mukesh

[KennedyT21]

what you mean, By deafult the value will be N and if you try to cancel then it will Y

CANCELED	Canceled	VarChar	1	-	N	Y
						N

[KennedyT21]

Have you checked the query first?

[MukeshSingh]

Yes I checked you query, Suppose you want to cancel A/P Invoice No-1, when you right click and click on cancel button then another document will be open that document if we cancel then Cancelled status will be "C" and document No-1 Cancelled status-Y.

[KennedyT21]

Cancelled  field can have only value Y or N . check the database table reference...

[MukeshSingh]

Database has 3 field Y,N & C.

C=Cancel document

Y=Which document cancel

N=Normal document

[Former Member]

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

[MukeshSingh]

Hi Harshal,

Your approval query not working.

Regards

Mukesh