Tag Archives: Report

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 »

HOW TO ADD A SINGLE REPORT TO SAGE X3 MODULES

As a user in Sage X3, you may have to run specific reports as part of your daily routine. Setting up a report as a single item for a particular module can help improve work flow and minimize any confusion you may have on which report to run. In the example below, we will be… Read More »

Customization to keep track of the freight outward payment made with reference to Sales Invoice

Freight-outward is the shipping and handling cost incurred by a company for delivering finished goods to a customer. It is paid by the seller, not by the purchaser. So in Sage X3, seller mention freight charges in the Sales Invoices. Sometimes, Transporters generate bill multiple times against same Sales Invoice. So it was difficult to… Read More »

HOW TO CONFIGURE ZPL PRINTING IN SAGE X3

Sage X3 provides us a functionality to print labels and barcodes using ZPL printer. ZPL stands for zebra programming language and using this language we can design the layouts of labels and embedded barcodes. In this blog we will see how the ZPL setup is configured in Sage X3. Below are steps to configure ZPL.… Read More »

Adding levels in Requester

We have come across the situation, where we design Requestor and then we also want to add the levels to Requestor. Sage X3 has a special in-built feature to add levels in requester. New Stuff: How to determine if a mask variable can be entered or displayed? Follow the below instructions to add levels to… Read More »

Calling of Report through code

Normally the reports are printed just by clicking on the Print Button, but what if we come across scenarios when we need to open the report on runtime. New Stuff: How to open a Closed Purchase Receipts in X3 But no worries we will be guiding you with the same, there is an easy way to… Read More »