Tag Archives: Sage X3 Blogs

How to use 2-dimensional array in Sage Enterprise Management

In Sage X3, we may come across a scenario where we need to use a 2-dimensional array in our code. Please refer the below steps to use a multi-dimensional array in 4GL code. Syntax: Local Char ZLChar (chrlen)(Xlen,Ylen) Where chrlen is the length of the string character. Xlen is the array length along x-direction. Ylen… Read More »

How to find Database size of your folder

You may come across the situation where you would like to know the database size of the folder or amount of space utilized by the folder in the database. Sage X3 has a special feature of getting database size of a particular folder in the screen. New Stuff: How to define filter criterion on database query… Read More »

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

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 »

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 »

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 »

How to use Entry point to set MAXMEM by user in Sage ERP X3

eatures:  maxmem determines the maximum amount of memory that can be used by the application and modifies this parameter Entry Point: INIVAR It defines certain values of the specific/custom user parameters on entering X3 pr in the situation of a user change, during the declaration of global variables. This entry point is used to give… Read More »