Tag Archives: Sage X3 Technical assistance

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 »

How to set up matching tolerance for purchase receipt

Matching tolerance is a functionality in Sage X3 which allows the user to set up and maintain tolerances in purchase module. Kindly follow the below mentioned step to set up matching tolerance: Navigate to Setup >> Purchasing >>Matching tolerances The Matching tolerances codes are used to define the degree to which the quantity of purchased… Read More »

How to run accounting task for multiple transactions

We may come across a scenario where we want to run an accounting task for multiple transactions at a time. We can achieve this functionality by using the below steps: Navigate to Usage > Batch Server > Accounting tasks Stop the accounting task. Now navigate to Set-up > Financial > Accounting interface > Accounting tasks… Read More »