Tag Archives: SQL

Making Sage X3 Reports Dynamic with Miscellaneous Tables: AR/AP Report Filtering Without SQL Changes

Miscellaneous Tables in Sage X3 offer a powerful way to make reports dynamic, user-friendly, and low-maintenance. This approach is especially beneficial for reports that require customizable filters such as account codes, cost centers, item categories, and more.Sage X3 provides developers with a robust feature known as Miscellaneous Tables—logical tables used to store codes or lists… Read More »

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 »