In Sage x3 many times you may want to know when and who changed, deleted or added a record to a table. This is possible using the Auditing feature in X3. You can turn Auditing on for select tables and fields and then see who modified, added or deleted from this table. We do suggest… Read More: How to Use Auditing in Sage X3 »
In Sage X3, workflow auditing involves tracking and recording the changes made to any documents as they progress through the workflow. This is useful for maintaining transparency, ensuring compliance, and identifying any discrepancies or issues in the process. Below are general steps to set up and perform workflow auditing on sales orders in Sage X3… Read More: Sage X3 Workflow Auditing Streamlining Transparency Across Operations »
In Sage X3, we make sure of import/export templates quite often for importing huge data with ease. However sometimes the importing data templates are acquired through any external client application which might have different external data parameters which in Sage X3 are stored in different internal codes. Sage X3 provides us a Setup module that… Read More: Use of Transcribe Import/Export template 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: Database Optimization Function in Sage 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: How to use Columns in Sage ERP X3 »
You may come across the situation where you would like to know the count of index(keys) in the table which may help you. Sage x3 has a special feature of getting keys of the table with the help of “nbind” keyword which will return you the value in number. New Stuff: How to create the Recurring… Read More: Count the number of keys(index) in the table. »
While working on one the projects, we came across a situation where Sage ERP X3 was not updating the existing index in SQL server table whenever we added the activity code and did the validation even though the activity code was active. GUMU™ Sage CRM Integrations: Sage ERP X3 | Sage 100 | Sage 500 | Sage 300 After some R&D, we… Read More: Revalidate database objects using activity code »
In our last blog we have discussed the “Options” feature in the Table Block of the Screens, now lets check how it works. The below screen is GL Journal Entry [Lines Tab], which comprises table with option “KARID4S”, this option will enable the features as per the abbreviations set. i.e. K- Previous & next line… Read More: Implementing Screen created using Table/Grid Option “KARIDAS” »
Sage X3 allows an easy method to design screens, where in we have option to design screens in the form of Blocks. These Blocks can be of different types, List, Table, Dialogue etc. Now as you know that, Header and Detail screens are indispensible in any ERP software. It is an industry practice to display… Read More: Designing Screen using Table/Grid Option “KARIDAS” »
