Category Archives: Configuration

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 »

How to Setup Purchase Receipt Quality check in Sage X3

There can be possible scenario in an industry where the Products undergoes Quality Check once the Purchase Receipt is created. There is a setup explained below which will decide if Quality check is required or not. Steps Involved- Common data >Products > Product Categories Select the Product Category for which you would like to enable… Read More »

Credit Level Total

The “Credit level total” field under the management tab in the Customer screen displays the total of credit level of that particular customer based on the calculation involving a number field. By clicking on Calculation details the field that are involved in the calculation, The field On order+ shows the amount for the sales orders… Read More »

How To Change Pay date in Employee Payslip in X3 People?

In X3 People, each employee has their payslip generated for each month. In Employee Payslip master, we can see payslip generated for a particular month. We may come across the situation when we need to change the pay month in Employee Payslip Master. In order to change this, follow the below steps. Navigate to :… Read More »

How to increase the range of product serial numbers while creating Miscellaneous Receipt through import/export template

A serial number is a series of characters that have been assigned to each product in the warehouse so that it remains separate and are identified in the warehouse system. Using serial numbers, you can easily track the location of goods in the warehouse. While trying to import file for creating miscellaneous receipt for serial… Read More »

How to search employee documents in Sage X3 People

Sage X3 People has a standard functionality for searching the documents using the keyword. This functionality allows the user to search attached document using the keyword. The keywords has been created against each attached document (Image, Text, PDF, and Excel) etc. Attaching Files Navigate to Personnel administration > Select employee > click Attachment icon on… Read More »