You may come across a situation, where you may want to calculate the factorial value of an integer. Sage X3 has special command “Prd” to accomplish the situation. New Stuff: How to find the logarithm Prd: Calculates the product of any number of variables or numeric expressions. Syntax: Prd Kindly refer to the below one line snippet… Read More »
In Sage x3 we have many mathematical functions like sin, cos, factorial, avg etc. In this blog we are going to look for how to find the logarithm for given number. There is function “LN” which help us to find the logarithm. New Stuff: How to apply a new License in Sage X3 V6.5 Syntax:… Read More »
Follow below steps to apply a new License in Sage Enterprise Management V6.5. Copy the new license to the server system where Sage X3 is installed. Stop all Sage X3 services. Go to command prompt and run services.msc New Stuff: How to extract a sub-string from a given String value If it is a Client… Read More »
You may come across the situation, where you want to extract the substring from a given string. Sage X3 has a special function to extract substring from given String. New Stuff: How to filter the table with user defined conditions in Sage X3 seg$: This function is used to extract a sub-string located between two positions… Read More »
You may come across the situation, where you want to filter the X3 table/view with the user-defined conditions through code. The following sample code will help you to provide the user defined conditions to filter the table. New Stuff: How to validate begin and ending range in X3 grid…? Step 1: Declare the variables and open… Read More »
In day to day business activity there comes many scenario were the end user creates transaction from existing one that may be a sales order, purchase order or product etc. While doing so user has to confirm the transaction to make a copy even though this is a needed validation but it creates additional efforts… Read More »
You may come across the situation, where you want that, In CRM whenever user creates new call entry that time by default call should be marked as Completed. New Stuff: How to Execute Miscellaneous Type Workflow Programmatically Sage X3 has special settings to set call by default marked completed Follow the steps, Step 1: Go to, Setup… Read More »
There can be occasions when you want to validate begin and ending sequence range in X3 grids. New Stuff: How to change the default index in X3? In a custom development I have come across the above scenario where in I have to validate the grid line entry to validate the begin and ending rangs. After… Read More »
You may come across the situation, where you want to change the default index while reading the table. In Sage x3, we can set the index which is to be assigned in the criteria. New Stuff: Automatic Contract Invoice Generation Here we have the product table with various indexes and associated with row number. In the… Read More »
This function is used for invoice generation from service contracts and their invoice open items. Navigate to Sales > Invoices > Automatic Contract Invoice Generation New Stuff: How to Execute Miscellaneous Type Workflow Programmatically All the option on the above screen is optional entries. This information is used target the invoicing to a group of contracts. Criteria… Read More »
