Tag Archives: Sage X3 Functional blogs

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 »

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