Node JS Integration with x3

In this blog, we will get to know about the payment integration through node js method. In case if the client doesn’t want java bridge integration and also there would be compatibility issues in x3 v12, we can suggest node js integration instead of java bridge & will be more compatible and robust for the… Read More »

How to control payment sign (Expenditure or Revenue)

In sage X3, under Payment entry type we can define characteristics and the methods for different payment transactions. We can also control the sign of payment to be Revenue, expense or we can keep it as unspecified and differentiate that value based on our payment entry. Path: All>Setup>A/P-A/R accounting>Payment entry type Also in payment attribute,… Read More »

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 restrict dimension relationships within dimension type

As we all know sage x3 uses dimensional accounting which helps to improve and simplify the reporting. There may be a case where dimensions should not be used in combination with another dimension. Restriction codes can be configured to prevent such cases. We have seen how to configure restriction code and setup Account/Dimension restriction code… Read More »

How to resolve ‘The quantity to be returned exceeds the maximum authorized’ error message while creating Purchase return in Sage X3

Purchase return is normally a part of business. In which, goods are returned to the supplier if they had any defects or not according to the specifications of the buyer. In Sage X3, while creating Purchase Return we may come across an error like ‘The quantity to be returned exceeds the maximum authorized: 0 UN’.… Read More »

How to activate customer allocation

There is functionality in Sage X3 where we can hold stock reservations for each customer based on each site. This functionality is located in sales module. Navigate: SALES -> ALLOCATION -> CUSTOMER ALLOCATION. As shown in the above screenshot, there is also an ‘END DATE’ field which notifies that the customer allocation can be done… Read More »

How to transfer file to FTP server

Sometimes, it might happen that we need to transfer a file to the FTP server. The below piece of code will transfer the file to FTP. Parameters: HSTSITE It is the FTP server address on which the files will be transferred. HSTUSR and HSTPWD  It is the Username and Password of the defined FTP server.… Read More »

How to solve error “Incorrect version No (AMIGKEY/MIG_RELEASE)” Error while executing the Pre-Migration Script

In some industries the company wants to migrate the data from lower version to higher version in Sage X3. Every company wants to upgrade the system functionally or data on the higher version. For that we run some per-migration script. At that time, we will get Error: ‘Incorrect version No (AMIGKEY/MIG_RELEASE)’. With the help of… Read More »