Category Archives: Technical

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 »

How to Call an API Through POSTMAN Tool and Map With X3 Fields

We come across the scenario, where we will use POSTMAN software tool to examine the working of external API. Postman is a simple GUI for sending HTTP requests and viewing responses. REST services are available in Sage x3 which returns data in a JSON format. In this blog, we are going to visualize the mapping… Read More: How to Call an API Through POSTMAN Tool and Map… »