{"id":31812,"date":"2026-01-30T11:08:16","date_gmt":"2026-01-30T11:08:16","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagex3\/?p=31812"},"modified":"2026-01-30T11:46:42","modified_gmt":"2026-01-30T11:46:42","slug":"generating-comma-separated-values-in-sage-x3-excel-reports-using-stuff-sql-server","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2026\/01\/30\/generating-comma-separated-values-in-sage-x3-excel-reports-using-stuff-sql-server\/","title":{"rendered":"Generating Comma-Separated Values in Sage X3 Excel Reports Using STUFF (SQL Server)"},"content":{"rendered":"\n

Sage X3<\/a> 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\u2014especially Excel reports\u2014it is often displayed across multiple rows. This leads to repeated invoice details, making the report lengthy and difficult to read.<\/p>\n\n\n\n

From a business user\u2019s perspective, related references\u2014such as sales order numbers or payment\/receipt entry numbers along with their dates\u2014are expected to be consolidated and displayed clearly against a single invoice, typically in a comma-separated format.<\/p>\n\n\n\n

By combining these related details into a single, comma-separated view, reports become more compact, easier to understand, and visually cleaner. This not only enhances readability but also results in a more professional and business-friendly report output.<\/p>\n\n\n\n

Recently, one of our Sage X3 clients requested exactly this enhancement: to display multiple payment or receipt entry numbers and their corresponding dates against a single invoice number in an Excel report.<\/p>\n\n\n\n

Example Scenario<\/strong><\/p>\n\n\n\n

As shown in Figure 1, there are two separate payment\/receipt entries recorded against a single invoice number. In the standard report output, these entries appear in separate rows, resulting in repeated invoice information.<\/p>\n\n\n\n

New Stuff:<\/strong> Seamless ISD Distribution in Sage X3<\/a><\/p>\n\n\n\n

\"Figure<\/a><\/center>\n
Figure 1 Example Entry<\/center><\/font>\n\n\n\n

Instead of displaying each payment or receipt entry on a separate line, the requirement is to combine all related entries and display them in a single cell, separated by commas. This provides a cleaner and more readable report format.<\/p>\n\n\n\n

To achieve this consolidation, we can use the following SQL function:<\/p>\n\n\n\n