Category Archives: Greytrix

How to execute Global Scripts with parameters in SEI

In the last blog, we learned how to make global scripts. This blog will teach us how to make and use parameters. Parameters: The “Parameters” option shows all the parameters that are set up and can be used from the global scripts. Steps To create a new script parameter: In the upper left hand corner,… Read More »

How to create work order against the sales order in Sage X3

In Sage X3, if the user wants to create new work order against the sales order .We have used standard ‘Work Order’ button they have present on sales order action button  Refer fig2. So that we can easily create work order  against the sales order but on the creation time we are facing the issues… Read More »

Functionality of Shop Floor tracking and it’s impact on Work Order in Sage X3

The Shop floor tracking is to track your shop floor activity. This includes clock in and out going on breaks, recording labor setup and run times, production tracking, elapsed labor, and indirect tasks. With this, user can track activities for the team like a single employee using Employee ID.  In Sage X3, there are few… Read More »

Two ways to setup the Date format in Sage x3

In Sage ERP X3, the software offers flexibility in representing dates, allowing users to customize the date format to align with specific requirements. To determine the current date format being used in the application, you can use the Adonix calculator by pressing Ctrl+Alt+K  on any X3 screen and entering ‘GFMD’ click on Ok  from that… Read More »

How to export data based on certain filters in Sage X3

 As we know, Sage X3 provides the functionality of creating\updating the transactions using an Import/Export template. The export function in X3 is used to extract data from the database to ASCII type file (with fixed length or variable with separators), whose structure is described by an import/export template. Export functionality is basically used to fetch the… Read More »

How to print report in the specified directory of the server through the batch task in Sage X3.

In Sage X3 sometimes user want to keep or download the reports which are generated via crystal reports on the specified server path rather than printing the many more report in the preview mode or on the client work station. On the client workstation, the system will get hang if there are more than 50… Read More »

ERROR : “NON-EXISTENT PRODUCT FOR THE RECEPTION SITE”

NOTE : The error only occurs when the product has not been associated or included with the specified site during the creation of the sales order. Follow these steps to resolve the error: Step 1 : Enter the required data to create sales order. Sales order :           In Sage X3, a sales order is… Read More »

Guide to add SQL Query in Sage Enterprise Intelligence (SEI)

If you need to retrieve data based on a more complex query than just selecting the field from a single table, you will need this feature. The SQL Query can be as much complicated as the database provider can support. This means that you could join tables, do summarization and grouping without any issues. Follow… Read More »

How to solve encountered error ‘write ECONNABORTED’ during installation/migration in Sage X3

In Sage X3, we may come across this error ‘write ECONNABORTED’ due to server shutdown automatically and sudden server restarts. Here above error is coming after installation of Sage X3V12 and when user create X3 solution in X3 and click on ‘check main runtime setting’ button which is on the right panel under Actions. Cause:… Read More »