Author Archives: Greytrix

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 solve ‘Payment transaction is not of receipt type’ error message in Sage X3

A Payments is like an accountant. It keeps track of who owe whom and how much. Basically it is a transfer of money or assets to another person or business. You may come across a situation where you would like to do payments for the sales invoices. Sometimes while doing payments for sales invoices we… 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 »

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 »

Tax calculation on Freight charges in Sage X3

Freight charges refers to the Freight rate or the Price that is charged by a carrier for delivering goods from Source location to Destination location. You may come across a situation where you would like to add elements like discounts, freight charges etc on the sales order . Sage X3 has a feature to add… Read More »