Using Sigma function in Sage X3

By | January 9, 2023

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.

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.

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.

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.

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.

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.

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).