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

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: HOW TO ADD A SINGLE REPORT TO SAGE X3 MODULES »

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: Customization to keep track of the freight outward payment made… »

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: HOW TO CONFIGURE ZPL PRINTING IN SAGE X3 »

Invoice Sequence issue on Finder for Custom screen

In Sage X3, we have created a screen where in Tax Invoice report is getting printed from the Tax invoice custom screen. In this screen we have added a filter “From Invoice” and “To Invoice” number which filters the list of invoices which are posted in a selected range. New Stuff: Formula based Material Issue… Read More: Invoice Sequence issue on Finder for Custom screen »

How to pass dynamic data in Crystal reports from Sage X3

While working on a crystal report we come across the situation where we want to process data from several tables before running the report.  In this situation X3 provide specific coding feature where we can write code to pull data from several tables and screens and we can pass to Crystal report before running. We… Read More: How to pass dynamic data in Crystal reports from Sage… »