Have you ever come across a circumstances in Sage X3 where you would like to do prepayment with tax .Sage X3 has a feature where you can do the prepayment with tax. To successfully bring this functionality follow below steps. Navigate to: Development>Activity codes>TPT activity code Select TPT activity code. Remove the check mark from… Read More »
There can be a situation when we want to accept string in some text field by end user and want to check its existence in Sage X3 database ignoring case sensitivity. The toupper or tolower functions are very useful to perform this function. toupper is used to transform all the lower case letters of a… Read More »
There might be a scenario where user needs to change the state of any transaction. For example, user wants to alter transaction mode from “Modification” to “Create”. To accomplish this task Sage X3 have a simple variable “REP” which stores the transaction status and can be used to for this task. In below code snippet,… Read More »
Sage X3 V7 have a new feature where we can assign an icon to any of the module. We have created a customized module ‘Test’ and assigned an Icon to it. Please refer below screenshot. To assign the module icon we need to follow following steps: Your icon image should be in ‘.png’ format. Icon… Read More »
You may come across the situation, where you may want to give selection window for customer contact. In Sage X3, we can add selection (F12 functionality) and filter the selection records as per our requirement. Follow below steps to add F12 selection functionality for Customer contact: 1. Add the Button field action on field and… Read More »
You may come across the situation, where you may want to filter the production selection by descriptions. That is user will enter part of a product or product descriptions in product field and on tab out system will display only matching product in the selection list. The standard ITS product-site object being used for product… Read More »
You may come across a situation where you want to append leading Zeros to a number but don’t know how to achieve it. This can be handle with the help of the “format$” keyword which will append the leading Zeros to the number. Format$ : Dim is used to format the expression based on particular… Read More »
You may come across a situation, where you need alternate to the “like” keyword of SQL, that is to search for sub-strings in columns of the table. The one way to achieve it to use instr() function, instr() function takes 3 parameters in account. Syntax : instr( rank, string, sub_string ) Rank: Integer type expression… Read More »
Sage X3 has a feature in which you can assign Delivery type to an Order type. This feature can be achieved by following below steps:- Navigate to Set up -> Sales -> Document types → Delivery types. Create as many types of deliveries as you want as shown in the below screen. Now go to… Read More »
Sage Business Partner Conference – South Africa begins next week starting 26th January and we are excited to be exhibiting there once again this year. Greytrix – known for its award winning GUMUTM Integration framework would be showcasing its flagship products and services i.e. Sage X3 integration with Salesforce, eCommerce (Magento), Sage CRM which are built on robust… Read More »
