In Sage X3, you may come across various scenarios where you need to get a sub-string from an existing string. You can derive sub-string from both the ends i.e. from the left or the right or starting from any particular position of a given string. This blog will help you to extract the leftmost sub-string… Read More »
In any programming language, we need to do error handling for smooth working of any functionality. In Sage X3, the error management is done by Onerrgo instruction. When the errors are intercepted by the instruction Onerrgo, an error leads to a branching to the corresponding label. The corresponding error number can then be found in… Read More »
You may come across the situation where you need to call a bat file from Sage X3. Consider the following example: – where you need to copy the GTM file with .txt extension to the test folder with some different file name, to do so write your command line code in a file and save… Read More »
Sage X3 version 7 has a new Keyword/ function “LogicClose” which closes the open table/file faster than the close instruction of Sage ERP X3 which we used earlier in programming. LogicClose: This function closes a table logically. It releases the [F] buffer and any filters in a way that makes a further Local File execution much faster… Read More »
In some cases, we need to add the comment or some text in the detail line level. In Sage X3 we have that functionality to add the comment and some text at line level. We can add the text to line level as follows. Step 1: In the detail line level, we need to click… Read More »
We may come across a scenario where you want to move the stock from one location to another location. Sage X3 have the special feature to achieve this functionality. Follow below steps to achieve this feature: Navigate to Stock > Internal Transactions > Stock changes Enter the quantity that you want to move from one… Read More »
In some industries where the Company has only one Site which actually store and deliver goods and other sites are only financial sites which manage the payments. i.e the financial sites can be stores and the Storage site is a warehouse where goods are stored. E.g. Car showrooms can be financial sites in different part… Read More »
If we want to delete the current record in Sage X3, simply press the Delete button. This deletion is possible only if the “referential integrity” constraints as defined in the data dictionary, are adhered to, depending on the situation. These controls can take a relatively long time to perform, and they are carried out immediately… Read More »
We may have come across a situation where you need to find a particular value from a series of numerical, alphanumerical or date expressions or variables. This can be achieved using “find”. Syntax: find(value_to_seek, list_exprg) value_to_seek is the value that needs to be found list_exprg is the series of numerical/alphanumerical/date expressions/variables Example: Consider an example… Read More »
In some industries where the Company has only one Site which actually stores and deliver goods and other sites are only financial sites which manage the payments. i.e. the financial sites can be stores and the Storage site is a warehouse where goods are stored. E.g. Car showrooms can be financial sites in different part… Read More »
