{"id":21404,"date":"2020-12-29T04:07:04","date_gmt":"2020-12-29T04:07:04","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagex3\/?p=21404"},"modified":"2020-12-29T04:09:25","modified_gmt":"2020-12-29T04:09:25","slug":"how-to-close-po-programmatically-using-4gl-script","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2020\/12\/29\/how-to-close-po-programmatically-using-4gl-script\/","title":{"rendered":"How to \u2018Close PO\u2019 programmatically using 4GL Script"},"content":{"rendered":"\n

In Sage X3<\/a>, User have option to close Purchase order manually by using \u201cclose order\u201d button on Purchase order screen. But one of our client has requested to automate this process on certain event so that user doesn\u2019t have to take of this manually. To achieve this we have come up with some customization on PO screen where we did the 4GL code. Using the standard subprogram from standard script, we able to do it successfully. Lets look at the subprogram code.<\/p>\n\n\n\n

New stuff:<\/strong> Restriction on Purchase Invoice Creation<\/a><\/p>\n\n\n\n

Syntax:<\/strong><\/p>\n\n\n\n

Call TRTPOHCLE (WPOHNUM, WMSGFLG, WRET) From TRTACHDIV1<\/p>\n\n\n\n

Here is the meaning of each parameter value,<\/p>\n\n\n\n

WPOHNUM:<\/strong> Purchase order number
WMSGFLG:<\/strong> It is Integer value which indicates error message
0:<\/strong> No error Message
1:<\/strong> error on screen (Call ERROR)
2:<\/strong> GMESSAGE+GERROR
3:<\/strong> Message in trace
WRET:<\/strong> (Return Code) It Contains an integer value.<\/p>\n\n\n\n

By calling above subprogram we can close the Purchase order.<\/p>\n\n\n\n

Through above syntax we can close the purchase order by calling TRTPOHCLE subprogram from standard script with proper parameters.<\/p>\n\n\n\n

Example:<\/p>\n\n\n\n

Here we have created one Purchase order as shown in below screenshot which is showing closed order status \u201cNo\u201d means PO is not closed yet.<\/p>\n\n\n\n

\"Purchase<\/a><\/center>\n
Purchase Order screen- Closed Status “No”<\/center><\/font>\n\n\n\n

Now, call the Subprogram with appropriate parameter as mentioned in below script screenshot to close PO.<\/p>\n\n\n\n

\"Script\"<\/a><\/center>\n
Script<\/center><\/font>\n\n\n\n

After execution of script, Purchase order got closed as shown in below screenshot.<\/p>\n\n\n\n

\"Purchase<\/a><\/center>\n
Purchase Order screen- Closed Status “Yes”<\/center><\/font>\n\n\n\n

In this way, any programmer who knows the 4GL scripting can do this customization easily.<\/p>\n\n\n\n

About Us<\/strong><\/h2>\n\n\n\n

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

Greytrix has some unique integration solutions developed for Sage CRM<\/a> with Sage ERPs namely Sage X3<\/a>, Sage Intacct<\/a>, Sage 100<\/a>, Sage 500<\/a>, and Sage 300<\/a>. We also offer best-in-class Sage ERP and Sage CRM customization and development services to Business Partners, End Users, and Sage PSG worldwide. Greytrix helps in the migration of Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes addons like  Greytrix Business Manager, Sage CRM Project Manager, Sage CRM Resource Planner, Sage CRM Contract Manager, Sage CRM Event Manager, Sage CRM Budget Planner, Gmail Integration, Sage CRM Mobile Service Signature, Sage CRM CTI Framework.<\/p>\n\n\n\n

Greytrix is a recognized Sage Champion Partner for GUMU™ Sage X3 \u2013 Sage CRM integration listed on Sage Marketplace<\/a> and Sage CRM \u2013 Sage Intacct integration listed on Sage Intacct Marketplace<\/a>. The GUMU™ Cloud framework<\/a> 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

For more information on our integration solutions, please contact us at sage@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"

In Sage X3, User have option to close Purchase order manually by using \u201cclose order\u201d button on Purchase order screen. But one of our client has requested to automate this process on certain event so that user doesn\u2019t have to take of this manually. To achieve this we have come up with some customization on\u2026 Read More »<\/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":[13,8,2796],"tags":[20,3174,3175,1565,2157],"class_list":["post-21404","post","type-post","status-publish","format-standard","hentry","category-integration","category-sage-erp-x3","category-technical","tag-4gl","tag-closed-po","tag-programmatically","tag-purchase-order","tag-status"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/21404","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=21404"}],"version-history":[{"count":7,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/21404\/revisions"}],"predecessor-version":[{"id":21477,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/21404\/revisions\/21477"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=21404"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=21404"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=21404"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}