How to display user signature pending for approval to the left list of any transaction

By | April 21, 2021

Signature workflow feature of Sage X3 helps in tracking of transactions. Sometimes there might be a requirement if the end user needs to add additional field in left list of any transaction which will display user’s name for whom the signature is pending for approval. We can achieve this by using the following steps.

Consider a purchase order transaction in which the signature workflow is active.

Navigate to All -> Development -> Data and parameters -> Tables

Fig: Workflow tracking archive table

Enter the table code “AWRKHISSUI” as shown in above figure.

This table holds the tracking data for signature workflows.

Fig: Adding new index

Go to “Index” section of the “AWRKHISSUI” table and add new index as shown above which consists of combination of “CLEDEC” and “FLGSIG” field. “CLEDEC” field represents the transaction number of any transaction and “FLGSIG” field represents the signature flag.

Navigate to All -> Development -> Script Dictionary -> Objects

Fig: Opening table in Object

As we are considering purchase order transaction, so enter its object code and go to its “Environment” section in which we need to add workflow tracking archive table and the index we created above with the expression as “[F:POH]POHNUM;3” as shown in above figure, where POHNUM represents transaction number field and “3” is signature field which will represent “To be signed” status for the user signature pending in the workflow.

Fig: Adding new field to selection

Go to “Selection” section in the object screen and add the table “AWRKHISSUI”, User signature pending field “DEST” which will display for whom the signature is pending for approval, as show in above figure.

Navigate to All -> Setup -> Workflow -> Workflow rules

Fig: Workflow rule

As shown above, select the purchase order workflow code which is “POHSIG” and jump to the assignment rules selected for the workflow. Here, it is “YPOHSIG”.

Fig: User assignment values

Add the desired users in the values of assignment rule as shown in above figure.

Now, if we navigate to Purchase order transaction, create one transaction and check its signature circuit, we will be able to see “YUSR1” which is first user yet to be signed as shown in below figure.

Fig: Signature circuit (a)

Since, “YUSR1” is yet to be signed. Hence, we are able to see “YUSR1” in “User Signature pending” field of left list.

Fig: User1 to be signed

After Signature of first user, that is “YUSR1”, if we open signature circuit, we will be able to see second user “YUSR2” is yet to be signed as shown in below figure.

Fig: Signature Circuit (b)

And also we can see “YUSR2” in left list of transaction as expected in the below figure for that transaction.

Fig: User2 to be signed

This blog helps us to add additional field to the left list of any transaction showing which user’s approval is pending for that transaction.