Category Archives: Technical

How to solve if added tab in window is not visible after global validation of window

Sometimes, it happens when we add any customized screen or tab in window, we are not able see the customized screen added in the window. Also, it might happen you may see the fields of the added tab in the window but not added tab. We mostly solve this issue by global validation of window… Read More: How to solve if added tab in window is not… »

How to add selection screen on field action

In Sage X3 , selection screen on a particular field helps users to search easily and select as per the requirement. In Sage x3, If user want search selection should be there on any field, then it is easy if we are directly using custom data type for the same, but if we have used… Read More: How to add selection screen on field action »

Top 3 Benefits of Greytrix Professional Services

Greytrix is one of the leading ERP vendors and CRM vendors globally, providing low cost, high quality Professional Services for ERP softwares like Sage X3, Sage 100, Sage 300, Sage 500, Sage Intacct and CRM softwares like Sage CRM, Microsoft Dynamics 365 CRM, Salesforce with over two decades of experience and 250+ developers & consultants.… Read More: Top 3 Benefits of Greytrix Professional Services »

How to store CLOB variable data to the table through webservice

CLOB stands for Character Large Object, CLOB stores large amounts of character data ,up to 4GB in size. CLOB data may be very large, some database management systems do not store the text directly in the table. Instead, the CLOB field serves as an address, which references the location of the data. New Stuff:- How… Read More: How to store CLOB variable data to the table through… »

How to increase no. of characters in Line text entry using import template

Sometimes, it happens we need to insert description for particular line in any transaction using import template and the standard just allows limited text in line text entry like for around 194 characters. We can increase this number of characters by doing few changes in import/export template of that particular transaction. Consider example for a… Read More: How to increase no. of characters in Line text entry… »

Payment & Prepayment deletion through the custom button from Sales Order

In Sage X3, we are working on payment integration from x3 to the third party payment gateway. Here, we are doing sale/auth/refund/void transactions on the client’s payment gateway through Sales Order/Invoice transactions from X3. Here, we will provide prepayment & payment deletion functionality through the void button. New Stuff:- How to change the LOT’s expiration… Read More: Payment & Prepayment deletion through the custom button from Sales… »

How to enable select all check box in the left side panel in Sage X3

As we all know, in Sage X3 when users want to create Purchase invoice against purchase receipt, he/she has to select receipt from the left list one by one. Recently one of our client wanted to have an option to select all Receipts in a single click from the left side panel while creating purchase… Read More: How to enable select all check box in the left… »

Change the Date Format Using 4GL Script

As we know, Sage X3 supports multiple date formats as per the user’s requirement. The default date format in Sage X3 is set in setup–> Parameters. The developers who want to manipulate the date field value can use the date format using 4GL script. Also, there is an inbuilt string function that can be useful… Read More: Change the Date Format Using 4GL Script »

How to Exclude Weekends From Total Number of Days in Crystal Report

In sage X3, we have a functionality of printing various types of reports such as Order, Invoice, Payments, and Receipt etc. This report is created by using a crystal report. Crystal Report is a very powerful tool used to pull data from sage and present it in a ways you want. Sometimes in crystal report,… Read More: How to Exclude Weekends From Total Number of Days in… »

How to add checkbox in Crystal Report

There are many instances when client wants to give multiple copies of the invoices to their customers, where they must segregate multiple copies into original and duplicate. So we have given option on the report for those client where at the header part Original and Duplicate check boxes are given. So if the specific invoice… Read More: How to add checkbox in Crystal Report »