{"id":10043,"date":"2017-03-03T08:53:28","date_gmt":"2017-03-03T08:53:28","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagex3\/?p=10043"},"modified":"2019-03-04T09:27:02","modified_gmt":"2019-03-04T09:27:02","slug":"mass-deletion-of-records-in-sage-x3","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2017\/03\/03\/mass-deletion-of-records-in-sage-x3\/","title":{"rendered":"Mass Deletion of Records in Sage X3"},"content":{"rendered":"<p style=\"text-align: justify;\">If we want to delete the current record in Sage X3, simply press the Delete button. This deletion is possible only if the &#8220;referential integrity&#8221; constraints as defined in the data dictionary, are adhered to, depending on the situation. These controls can take a relatively long time to perform, and they are carried out immediately online when the delete function is called.<\/p>\n<p style=\"text-align: justify;\">In case if several deletions are to be performed, it would be very time consuming to run them one at a time. So the deferred deletions function is preferred for multiple deletions. The deferred deletion loads a database table, which stores all the current deletion requests.<\/p>\n<p style=\"text-align: justify;\">The \u201cDeletion\u201d function is used to view and modify these requests and also start the deletion of the queue of requests waiting to be processed.<\/p>\n<p style=\"text-align: left;\"><strong>Navigate: Development&#8212;-&gt;Utilities&#8212;-&gt;Miscellaneous&#8212;-&gt;Deletions<\/strong><\/p>\n<p style=\"text-align: center;\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter wp-image-10044\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2017\/03\/Mass-Deletion-of-Records-in-Sage-X3.png\" alt=\"Mass Deletion of Records in Sage X3\" width=\"652\" height=\"173\" \/><\/p>\n<p style=\"text-align: justify;\">When using the function, a grid is displayed containing the current deletion requests in the form of the object code and the values of the keys.<\/p>\n<p style=\"text-align: justify;\">It should be noted that when the key for the record managed by the object has a single part, only the first column is entered ; However, if there are two parts to the key, the first part is located in the second <em>Identifier<\/em> column and the second part (which in general is the most meaningful) in the first.<\/p>\n<p style=\"text-align: justify;\"><strong><u>Batch Task<\/u><\/strong><strong> &#8211;\u00a0<\/strong>This function can be executed in batch mode. The Standard task ADELETE can execute it.<\/p>\n<p style=\"text-align: justify;\">At the end of execution, the deletion operation creates a log file giving the results of the operation.<\/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>If we want to delete the current record in Sage X3, simply press the Delete button. This deletion is possible only if the &#8220;referential integrity&#8221; constraints as defined in the data dictionary, are adhered to, depending on the situation. These controls can take a relatively long time to perform, and they are carried out immediately\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2017\/03\/03\/mass-deletion-of-records-in-sage-x3\/\">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":[8],"tags":[201,560,1256,1859,1941,1942],"class_list":["post-10043","post","type-post","status-publish","format-standard","hentry","category-sage-erp-x3","tag-batch-mode","tag-deletion-operation-creates-a-log-file","tag-mass-deletion-of-records-in-sage-x3","tag-sage-x3-delete-record","tag-sage-x3-technical","tag-sage-x3-technical-assistance"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/10043","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=10043"}],"version-history":[{"count":3,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/10043\/revisions"}],"predecessor-version":[{"id":15533,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/10043\/revisions\/15533"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=10043"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=10043"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=10043"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}