Category Archives: Sage ERP X3

Line Duplication Functionality in Sage ERP – X3

Sage X3 provides a feature where we can create a duplicate copy of the line in Purchase Order. This features can be achieved through Line Duplication functionality in Purchase Order. Below are the steps:- Navigate to: – Purchasing → Orders → Orders Create a purchase order. Click on the action button at the Line Level… Read More »

GUMU™ integration for Sage CRM with Sage X3 brings together your enterprise data

Enterprises, in order to improve their productivity, have in place powerful systems to manage their backend and frontend operations such as Sage ERP (Sage X3 | Sage 300 | Sage 100) and Sage CRM respectively. Sage X3, recognized as the powerful ERP simplifies the core business processes of purchasing to manufacturing, inventory management, sales, customer… Read More »

How to Call Function from Different File’s Using Single Call Statement and Encapsulation

While working around the complex functionality, it’s very obvious that you may have to deal with the Multiple source files. Multiple file may define the function with same name but with different set of instruction on the same event or the action and you may want call same function from particular file based on some… Read More »

Issue the Prepayment in Bulk

There might be situation where you want to issue the prepayment in bulk.  Sage x3 provide a feature in which we can issue the prepayment in bulk. To achieve this feature, Navigate To:Sales>invoices>Issue Prepayments The issue of prepayments is made, in mass, simply by selecting a planned issue deadline. You can also print them if… Read More »

How to Find the Last Date of Any Month

You may come across the situation where you have to find the last date of any month whether it is 30, 31, 28 or 29. To do so we can take help of EOMONTH function. Syntax: eomonth(DATE_EXPR) DATE_EXPR is an expression returning a date value. Consider following example where we have to find out the… Read More »

How to import customized tab fields using Import Template in Sage X3

In Sage ERP – X3, most of the time, we come across a scenario where we want to import the customized tab fields. For e.g., if you have added a new tab on the Customer Master screen and you want to import these tab fields using import template. By simply adding the fields in Customer… Read More »

How to Find the DAY of the Week

This function is one of the date function which will return the DAY number of the week from which we will be able to perform the other functionality. Function dayn(Date): The “dayn” function excepts one parameter which we need to pass the date for which we need to find the weekday number. Example: Output: These… Read More »

How to Sort Array in Ascending and Descending Order

Sorta-is used to sort arrays of single-dimensioned variables. Sorta, sorts the array in ascending order by default, to sort the array in descending we need to use Desc keyword. Syntax – Where, Sorta – Number Array List Number – number is length of an array or up to which number we want to sort Array… Read More »

How to Disable the Print Option in Invoice for the Particular User

If we want to disable the print option for the particular user then Sage X3 provides feature to disable the print option for the particular user. To successfully bring this functionality follow below steps: Navigate to: Setup>Users>Functional profile> Report Tab Select the profile code of the user. Set external document to Yes   Hope this… Read More »

Mass Generation of Purchase Order

You may come across a situation where you want to create Purchase order for many suppliers and products. Sage X3 provides a feature in which mass generation of Purchase Order can be done at once. To achieve this functionality, navigate to Purchasing → Orders → Buyers plan. Follow the below steps:- STEP 1 – STEP 2 –… Read More »