Tag Archives: Tables

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 »

Using Miscellaneous Tables in Sage ERP X3

Sage X3 has provided the developers with an extensive feature called Miscellaneous Tables, Miscellaneous Tables are logical tables to store codes/List of Values for e.g. Rules, Terms, Payment Methods, etc.. it comes handy whenever we need to provide users with options/dropdowns to have strict data integrity. There are 2 types of the Miscellaneous table: Independent… Read More »