Author Archives: Greytrix

Sales Order creation in Sage X3 using EDI 850 documents

The EDI 850 is a Sales Order transaction set used to place an order for goods or services. Also known as an electronic purchase order, an EDI 850 is usually sent to a vendor as the first step in the ordering process. The EDI 850 generally provides the same information you would find in a… Read More: Sales Order creation in Sage X3 using EDI 850 documents »

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 »

How to create pie chart in Sage Enterprise Intelligence (SEI) report

Sage Enterprise Intelligence is an intuitive business intelligence solution integrated with your Sage business management system to help business users reduce time spent on analysis and reporting and make faster, better-informed decisions. It empowers all users with a simple solution to access and analyse data in a self-sufficient manner, which eliminates the need for disparate… Read More: How to create pie chart in Sage Enterprise Intelligence (SEI)… »

Feature: How to create product with specific naming format using Product configurator in Sage X3

Introduction: As we know, Product configurator is the Sage x3 functionality which allows to create product along with BOMs, routing etc. There are some basic parameters that need to be set first. The first one is Configurator symbol where we can define the questions which can be used while using the configurator. The navigation for… Read More: Feature: How to create product with specific naming format using… »

How to set parameters for SQL Query tool report

In Sage X3, we may come across a situation where we need to create SQL query tool by adding fields from the table. There was one requirement from one of our clients to add parameters (filters) for the SQL query tool in the criteria tab. In this blog, we will explore the process of assigning… Read More: How to set parameters for SQL Query tool report »

How to solve Error: “@X3.TRT/SUBSDHA$adx (2612) Error 6 : Variable Non-existent GLBDOCDAT” in Sage X3

Sage X3 is enterprise resource planning (ERP) product which help organization to manage all the operation of organization and database into a single software solution. Sage X3 contains list of modules like sales, purchase, inventory, project, financial and many more. One of our clients is encountering an error when trying to open the sales delivery… Read More: How to solve Error: “@X3.TRT/SUBSDHA$adx (2612) Error 6 : Variable… »

How to customize the trace log file for errors and success messages

Trace files are extensively utilized in Sage X3 software, particularly during lengthy processes like Automatic Invoice Validation or Automatic Work Order Release. When a trace file is displayed, error lines appear in red text, allowing you to navigate through the errors. To customize a trace file, follow the below steps: Step 1: We need to… Read More: How to customize the trace log file for errors and… »

How to show comma-separated value for single or multiple fields in Sage X3 reports using crystal report

Crystal report is a business intelligence application used to design and generate reports from a wide range of data source. It supports connectivity to various data sources such as Microsoft excel, SQL server, Oracle and more. It includes major features such as formulas, cross-tab reports, sub-reports, and conditional formatting etc. In crystal report sub-reports are… Read More: How to show comma-separated value for single or multiple fields… »

Price List Import template does not update products

Have you ever encountered a problem with Sage X3 where a certain field that needs to be changed adds a new line to the pricing list template instead of updating for a product? The identical problem occurred to us in both the sales and purchase pricing lists; however, we were able to resolve it by… Read More: Price List Import template does not update products »

Restrictions on Selection Exceeding the requested SO quantity from pick ticket

A recent demand from one of our clients said that Sage X3’s pick ticket shouldn’t allow picking more than the order quantity based on the quantity of sales orders. The system can only allow the user to produce a pick ticket if the pick ticket quantity is equal to or less than the sales order… Read More: Restrictions on Selection Exceeding the requested SO quantity from pick… »