Category Archives: FAQ

How to restrict the quantity to be allocated in an order line by default

In Sage X3 we can control how much of the ordered quantity should be allocated in sales order. The quantity entered in the ‘Qty to allocate’ field will be allocated to that particular order line. The quantity entered can be greater than the ordered quantity in this case a warning message will signal this and… Read More »

How to solve web service error: ” Read ECONNRESET”

In Sage X3 , we may come across the error “read econnreset” while invoking subprogram based standard web service ‘AOWSIMPORT’ using third party. Refer the below figure: To invoke standard webservice ‘AOWSIMPORT’ and its input XML, please refer the link:https://www.greytrix.com/blogs/sagex3/2019/05/30/how-to-invoke-import-export-template-through-web services/ Cause: This is due to the value of the clbfile I_FILE is set to… 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 »

How to create recurring supplier BP invoice

A recurring invoice is a type of invoicing with the help of this we can create and generate recurring invoices.Recurring invoices are popular in modern businesses for the ability to automatically charge supplier for an agreed amount for goods and services. These invoices are normally submitted, or the normally charges applied, on a monthly basis.Standard… Read More »

How can we prevent a PO being generated for a Back-to-back sales order on manual hold in Sage X3 version 12

In our previous blog, we have discussed regarding the process to create a Back-to-back order by using the sales orders. In this blog we will see How to create a Back-to-back order if sales order is on manual hold.However, in a Sage X3 when sales order status is on manual hold, then user can’t create… 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 »

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 »