Using Sigma function in Sage X3

By | March 21, 2014

In one of our last blog, we had seen the use of Calculator in Sage X3. Going further, we will now throw more light on the use and functionality of the same.

New Stuff: How to remove spaces from a string

To use the sigma formula, firstly we can open the calculator by pressing “Alt+Ctrl+k”. also you can open the calculator by selecting the calculator option from the Right list>>Diagnosis option.

A calculator can be used to find the order of execution of the actions in any event like a particular button click. At the Calculator prompt, type a formula “sigma(GTEST=0,1,1)” and press enter. It will activate the GTEST variable which will then display all the action to be executed in order on any event and will continue to do so unless you turn off GTEST parameter.

sigma-1

GTEST Formula

To turn off GTEST, you can use formula “sigma(GTEST=0,-1,-1)”. You can also exit X3 to turn off the parameter. Setting of this parameter is specific to the user logged in and will not affect other users.

sigma-2

Turn Off GTEST Formula

In Sage X3, the Adonix system variable “indcum” is the total index used by default in the sigma function. You can follow below link for more details:

Using Index in Sigma Function in Sage X3

We will see one of the example here to check how exactly the sigma function helps. Some times we may face the Unbalanced journal errors while running the account interface but in the log we are not able to find out the exact cause of the issue. You can see the log in below screen shot.


Account Interface Log

Log reading Screen

In that case we can use the sigma function to find out exact cause of the issue for example. Before running Account interface user can first open the calculator >> Then add Sigma function such as SIGMA(GTEST=0,1,1) >> press enter >> Then user can close the calculator screen and then click on OK button to run the accounting interface.You can see below screen shot.


Account Interface Log

Accounting Interface-apply Sigma function

In such a way system will display the Journal Posting details for that unbalance journal entry with the accounts use for particular entry , amount  etc. and referring this details user can find out exact cause of the issue. You can refer below journal posting screen for more details.

Account Interface Log

Journal Posting

also If you want to remove the sigma function from the Account Interface you can use sigma formula which is mentioned above i.e. Sigma(GTEST=0,-1,-1).

There is a certain number of functions accessible via right click in a Calculator, like:

  1. History: This function is used to display the recent formulas entered by the user.
  2. Decimal: This function is used to define the number of decimals to be used when displaying the result (0 to 24).
  3. Formula editor: This function is used to call the formula editor, to aid the user in the construction of the calculation formula.
  4. Variable classes: This function is used to give access to certain debug functions (display of a class, the table list, and open masks).

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.