{"id":27162,"date":"2023-08-30T04:25:42","date_gmt":"2023-08-30T04:25:42","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagex3\/?p=27162"},"modified":"2024-11-26T09:35:52","modified_gmt":"2024-11-26T09:35:52","slug":"how-to-add-signature-workflow-in-journal-entry-screen","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2023\/08\/30\/how-to-add-signature-workflow-in-journal-entry-screen\/","title":{"rendered":"How to Add Signature Workflow in Journal Entry Screen"},"content":{"rendered":"\n<p>The Signature Workflow is a feature provided by Sage that enables automatic signatures for records that are either modified or created by the first-level user defined in the Assignment rule. Once the user signs the record, the status changes to &#8220;Signed&#8221; for that user, and the record is then passed on to the next level of users for signature, as defined in the Assignment rule.<\/p>\n\n\n\n<p>For one of our clients, we have configured a Signature Workflow for the <strong>Journal Entry<\/strong> screen in <a href=\"https:\/\/www.greytrix.com\/sage-x3-erp\/\" target=\"_blank\" data-type=\"URL\" data-id=\"https:\/\/www.greytrix.com\/product\/erp-development\/sage-x3\" rel=\"noreferrer noopener\">Sage X3<\/a>. This workflow allows approval by any user defined in the Assignment rule. To achieve this, we introduced a field labeled ZAPPFLG (Signed) within the Journal Entry header screen. We then implemented the corresponding code in the <strong>SPEGA<\/strong>S script. Upon approval, the <strong>ZAPPFLG<\/strong> field is updated with a value from the <strong>local menu 280, where the values signify: 1: No, 2: In part, 3: In full, 4: Not managed, 5: Automatic.<\/strong><\/p>\n\n\n\n<p><strong>Note:<\/strong> The Local Menu description may change based on the patch of X3.<\/p>\n\n\n\n<p><strong>New Stuff:<\/strong> <a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2023\/08\/29\/validation-on-company-name-and-gst-number-fields\/\" target=\"_blank\" data-type=\"URL\" data-id=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2023\/08\/29\/validation-on-company-name-and-gst-number-fields\/\" rel=\"noreferrer noopener\">Validation on Company name and GST number fields<\/a><\/p>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/08\/Fig1-JV-hearder-screen.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/08\/Fig1-JV-hearder-screen.png\" alt=\"Fig1 JV hearder screen\"><\/a><\/center>\n<font size=\"2\"><center>Fig1 JV hearder screen<\/center><\/font>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Follow the below steps to achieve the above requirement :<br>Create the main Workflow for Custom JV signatures management.<\/strong><\/h2>\n\n\n\n<p><strong>Step 1:<\/strong><br>-All -&gt; Setup -&gt; Workflow -&gt; Workflow Rules<br>-Create a Workflow rule with code <strong>ZJVSIG<\/strong> (Create the duplicate of any standard workflow Ex: POHSIG and change required details) as below:<\/p>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/08\/Fig2-ZJVSIG.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/08\/Fig2-ZJVSIG.png\" alt=\"Fig2 ZJVSIG\"><\/a><\/center>\n<font size=\"2\"><center>Fig2 ZJVSIG<\/center><\/font>\n\n\n\n<p><strong>Step 2:<\/strong><br>-Create a Data Model with Template Code: <strong>ZJVSIG<\/strong> (Journal Entry)<br>-In the Links tab -&gt; Main table as <strong>GACCENTRY<\/strong>.<\/p>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/08\/Fig3-ZJVSIG-Data-Model-1024x554.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/08\/Fig3-ZJVSIG-Data-Model-1024x554.png\" alt=\"Fig3 ZJVSIG Data Model\"><\/a><\/center>\n<font size=\"2\"><center>Fig3 ZJVSIG Data Model<\/center><\/font>\n\n\n\n<p><strong>Step 3:<\/strong><br>-Create an Assignment Rule with <strong>ZJVSIG <\/strong>(Custom Journal Entry Assignment rule).<\/p>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/08\/Fig4-ZJVSIG-Assignment-Rule.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/08\/Fig4-ZJVSIG-Assignment-Rule.png\" alt=\"Fig4 ZJVSIG Assignment Rule\"><\/a><\/center>\n<font size=\"2\"><center>Fig4 ZJVSIG Assignment Rule<\/center><\/font>\n\n\n\n<p>-Data Model as <strong>ZJVSIG<\/strong>.<br>-Click on values and assign the Assignment Rule as <strong>ZJVSIG<\/strong>.<br>-Keep the number of users for approval in the Number of Signatures field.<br>-Add the <strong>[F:HAE]TYP<\/strong> in the Criteria field for the JV type condition.<br>-In the Values section input the user&#8217;s codes.<\/p>\n\n\n\n<p><strong>Step 4:<\/strong><br>-Add the below header conditions for the workflow to be triggered.<\/p>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/08\/Fig5-Header-condition.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/08\/Fig5-Header-condition.png\" alt=\"Fig5 Header condition\"><\/a><\/center>\n<font size=\"2\"><center>Fig5 Header condition<\/center><\/font>\n\n\n\n<p><strong>Step 5:<\/strong><br>-Add Recipients in the Recipient tab and select &#8220;<strong>Yes<\/strong>&#8221; in the Send mail field and &#8220;With signature&#8221; in Milestone field. (Added condition &#8220;1=2&#8221; as the client doesn&#8217;t want to send mail to any user.)<\/p>\n\n\n\n<p><strong>Step 6:<\/strong><br>-Set below in the Message Tab:<br>-Select <strong>Any<\/strong> in the Management section<br>-Check Return Icon<br>-Enter the return function as <strong>SPCE<\/strong><\/p>\n\n\n\n<p><strong>Step 7:<\/strong><br>-Add below in the Context field of the <strong>Milestone<\/strong> Tab:<br>&#8211;<strong>[F:HAE]TYP<\/strong><br>-Add the below details in the Answers of Milestone:<\/p>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/08\/Fig6-Milestone-Answers-1024x230.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/08\/Fig6-Milestone-Answers-1024x230.png\" alt=\"Fig6 Milestone Answers\"><\/a><\/center>\n<font size=\"2\"><center>Fig6 Milestone Answers<\/center><\/font>\n\n\n\n<center><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/08\/Fig7-Milestone1-1024x232.png\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px; align: center;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2023\/08\/Fig7-Milestone1-1024x232.png\" alt=\"Fig7 Milestone1\"><\/a><\/center>\n<font size=\"2\"><center>Fig7 Milestone1<\/center><\/font>\n\n\n\n<p><strong>Create a workflow for Purchase Price No rule notification.<br>Step 1 :<\/strong><br>Create a Workflow rule with <strong>ZJVHSIGNCR<\/strong> (Create the duplicate of any standard workflow Ex: POHSIGNCR and change the required details)<br>-Event code as ZJVSIG<br>-Set the below conditions in the header:<br>S_ABREV=&#8221;GAS&#8221;<br>[F:HAE]ZAPPFLG=1<\/p>\n\n\n\n<p><strong>Create a workflow for Custom JV signature.<br>Step 1:<\/strong><br>Create a Workflow rule with <strong>ZJVSIGVAL <\/strong>(Create the duplicate of any standard workflow Ex: POHSIGVAL and change the required details)<br>-Event code as ZJVSIG<br>-Set the below conditions in the header:<br>S_ABREV=&#8221;GAS&#8221;<br>[F:HAE]ZAPPFLG=2<\/p>\n\n\n\n<p><strong>Creating a workflow for Custom JV Signature notification.<br>Step 1:<\/strong><br>-Create a Workflow rule with <strong>ZJVSIGNOT<\/strong>(Create the duplicate of any standard workflow Ex: POHSIGNOT and change required details)<br>-Keep the event type as Signature.<br>-Event code ZJVSIG, which is the main workflow code.<br>-Operations as VAL for Accept.<br>-Set the below conditions in the header:<br>S_ABREV=&#8221;GAS&#8221;<br>[F:HAE]ZAPPFLG=1<\/p>\n\n\n\n<p><strong>Creating a workflow for Custom JV rejection.<br>Step 1:<\/strong><br>-Create a Workflow rule with <strong>ZJVSIGREJ<\/strong>(Create the duplicate of any standard workflow Ex: POHSIGREJ and change required details)<br>-Keep the event type as Signature.<br>-Event code ZJVSIG, which is the main workflow code.<br>-Operations as REJ for Accept.<br>-Set the below conditions in the header:<br>S_ABREV=&#8221;GAS&#8221;<\/p>\n\n\n\n<p><strong>Creating a workflow for Custom JV signature cancellation.<br>Step 1:<\/strong><br>-Create a Workflow rule with <strong>ZJVSIGCAN<\/strong>(Create the duplicate of any standard workflow Ex: POHSIGCAN and change required details)<br>-Keep the event type as <strong>Miscellaneous<\/strong>.<br>-Event code CAN, which is the main workflow code.<br>-Set the below conditions in the header:<br>[F:AWS]ABROBJ=&#8221;GAS&#8221;<\/p>\n\n\n\n<p>We&#8217;ve added the 4GL code in SPEGAS scripts to set the <strong>ZAPPFLG<\/strong> fields as blank in case of entry creation and modification.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>About Us<\/strong><\/h2>\n\n\n\n<p>Greytrix \u2013 a globally recognized and one of the oldest Sage Development Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, 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.<\/p>\n\n\n\n<p id=\"block-28013e99-0882-44c6-b705-7b16c85053b2\">Greytrix&nbsp;has some unique integration solutions developed for&nbsp;<a href=\"https:\/\/www.greytrix.com\/sage-crm\/\">Sage CRM<\/a>&nbsp;with Sage ERPs&nbsp;namely&nbsp;<a href=\"https:\/\/www.greytrix.com\/sage-x3-erp\/\">Sage X3<\/a>,&nbsp;<a href=\"https:\/\/www.greytrix.com\/sage-intacct\/\">Sage Intacct<\/a>,&nbsp;<a href=\"https:\/\/www.greytrix.com\/sage-100-erp\/\">Sage 100<\/a>,&nbsp;<a href=\"https:\/\/www.greytrix.com\/sage-500-erp\/\">Sage 500<\/a>,&nbsp;and&nbsp;<a href=\"https:\/\/www.greytrix.com\/sage-300-erp\/\">Sage 300<\/a>. We also offer best-in-class&nbsp;Sage ERP&nbsp;and&nbsp;Sage CRM&nbsp;customization and development services&nbsp;to&nbsp;Business&nbsp;Partners,&nbsp;End&nbsp;Users, and Sage PSG worldwide. Greytrix&nbsp;helps in&nbsp;the migration of Sage CRM from&nbsp;Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes&nbsp;addons like&nbsp;&nbsp;Greytrix Business Manager,&nbsp;Sage CRM Project Manager,&nbsp;Sage CRM Resource Planner,&nbsp;Sage CRM Contract Manager,&nbsp;Sage CRM Event Manager,&nbsp;Sage CRM Budget Planner,&nbsp;Gmail Integration,&nbsp;Sage CRM Mobile Service Signature,&nbsp;Sage CRM CTI Framework.<\/p>\n\n\n\n<p id=\"block-4bc42a09-fb13-4598-8137-ce5f7b91ce28\">Greytrix is a recognized&nbsp;Sage Champion Partner&nbsp;for GUMU&#x2122; Sage X3 \u2013 Sage CRM integration listed on&nbsp;<a href=\"https:\/\/www.sage.com\/marketplace\/asb_ListingDetail?listingId=a1h24000007PC3aAAG\" target=\"_blank\" rel=\"noreferrer noopener\">Sage Marketplace<\/a>&nbsp;and Sage CRM \u2013 Sage Intacct integration listed on&nbsp;<a href=\"https:\/\/marketplace.intacct.com\/MPListing?lid=a2D0H000007kiHyUAI\" target=\"_blank\" rel=\"noreferrer noopener\">Sage Intacct Marketplace<\/a>. The&nbsp;<a href=\"https:\/\/www.greytrix.com\/gumu\/\" target=\"_blank\" rel=\"noreferrer noopener\">GUMU&#x2122; Cloud framework<\/a>&nbsp;by Greytrix forms the backbone of cloud integrations that are managed in real-time for the processing and execution of application programs at the click of a button.<\/p>\n\n\n\n<p id=\"block-76376301-1c3e-4250-8a09-727595a606f0\">For more information on our integration solutions, please contact us at&nbsp;<a href=\"mailto:sage@greytrix.com\">sage@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Signature Workflow is a feature provided by Sage that enables automatic signatures for records that are either modified or created by the first-level user defined in the Assignment rule. Once the user signs the record, the status changes to &#8220;Signed&#8221; for that user, and the record is then passed on to the next level\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2023\/08\/30\/how-to-add-signature-workflow-in-journal-entry-screen\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,13],"tags":[1123,3823,1341,2106,2432],"class_list":["post-27162","post","type-post","status-publish","format-standard","hentry","category-sage-erp-x3","category-integration","tag-journal-entry","tag-jv","tag-notifications","tag-signature-in-the-workflow","tag-workflow"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/27162","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=27162"}],"version-history":[{"count":15,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/27162\/revisions"}],"predecessor-version":[{"id":30244,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/27162\/revisions\/30244"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=27162"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=27162"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=27162"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}