Tag Archives: Table

Database Optimization Function in Sage X3

In sage x3, we have a function called database optimization which is used to track or create custom index. This function help us for easy reapplication when updating or migrating data set. It is useful  to create the indexes in order to achieve a specific optimization (for example in a report or to optimize a… Read More »

How to use Columns in Sage ERP X3

You may come across a situation where you would like to update only few fields from the table. So we are using “Columns” keyword in Sage X3 to accomplish desired requirement. New stuff: How to find the name of the window Description: The “Columns” instruction is only taken into account by the For loop and Rewrite instructions.… Read More »