Mass Deletion of Records in Sage X3

By | March 3, 2017

If we want to delete the current record in Sage X3, simply press the Delete button. This deletion is possible only if the “referential integrity” 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.

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.

The “Deletion” function is used to view and modify these requests and also start the deletion of the queue of requests waiting to be processed.

Navigate: Development—->Utilities—->Miscellaneous—->Deletions

Mass Deletion of Records in Sage X3

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.

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 Identifier column and the second part (which in general is the most meaningful) in the first.

Batch Task – This function can be executed in batch mode. The Standard task ADELETE can execute it.

At the end of execution, the deletion operation creates a log file giving the results of the operation.

About Us
Greytrix – 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.

Greytrix caters to a wide range of Sage Enterprise Management (Sage X3) offerings – a Sage Business Cloud Solution. Our unique GUMU™ integrations include Sage Enterprise Management (Sage X3) for Sage and Magento eCommerce along with Implementation and Technical Support worldwide for Sage Enterprise Management (Sage X3). Currently we are Sage Enterprise Management Implementation Partner in East Africa, Middles East, Australia, Asia. 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 for Sage Enterprise Management to Sage business partners, end users and Sage PSG worldwide.

Greytrix is a recognized Sage Rockstar ISV Partner for GUMU™ Sage Enterprise Management – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage Enterprise Management – Salesforce is a 5-star app listed on Salesforce AppExchange.

For more information on Sage X3 Integration and Services, please contact us at We will be glad to assist you.