Category Archives: Integration

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

Auto-printing order acknowledgement functionality in Sage X3

In Sage X3, reports play an important role for representing transactions and records for analysis and growth perspective. Reporting enables businesses to gain real-time visibility into their critical processes, such as sales, finance, inventory, and production. With accurate and up-to-date information at their fingertips, decision-makers can make informed choices, identify bottlenecks, and drive operational efficiency. Likewise,… Read More »

Project Billing Overview functionality in Sage X3

Managing project billing is a critical aspect of project management and financial control within an organization. It involves the systematic and accurate invoicing of customers or clients for the work performed on projects, ensuring that revenue is appropriately recognized and financial goals are met. The process typically includes various stages, from tracking project activities and… Read More »

Why do the journal entries not get created automatically?

The ERP comprises multiple modules that link inventory accounts effects in a single process. In this blog, we will address the problem we are having with journal entry creation. Initially, we create a sales order in X3 when we receive an order, then we move on to creating a sales invoice for the accounting effect.… Read More »

Assembling Default Sales Order & Delivery Type in Sage X3

To manually select a sales order or delivery type every time you enter data into your system. It can be a tedious task, especially when you have a long list to choose from. However, there’s a solution that can save you time and improve your efficiency. By setting up a preferred default for your sales… Read More »

How to execute Global Scripts with parameters in SEI

In the last blog, we learned how to make global scripts. This blog will teach us how to make and use parameters. Parameters: The “Parameters” option shows all the parameters that are set up and can be used from the global scripts. Steps To create a new script parameter: In the upper left hand corner,… Read More »