Category Archives: Configuration

How to execute the Pre-Migration and Post-migration Script in Sage X3 for up-gradation

Now days Every company wants to upgrade the system or data with newly functionality on the higher version. In Some industries the company wants to migrate the data from lower version to higher version in Sage X3. For that needs to done some steps in Sage X3 i.e. Execution of Pre-migration and Post-migration script in… Read More »

How to control Calculation basis of discount in Price structure

In Sage x3 we can control Discount calculation on what basis it should be calculated. In sales document we can enter Discount which will be calculated on 3 basis ‘By unit’, ‘by Line’, ‘by Document’ Navigate to Setup > Sales > Price list > Structures User can see the different values for Calculation basis (Refer… Read More »

How to set default journal entry type for journal created by import routine

In Sage X3 we can create Journal through import template also sage X3 provides a global parameter in which we can set default entry type using which journal should be created. Navigate To: Setup>General parameters>Parameter Values> Under Chapter Accounting >DEF> Parameter SCHIMPV5 (Entry transaction (import)) The entry transaction code to be assigned as the default… Read More »

Automatic/Manual stock issue in Sales Invoice

User may come across a scenario where they want to setup automatic determination of stock during a direct sales invoice creation. It can differ from user to user. Some may want it automatically and some may want it manually. This can be handled by doing a configuration in sales invoice entry transaction. Follow the below… Read More »

Sage X3 to X3 People Integration

As we all know, Sage X3 provides features to get/create data from third party applications using web services etc. Similarly, Sage X3 People also provides special feature to connect to the outside application. For example, if we need to create journal entries in Sage X3 from the payroll data of employees coming from X3 People… Read More »

Setting default tax rule and payment term for BP’s

As we know, Sage X3 provides masters for each object used in it like Business Partner, Product, Company, Site etc. We can setup various things for these objects such as id, name, and address etc. on their respective Master screens. Similarly on BP’s master, we can set up default payment term and tax rule against… Read More »

Configuring Financial Data Extraction in Sage X3 with Type of extraction as Reporting code

The Purpose of the Financial Data Extraction is representing Financial Data of an Organization/Company in form of Financial Reporting to their concerned stakeholders. This will help evaluate the Company’s performance over specific period (Half-yearly/Yearly), eventually helping the management to take effective decisions based on the financial reports generated. Financial reports, Balance Sheet and Profit and… Read More »

Configuring Financial Data Extraction in Sage X3 with Type of extraction as Account root

The Purpose of the Financial Data Extraction is representing Financial Data of an Organization/Company in form of Financial Reporting to their concerned stakeholders. This will help to evaluate the Company’s performance over specific period (Half-yearly/Yearly), eventually helping the management to take effective decisions based on the financial reports generated. Financial reports, Balance Sheet and Profit… Read More »

Error while configuring console in Sage X3 installation

In Sage X3 two tier installation for a client, we came across an error of user creation in database. While configuring the application server in console, we got an ERROR – Error while creating user. Please check file E:\Sage\X3V12\folders\X3\FILPLAT\x3v12_CrUsr.tra on server.(LibAdm.RunCreateUserSqlMainNT). Also, Refer the below screen shot for the same error.                                                                                    We investigated the… Read More »

How to create LOP leave type in Sage X3 People

LOP stands for Loss of Pay. In some organizations, this is also called as LWP (Leave Without Pay) or UPL (Unpaid Leave). In order to calculate the LOP days and deduction automatically in Sage X3 people there are few steps needs to be followed, Below are the details. LOP needs to be applied from the portal… Read More »