Approval Process

[ramco1917]

Hi

   I have an approval , if the document has been approved user is still able to resend again for approval. We want to block it. How it can be done through Stored Procedure or some other way.

Regards

[felipeprevente]

Hi @ramco1917 ,

What do you mean by able to resend? From where the user is capable of re-raise the same document for approval? Could you please provide more details or screenshots to demonstrate?

Thanks,
Felipe

[ramco1917]

Hi , if Document has been approved user should not be able to send it again.

[felipeprevente]

Yes, I got it. I meant how and from where the users are doing it? Describing their steps might help on finding a solution. Thanks

[ramco1917]

Hi

  In Outgoing Payment when user clicks on Add it goes for Approval. We want when user checks in Approval Status report if it is approved then it should not allow the user to send it again for approval. As of now user can send it for approval.

Thanks

[felipeprevente]

Hi, 

You can try object type nº 140 (Payment Draft). The main table is OPDF, and PDF2 represent the lines (documents to be paid).

Put some validation to catch drafts from the same object (46) and same DocNum. Below you can find a simple join that might give you a clue about what to validate on your SP. 

SELECT
    opdf.DocNum
FROM OPDF
    INNER JOIN PDF2
        ON opdf.DocEntry = pdf2.DocNum
WHERE opdf.ObjType = 46

Hope it makes sense.
Felipe