Tag Archives: Tables

How to perform CRUD operations using classes and representations in Sage X3 V12.

Introduction: Sage X3 provides various features with user friendly screens and their amazing functionalities. The screens can be of various types such object based, function action based, inquiry screens , etc. For performing create, read, update and delete operations on a table, we need to have a screen for entering those data but what if… Read More »

How to delete the U tables after post-migration in Sage X3

Now days Every company wants to upgrade the system or data with newly functionality on the higher version. In Some industries the company wants to migrate the data from lower version to higher version in Sage X3. For those needs to done some steps in Sage X3 i.e., Execution of Pre-migration and Post-migration script in… Read More »

How to display user signature pending for approval to the left list of any transaction

Signature workflow feature of Sage X3 helps in tracking of transactions. Sometimes there might be a requirement if the end user needs to add additional field in left list of any transaction which will display user’s name for whom the signature is pending for approval. We can achieve this by using the following steps. Consider… Read More »

Link tables in Sage ERP X3 through coding

Function name: Link Description: Link is used to defining a set of links between various tables, as well as the single abbreviation to access these tables with one instruction. Syntax: Link class_p with list_links as class_l Refer below snippet of code for better clarification. New Stuff: How to get the number of records modified by Update… Read More »

Auditing Fields in Sage ERP X3

This is in continuation of our last post Auditing Tables in Sage ERP X3. In addition to Auditing the changes in X3 Tables, you can now easily audit specific fields of any Table. For example, if the user wants to Audit the entries in Customer screen whose ABC Class has been modified to “Class A” then the user… Read More »

Auditing Tables in Sage ERP X3

Sage ERP X3 has come up with an interesting feature through which users can now easily Monitor or Audit any changes in X3 Table. For example, if the user wants to Audit new additions into BP Customer table between a selected date ranges then they just have to activate the Audit conditions in the Customer… Read More »