How to conditionally restrict the Import update…!

By | May 26, 2014

Many a times we use Import/Export feature to create or update the transaction in Sage ERP X3. As the Import/Export is performed on the standard code it is too difficult to control the creation or modification of records. In one of our customization’s, we were using the Work Order Operation import function, but we had found one drawback during the process, that it also updates closed operations.

GUMU™ for Sage CRM – Sage Enterprise Management Integration ~ Real-time, Bi-directional

After some R & D we have a way to restrict the import function. The AP_IMPORT action is called while importing the file. In this action we can write our logic to control the transaction updation.

E.g. To overcome on the above problem we have written the below logic in AP_IMPORT action. We just opened the same (Work Order operation) table with another abbreviation and checked the operation status. If the operation status is closed we would just reassign the original values to the main table. Now whenever we import the Work Order operation and if any of operation is closed it will just reassign the previous values and will not update the records.

Kindly refer the below snippet of code for better clarification.


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.