Tag Archives: fields

How to restrict the text based on date condition by using the cdate() function in Crystal report

Crystal report is an application used to create custom reports from a various of data sources. It includes major features such as formulas, cross-tab reports, sub-reports , special fields and conditional formatting etc. In Sage X3 recently we had an requirement that one of our client wants the hardcoded declaration based on supplier type and… Read More »

Getting number of fields in table

You may come across a situation where you would like to know the number of fields in a table. Sage X3 has a special feature of getting number of fields in a table with the help of “nbzon” keyword which will return you the value in integer. New Stuff: Bulk source verification in Sage X3 nbzon:… 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 »