Tag Archives: Multiple

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… »

How to Restrict Single Delivery Creation from Multiple Orders in Sage X3

Sage X3 offers functionality allowing the consolidation of multiple orders into a single delivery. If your business process requires limiting such entries to prevent confusion during invoice report printing, follow the steps below: While creating Order there exist an option of Invoicing Mode, with choices including 1/Order, 1/Shipment, and 1/Invoice. Choose the ‘1/Order’ option. Users… Read More: How to Restrict Single Delivery Creation from Multiple Orders in… »

Multiple grid lines selection & operation in Sage X3

In Sage X3, we often work on data grid screens/masks where managing operations on multiple lines such as deletion, copying etc. becomes a hassle. However Sage X3 offers the users a way which operates with ease as shown below in an example of a patch creation where we want to remove several objects which are… Read More: Multiple grid lines selection & operation in Sage X3 »