Tag Archives: Sage X3 Technical assistance

How to set the default Category as “ACTUAL” in Journal

We have come across the scenario where the Journal which are created from the Sales or Purchase Invoice should not be editable. We have parameter values which will set the Category as Default when we Post the transaction. Img: Parameter Values → Common data(TC) –> Group CPT This will set default value as actual, which will… Read More »

How to create work orders in bulk by using Batch process

Sage X3 has standard feature where you can create the bulk of work orders by using the back to back batch process. Fallow the below steps. Set Back to back check box checked. IMG: Product screen Select product source work order on sales order. IMG: Sales order screen Navigate to : Manufacturing >> Batch process>>… Read More »

How to assigns a default format to each type of field

In this blog, we will look how to assign a default format to each type of field and allows you to modify them. Adxfmt is an Adonix system variable of the table of 8 Char of 255 characters, which provides a default format according to the type of field of the file managed. Syntax:  [S]adxfmt(255)(8)Char… Read More »

How to get Folder Language from code in Sage X3

Sage X3 can have more than one folder. You may have come across a scenario where you need to know current folder language while accessing Sage X3 ERP. This can be achieved using the variable ‘messname’. This variable is accessible only in read mode. Please refer below screen shot for the syntax.  Figure 1: To… Read More »

Adding Graphical requester in Interactive Dashboard

To create Graphical Requester, follow below steps. Step 1: Create graphical requester. Set up → Usage → Report → Graphical Query tool Step 2: Create Menu Item. Navigate to Administration → Authoring → Pages → Menu Item As shown in above screenshot, we have created menu item with Link type as ‘QUERY’ and select Graphical… Read More »

How to add comments for a product line in PO

We have came across the scenario where we need to add detail comment to a purchase order product. For which sage has provided a default functionality known as line TEXT.          Img: Purchase – Orders – Order Click on Text to add comments to purchase order product. These can be formatted using the functionalities provided… Read More »

How to filter out left list in Sage X3

You may come across the situation where you need to see only filtered transaction according to your criteria. Consider an example where we only need to see those customer BP invoice where currency exchange rate is 2, to do so we can go to advance selection. 1.1 Reference Screenshot In advance selection screen give the… Read More »

How to upgrade Apache Service with binary files

We may came across a scenario where we want to upgrade apache service using binary files. We can achieve this by using below steps: Note: Here we are upgrading apache from 2.2.17 to 2.2.34. Download the zip file for apache 2.2.34. Extract it in the system. Stop the apache service. Copy all the files from extracted… Read More »

To restrict transactions for defined period in Sage X3

This Function is used to define periods during which a business partner is not open. Such a calendar is defined by a code of 3 characters and this can be entered at the level of the customers, the supplier and the sites. These calendars are used notably: For all the production planning operations as a… Read More »

Things you need to know about Multi-Currency in Sage X3

How will multi-currency support benefit organizations? Today, businesses are not bound by borders. With globalization and the growing transparency in business operations, organizations are exploring opportunities in foreign markets. To function exceptionally in the global marketplace, businesses need multi-currency support to carry out seamless transactions. Given the complexity in managing multi-currency for different scenarios, Sage… Read More »