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

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.

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation competence.

Greytrix caters to a wide range of Sage X3, a Sage Business Cloud Solution, offerings. Our unique GUMU™ integrations include Sage X3 for Sage CRMSalesforce.com, Dynamics 365 CRM and Magento eCommerce along with Implementation and Technical Support worldwide for Sage X3. Currently we are Sage X3 Implementation Partner in East Africa, Middle East, Australia, Asia, US, UK. We also offer best-in-class Sage X3 customization and development services, integrated applications such as POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons such as Catch – Weight  and Letter of Credit and India Legislation for Sage X3 to Sage business partners, end users and Sage PSG worldwide.

Greytrix is a recognized Sage champion ISV Partner for GUMU™ Sage X3 – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage X3 – Salesforce is a 5-star rated app listed on Salesforce AppExchange and GUMU™ integration for Dynamics 365 CRM – Sage ERP listed on Microsoft AppSource.

For more information on Sage X3 Integration and Services, please contact us at x3@greytrix.com, We will like to hear from you.