Category Archives: Greytrix

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 »

How to create batches in Sage X3

In Sage X3, (formerly known as Sage Enterprise Management or Sage ERP X3), ERP system refers to a method of transaction processing where your system collects data over a small period of time before processing and posting entries to your general ledger. Instead of processing each journal entry as it comes into your system, entries are… Read More »

Feature : Locales Functionality in Sage X3

Locales in Sage X3 are specific language or regional settings that are used to modify the software to fit various languages or geographical regions. Language preferences, date formats, currency symbols, and other regional requirements are examples of these settings. For multinational or multilingual organizations, setting up locales is essential because it guarantees that users from… Read More »