Category Archives: Sage X3 Consulting

Feature: How to create product with specific naming format using Product configurator in Sage X3

Introduction: As we know, Product configurator is the Sage x3 functionality which allows to create product along with BOMs, routing etc. There are some basic parameters that need to be set first. The first one is Configurator symbol where we can define the questions which can be used while using the configurator. The navigation for… Read More »

Project Billing Overview functionality in Sage X3

Managing project billing is a critical aspect of project management and financial control within an organization. It involves the systematic and accurate invoicing of customers or clients for the work performed on projects, ensuring that revenue is appropriately recognized and financial goals are met. The process typically includes various stages, from tracking project activities and… Read More »

Why do the journal entries not get created automatically?

The ERP comprises multiple modules that link inventory accounts effects in a single process. In this blog, we will address the problem we are having with journal entry creation. Initially, we create a sales order in X3 when we receive an order, then we move on to creating a sales invoice for the accounting effect.… Read More »

Assembling Default Sales Order & Delivery Type in Sage X3

To manually select a sales order or delivery type every time you enter data into your system. It can be a tedious task, especially when you have a long list to choose from. However, there’s a solution that can save you time and improve your efficiency. By setting up a preferred default for your sales… Read More »

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 »

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 »

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 »

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 »

How to resolve ‘Already Occupied Single-Product Location’

In Sage X3, the creation of a miscellaneous receipt typically occurs for various reasons, and these receipts are used to record non-standard financial transactions or receipts that do not fit into the standard sales or purchase order processes. When you encounter an issue with an “Already Occupied Single-Product Location” it means that the system is… Read More »