By just using different Options (Numeric or Alphanumeric) in X3, one can validate data as it is fed in the system to reduce mistakes and improve accuracy and consistency. All data types can be assigned a list of options for validating data when it is entered later on. Let’s take an example. If we assign… Read More »
As we all know that Sage ERP X3 has a multicurrency feature. Along with this feature an interesting feature of displaying the alternate currency using keyboard shortcuts has also been provided. New Stuff: Determine Record Size of Tables in X3 To view the alternate currency, follow the below steps: Select the currency box of any screen.… Read More »
You may have come across a situation where you would like to know the record size of the table which will help you know the total space taken by the table. Sage X3 has a special feature of getting size of the table with the help of “tairec” keyword which will return you the value… Read More »
There may be a scenario where you want to migrate your development from a folder to another. Its a time consuming process and many a times not a feasible one to migrate all X3 objects created during the development process. No worries Sage ERP X3 has a very special feature to carry out the above… Read More »
You may often need to write a code that performs inexact pattern matching. The use of “PAT” allows you to find data that fits a certain pattern, rather than specifying the code exactly. New Stuff: Sage Introduces New Enhancements for Sage ERP X3 v6.5 (Patch 27) Syntax pat( expr_c, pattern ) Where “expr_c” is an alphanumeric… Read More »
In the latest news from Sage, new enhancements have been introduced for Sage ERP X3 v6.5 (Patch 27) New Stuff: Using Sigma function in X3 Highlighted below are the new enhancements, improvements and corrections included in Patch 27 for v6.5 of Sage ERP X3: A) The SAFE Client v112, which is compatible with Microsoft Internet… Read More »
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… Read More »
Sometimes text values contain leading, trailing, or multiple embedded space characters. These characters can sometimes cause unexpected results when you sort, filter, or search. As these characters are not easily noticed, the unexpected results may be difficult to understand. To remove these unwanted characters, you can use “vireblc” in X3. New Stuff: Getting number of fields… Read More »
You may come across a situation where you would like to know the number of fields in a table. Sage X3 has a special feature of getting number of fields in a table with the help of “nbzon” keyword which will return you the value in integer. New Stuff: Bulk source verification in Sage X3 nbzon:… Read More »
Sage X3 has an interesting feature of verifying the multiple processing files at a time. The function AVERIFSRC is used for verifying the source files. New Stuff: How to add Sales Invoice elements in X3? Function: AVERIFSRC Path: Development>Utility>Verification>Source Verification Below is the screen shot of Source Verification screen: Fields: 1) Folder: Select the folder name… Read More »
