Tag Archives: Duplicate

Generating Comma-Separated Values in Sage X3 Excel Reports Using STUFF (SQL Server)

Sage X3 is built to support real-life business scenarios, such as creating a single invoice from multiple sales orders or deliveries, and applying multiple payment or receipt entries to one invoice. However, when this information is presented in reports—especially Excel reports—it is often displayed across multiple rows. This leads to repeated invoice details, making the… Read More »

Validation on Company name and GST number fields

Sage X3, formerly known as Sage Business Cloud Enterprise Management, is an ERP software suite that includes integrated functionality for financial management, sales, customer service, distribution, inventory, manufacturing, and business intelligence. Recently we had a requirement in Sage X3 from one of our client, that the Customer Name(Company Name field in the Customer Master) and… Read More »

How to print a field once which is repeating in Sage X3 report

In Sage X3, developer has freedom to develop their own reports in Crystal reports as per their client requirement. So we have also developed one of the report in India pack report called as Vendor transaction/Ledger report. This report display all the vendor transactions for selected parameter range. In this report, there is section where… Read More »