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: Generating Comma-Separated Values in Sage X3 Excel Reports Using STUFF… »

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: Validation on Company name and GST number fields »

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: How to print a field once which is repeating 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 verify if there are duplicated values in a series

uni is used to verify if there are or not duplicate values in a series of numeric, alphanumeric or dates variables. uni returns the rank of the first value equal to a previous value from the list, that is to say : New Stuff: How to set task status as completed by default in Customer relation?… Read More: How to verify if there are duplicated values in a… »

How to know if the duplicate values present in the given expression…?

Function name: uniis used to verify if there are duplicated values in a series of variable or numeric expressions, alphanumeric expressions or dates. uni returns the rank of the first value equal to a previous value from the list, that is to say: If the first and the second are identical, uni returns 2 If… Read More: How to know if the duplicate values present in the… »