Tag Archives: Sage X3 Blogs

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 particular folder in the screen. New Stuff: How to define filter criterion on database query in… 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 came across a scenario where we want to run accounting task for multiple transactions at a time. We can achive this functionality by using below steps: Navigate to Usage > Batch Server > Accounting tasks Stop the accounting task. Now navigate to Set-up > Financial > Accounting interface > Accounting tasks Enter No.… 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 »

How to solve “Record already exist error” while creation of Transaction and Masters

We may come across a scenario where we get “record already exist’ error while creation of transactions and masters. The problem can be solved by using below steps: In below screenshot, we have faced an error while creating a product. This error occurs because the product of sequence number BMS089 already exists in the X3 for… Read More »