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 »
Sales invoice is a bill issued by the seller and is proof the selling process has already happened. The setup of the invoice footers is used to define the numbered codes which are calculated upon valuation of the invoice footer. Based on the setup, this valuation can be performed starting from: The value defined when… Read More »
While working on one of my customization, I need to populate one customized field with a calculated value. I completed my code and found that the value was not getting displayed in the respective field. I was not sure whether my field was containing the calculated value or not. New Stuff: Copying processing files from one… Read More »
