Category Archives: Greytrix

How to add a field in data model designer in SEI

In this blog, we’ll explore the step-by-step process of creating data models, linking tables, adding fields. Once the tables have been added and linked, fields can be added to the Data Model. Click on the  to open the Fields. Right-click on the Field to access to these options: Fig. 1. Add column Note: Fields can… Read More »

What is License Plate Numbering in Sage X3

In logistics and supply chain management, internal containers refer to the various types of packaging or storage units used to transport and store goods within a facility or during transportation. These containers can include pallets, boxes, packs, big bags, barrels, bins, and others. Assigning unique identifiers, such as license plate numbers, to these internal containers… Read More »

Renewal annual envelopes in Sage X3

In Sage X3, the concept of “annual envelopes” refers to predefined budgets or allocations that are set aside for specific purposes within an organization, typically on an annual basis. These envelopes are often used to manage expenses, track spending, and allocate resources effectively across various departments or cost centers. The renewal of annual envelopes in… Read More »

Creating custom Storage area in Sage X3

In this blog, I’ll demonstrate how to allow X3 to access specific directories beyond its default folders. These external storages are useful places to keep documents. Below are the steps, simplified to the fullest extent. Step 1: You can find the directory at (…\runtime\cfg). Inside this directory, you’ll see a file named configRuntime. Before making… Read More »

Adjustment rules of daylight saving time in Sage X3

In Sage X3, adjustment rules for daylight saving time (DST) typically involve configuring the system to automatically adjust for changes in time when DST begins or ends. This ensures that date and time calculations within the system remain accurate despite the shift in local time. Utilize this feature to establish transition guidelines for Daylight Saving… Read More »

Workflows for Errors in Query Management in Sage X3

This blog article will guide you through creating a workflow aimed at sending email notifications containing log files in the event of issues occurring within the Stock Accounting Interface or the WIP Accounting Interface. These problems typically stem from integration conflicts with the Stock or WIP interface or from operator queries disrupting other Sage X3… Read More »

How to view data in different formats in SEI

We are able to produce reports, dashboards, and views with Sage Enterprise Intelligence. Additionally, SEI makes data analysis simple. Users may choose to view data in SEI in a different format at times. This blog post will explain how to see data in various formats within SEI.Figure 1 illustrates how only the data code is… Read More »

How to update the fields in the signature history table for a custom workflow in Sage X3

In Sage X3, workflows are used to automate and streamline business processes by defining a sequence of tasks that need to be performed in a specific order. These tasks can involve approvals, reviews, or other actions necessary for the completion of a business process. Workflows in Sage X3 help organizations enforce consistency, reduce manual intervention,… Read More »

How to Install Microsoft Excel add-in in Sage X3

Sage X3 has an accompanying Excel add-in that you can use to export data from grids in Sage X3 into a Microsoft Excel spreadsheet. In this blog, we will run through the steps involved in installing the add-in and using it for a simple export. Integrating an Excel add-in with Sage X3 can be a… Read More »

Powershell error encountered ‘The certificate chain was issued by an authority that is not trusted’ during configuring it in Sage X3 Console

In Sage X3, we may come across this error ‘The certificate chain was issued by an authority that is not trusted’’ while trying to configure Application in the console. This issue occurs when you upgrade runtime to any version 95.2.85 and greater. Cause: Solution: To solve powershell error, follow below steps: Uninstall-module -Name SQLServer -RequiredVersion… Read More »