Category Archives: Installation

How to create and add formula on inquiry screen

An inquiry screen is used to extract information from one or more table and present it in the from of a grid. It help us to display the records based on the filter criteria we entered. In Sage X3, we have a multiple inquiry screens available such as Stock by product, stock by lot,stock by… 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 »

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 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 »

How to assign the Sequence counter as per specific Document type

Earlier, we have one way of assigning the sequence counter to the transaction through the General Parameter → Sequence Number Definition → Assignment. We have an additional option, where we can assign the sequence counter to the transaction type through the Document Type. Navigate through Parameters → Sales/Purchase → Document Type → Transaction Hope this helps! About Us… Read More »

Write line level field values in a single line through a table with the values in fixed number of fields during file creation

Sometimes while creating/writing to a file we might need to write values from a field in a grid but through a table and not by looping through the grid and the values would be written sequentially in a fixed number of fields in a single line in the file and assigning blank values to the… Read More »

How to Copy FIle in Server using .bat Process

In Sage Enterprise Management (Sage X3) we may need to copy the file from one folder to another folder. We will do it by using .bat process. Syntax: Subprog MoveFile(PATH1,PATH2) Value Char PATH1 Value Char PATH2 Local integer RETURN_VALUE RETURN_VALUE=Delfile(filpath(“TMP”,””,””,””,””,adxmac(0))+’\Copy.bat’) Local Char WRET(250) (0..4) Openo filpath(“TMP”,””,””,””,””,adxmac(0))+’\Copy.bat’ Using [FACS] WRET(0)=”copy “+PATH1+” “+PATH2 Wrseq WRET(0) Using [FACS]… Read More »

How to set the User as Employee in Sage Enterprise Management

In Sage Enterprise Management, there may be a requirement where you need to set the user as an employee. In this blog, we set the Sage X3 user as Employee. Follow the below steps to set up. Navigate To: Set up > User > Users > Parameters Set the “AUSHDKA” After-sales emplyoee equal to “Yes”.… Read More »