Purging and Archiving Data in Sage X3 – Using Purge Data

By | February 24, 2012

We have already discussed briefly on the Purge Tool in our previous blog, now we will proceed with the execution of the Purge Parameters in Sage X3.

Development>Data and Parameters>Development Setup>History/Purge

Initially we will define the Purge Code in Sage X3. This function is used to define the archiving and purging procedures for a table and possibly any associated detail tables, as well as all the tables linked to it in the dictionary and whose cancellation code is set to deletion.

Check Product: Salesforce – Sage X3 Integration

The user has an option to define formula which is used to define the additional filters to archive the records. The purge function uses this formula when the archiving is not activated by the parameters.

We need to set the parameters against the purge code defined above, this will decide if the data will be archived or purged and the frequency of operations will be decided.

Lastly, we can go for purging of the data through the Usage Menu; The Utility will provide the option of Archiving/Purging the data. The option will also facilitate the user with an option of simulating the purge before proceeding for actual purge/archive.


Hope this blog helps you in defining the Purge/Archive parameters.

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged 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 competence.

Greytrix caters to a wide range of Sage X3, a Sage Business Cloud Solution, offerings. Our unique GUMU™ integrations include Sage X3 for Sage CRMSalesforce.com, Dynamics 365 CRM and Magento eCommerce along with Implementation and Technical Support worldwide for Sage X3. Currently we are Sage X3 Implementation Partner in East Africa, Middle East, Australia, Asia, US, UK. 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 and India Legislation for Sage X3 to Sage business partners, end users and Sage PSG worldwide.

Greytrix is a recognized Sage champion ISV Partner for GUMU™ Sage X3 – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage X3 – Salesforce is a 5-star rated app listed on Salesforce AppExchange and GUMU™ integration for Dynamics 365 CRM – Sage ERP listed on Microsoft AppSource.

For more information on Sage X3 Integration and Services, please contact us at x3@greytrix.com, We will like to hear from you.