Export transactions to MS Word from Sage X3

By | December 21, 2012

The Sales quote screen in Sage X3 has a wonderful feature of saving the quote in the desired MS Word format. Even if the option of printing the report was there, but the client preferred to export it to a word. So, this feature came very handy in this scenario. Later we were asked for an option to do the same in the Sales Order screen as well.

So on further diving into this feature, we found that with a little bit of 4GL and VBA coding we can accomplish this.
You can create a base (format) document for a Specific company from:
Parameters -> General parameters -> Default documents
The VBA in MS Word enters the transaction data by referencing the tags. So, proper tags need to be added in the word document as required, for example <SOC> tags will be replaced Company field.

You can define methods in MS Word macro with requisite parameters that will take care of the data to be inserted in the document. These macros which can then be called from the 4 GL code as shown below:

The “chmulttab” function expects as parameters :
# – The name of the bookmark associated to the table
# – The number of lines for the table
# – The array containing the tag names
# – The array containing the tag types
# – le tableau contenant les valeurs des tags
CHMULTTAB = FUNCIU “chmulttab” From [M]OFFDOC With
(TABBOOKMARK,[M]NBLIG,CNAMTAGTAB(0..NBCOL),CTYPTAGTAB(0..NBCOL),CVALTAGTAB(0..NBCELLS))

Once the word format has been prepared, the word frame control, a field ‘OFFDOC’ (refer screen SQHO) with data type ‘ABO’, can be added to the required screen.

We know the requirement is strange but with such flexibility, you can always deliver what clients ask for.

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 CRMSalesforce.com 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 x3@greytrix.com. We will be glad to assist you.