{"id":13361,"date":"2018-07-29T10:08:12","date_gmt":"2018-07-29T15:08:12","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagex3\/?p=13361"},"modified":"2018-07-29T10:08:12","modified_gmt":"2018-07-29T15:08:12","slug":"how-to-delete-a-line-from-grid-using-web-service-in-sage-enterprise-management","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2018\/07\/29\/how-to-delete-a-line-from-grid-using-web-service-in-sage-enterprise-management\/","title":{"rendered":"How to delete a line from Grid using web-service in Sage Enterprise Management"},"content":{"rendered":"<p>You may come across a situation where you will need to delete a line from a Grid in Sage X3 using web-services. This can be achieved using the web-service operation \u201cdelete lines\u201d. Following is an example used to delete a line from Sales Order Grid using web-service tester in Sage X3.<\/p>\n<p>To run the web-service tester in Sage X3 versions 9 and higher,<\/p>\n<p><strong>Navigate to: Administrator&gt;Administrator&gt;Web services.<\/strong><\/p>\n<p>To run the web-service tester in Sage X3 versions below version 9, open the web-tester URL using the path &#8211; http:\/\/<em>x3server<\/em>:28880<u>.<\/u> Here <em>x3server<\/em> is the Sage X3 server path.<\/p>\n<p>E.g.\u00a0 http:\/\/192.168.1.177:28880<u>.<\/u><\/p>\n<p>Select the delete lines operation from the list of operations:<\/p>\n<div id=\"attachment_13362\" style=\"width: 654px\" class=\"wp-caption aligncenter\"><img fetchpriority=\"high\" decoding=\"async\" aria-describedby=\"caption-attachment-13362\" class=\"wp-image-13362 size-full\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2018\/07\/Web-service-operations.png\" alt=\"web service operations\" width=\"644\" height=\"496\" \/><p id=\"caption-attachment-13362\" class=\"wp-caption-text\">Web-service operations<\/p><\/div>\n<p>Enter the parameters in the Request screen as shown in the below figure:<\/p>\n<div id=\"attachment_13363\" style=\"width: 689px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" aria-describedby=\"caption-attachment-13363\" class=\"wp-image-13363 size-full\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2018\/07\/Web-service-request-parameters.png\" alt=\"Web-service request parameters\" width=\"679\" height=\"512\" \/><p id=\"caption-attachment-13363\" class=\"wp-caption-text\">Web-service request parameters<\/p><\/div>\n<p><strong>Pool alias\/Pool ID<\/strong> is the name of the web-service pool. E.g. SEED<\/p>\n<p><strong>Public Name<\/strong> is the name of the web service. E.g. SOH<\/p>\n<p><strong>Object keys<\/strong> will have the key and value for the object. E.g. key-SOHNUM, value-SONNA0230183<\/p>\n<p><strong>Line keys <\/strong>will have the line number that needs to be deleted. E.g. 1<\/p>\n<p><strong>Bloc key <\/strong>will contain be the name of the screen, where the grid\/table is present, and the parameter defined for the table\/grid in the screen dictionary both separated by \u2018~\u2019 for e.g. \u201cSOH4~NBLIG\u201d. Kindly refer the below screenshot to locate the parameter value in screen dictionary:<\/p>\n<div id=\"attachment_13364\" style=\"width: 878px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" aria-describedby=\"caption-attachment-13364\" class=\"wp-image-13364 size-full\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2018\/07\/Parameter-value-in-screen-dictionary.png\" alt=\"Parameter value in screen dictionary\" width=\"868\" height=\"400\" \/><p id=\"caption-attachment-13364\" class=\"wp-caption-text\">Parameter value in screen dictionary<\/p><\/div>\n<p>Click on Invoke button to execute.<\/p>\n<p>Hope this helps!<\/p>\n<p><span style=\"font-size: Medium;\"><strong>About Us<\/strong><\/span><br \/>\n<a href=\"https:\/\/www.greytrix.com\/\">Greytrix<\/a> \u2013 a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM needs. Being recognized 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 expertise.<\/p>\n<p><a href=\"https:\/\/www.greytrix.com\/\">Greytrix<\/a>\u00a0caters to a wide range of Sage Enterprise Management (Sage X3) offerings \u2013 a Sage Business Cloud Solution. Our\u00a0unique GUMU&#x2122; integrations include <a href=\"https:\/\/www.greytrix.com\/product\/sage-crm\/gumu-sage-x3-integration\">Sage Enterprise Management (Sage X3) for Sage CRM<\/a>,\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/sage-x3\/gumu-x3-salesforce-integration\">Salesforce.com<\/a> and\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/magento-sage-integrations\/sage-x3-magento\">Magento eCommerce<\/a>\u00a0along with Implementation and Technical Support worldwide for <a href=\"https:\/\/www.greytrix.com\/africa\/product\/consulting\/implementation-planning\">Sage Enterprise Management (Sage X3)<\/a>. Currently we are <a href=\"https:\/\/www.greytrix.com\/africa\">Sage Enterprise Management Implementation Partner<\/a> in East Africa, Middles East, Australia, Asia.\u00a0We also offer best-in-class\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/erp-development\/sage-x3\">Sage X3 customization and development services<\/a>,\u00a0integrated applications such as <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/pos-system\">POS<\/a> | <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/warehouse-management-system\">WMS<\/a> | <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/payment-gateway\">Payment Gateway<\/a> | <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/shipping-system\">Shipping System<\/a> | <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/business-intelligence\">Business Intelligence<\/a> | <a href=\"https:\/\/www.greytrix.com\/product\/sage-x3\/ecommerce-magento-integration\">eCommerce<\/a> and have developed add-ons such as <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-add-ons\/catch-weight\">Catch \u2013 Weight <\/a>\u00a0and <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-add-ons\/letter-of-credit\">Letter of Credit<\/a> for Sage Enterprise Management to Sage business partners, end users and Sage PSG worldwide.<\/p>\n<p>Greytrix is a recognized <a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/07\/26\/greytrix-on-boards-sage-global-rockstar-isv-program-with-gumu-for-sage-crm-sage-x3-solution\/\">Sage Rockstar ISV Partner<\/a> for GUMU&#x2122; Sage Enterprise Management \u2013 Sage CRM integration also listed on <a href=\"https:\/\/www.sage.com\/marketplace\/asb_ListingDetail?listingId=a1h24000007PC3aAAG\" target=\"_blank\" rel=\"noopener\">Sage Marketplace<\/a>; GUMU&#x2122; integration for Sage Enterprise Management \u2013 Salesforce is a 5-star app listed on <a href=\"https:\/\/appexchange.salesforce.com\/listingDetail?listingId=a0N30000000psM5EAI\" target=\"_blank\" rel=\"noopener\">Salesforce AppExchange<\/a>.<\/p>\n<p>For more information on Sage X3 Integration and Services, please contact us at\u00a0<a href=\"mailto:x3@greytrix.com\">x3@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You may come across a situation where you will need to delete a line from a Grid in Sage X3 using web-services. This can be achieved using the web-service operation \u201cdelete lines\u201d. Following is an example used to delete a line from Sales Order Grid using web-service tester in Sage X3. To run the web-service\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2018\/07\/29\/how-to-delete-a-line-from-grid-using-web-service-in-sage-enterprise-management\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[553,559,1762,1822,1926,1985,2398],"class_list":["post-13361","post","type-post","status-publish","format-standard","hentry","category-installation","tag-delete-lines","tag-deletelines","tag-sage-enterprise-management","tag-sage-x3","tag-sage-x3-server-path","tag-sales-order-grid","tag-web-service"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/13361","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=13361"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/13361\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=13361"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=13361"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=13361"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}