Sage ERP X3 has a special file known as TABLEAUX using which we can populate and save the data from grid to table. TABLEAUX is used only for object managed windows.

New Stuff: Purge Null Lots

TABLEAUX reduces the number of lines code. Please go through the below steps:

1. To create all lines, in document creation, it is necessary to insert in this action .
#—————————————————————————————————#
$CREATION
Gosub CREATION From TABLEAUX
Return
#—————————————————————————————————#

2.To create, modify or delete the lines, in document modification, below line is neccessary to add.
#—————————————————————————————————#
$MODIF
Gosub MODIF From TABLEAUX
Return
#—————————————————————————————————#

3. To delete all the lines, in document deletion, it is necessary to insert in this action .
#—————————————————————————————————#
$ANNULE
Gosub ANNULE From TABLEAUX
Return
#—————————————————————————————————#

4.The initial declaration of the variables necessary to the management of the grid is made by the line. it is necessary to insert in this action.
#—————————————————————————————————#
$OUVRE
Gosub DECLARE From TABLEAUX
Return
#—————————————————————————————————#

5.To correctly assign the UPDFLG and CREFLG fields and to display the data in grid it is necessary to insert in this action.
#—————————————————————————————————#
$LIENS
Gosub LIENS From TABLEAUX
Return
#—————————————————————————————————#

6. In this action we have assign some parameter as given below:
#—————————————————————————————————#
$DEFLIG
If !clalev([F:ZUD]) : Local File Z1USERHD [ZUD] : Endif
Default Mask [Z1UD] #—- Grid or Detail screen
Default File [ZUD] #—- Grid or Detail table
CRIT = ‘USR=”‘+[M:Z1UM]USR+'”‘
FICLIG = “Z1USERHD” : ABLIG = “ZUD” #—- Header table name
ZONLIG = “USOLIN”
Return
#—————————————————————————————————#

Parameters Description:
CRIT- Reading criterion
FICLIG – File name
ZONLIG- Line number Zone
Hope this helps.

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 CRM, Salesforce.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.