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 »
Sage X3 has a simple function of copying the processing file from one folder to another. However we developer can move the files manually but what if I get an another option to automate this copying. New Stuff: Checking the Type of variable The function COPTRT can be used to copy the processing file one folder… Read More »
Sometimes when you do coding, you may come across a situation where you don’t know what is the data type of the variable and you may be initializing the variable which may give you “Type compatibility error”. This issue can be handled in the code. If you have a check on this variable with the… Read More »
In X3 whenever we customize a screen or create a new screen, it’s obvious that the screen has a unique field. This unique field should also have a description attached to it. For e.g. Product category is the unique field and it has its own description. New Stuff: Multi-Tier Installation of Sage X3 Now first… Read More »
What is the need for a client-server application? Well, the answer is quite simple as this provides Centralization, improves scalability and enhances flexibility. This is the same for an ERP application as well. An ERP application working on a Multi-tier model is a fundamental requirement for a growing business. Sage X3 allows distribution of its… Read More »
If we close the firm work orders in process which have been tracked before hand.The Complete function specifies the status “completed” of each operation, material and product line released. The WO status changes automatically from “in process” to “completed”. It is possible to continue to perform production tracking on a completed work order that is not… Read More »
