We may have situation where we need to split one order line into many order lines as per business requirement. Sage ERP – X3 provides a feature in which you can split a line based on Rec site, Address, Quantity and Expected Receipt Date. To achieve this functionality, Navigate to Purchasing → Orders →… Read More »
Iomode is used to assign for each open sequential file, the following parameters: Adxirs, Adxifs, Adxium. Syntax: Iomode ( Adxirs | Adxifs | Adxium ) Expression [using abbrev] where abbrev describing the open file. Examples: # Read of the first 10 words in the line in sequential files # the fields are separated by ‘ … Read More »
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 »
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 »
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 »
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 »
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 »
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 »
In Sage X3, sometimes we need to expand the functionality of the core Sage X3 solution with the required customizations to reach the desired goal. These customized new products are known as Add-ons. WAS web service is an add-on, which comes with a number of extra features, other than the normal web services. Key Points… Read More »
In Sage X3, we may come across a scenario where we want to allow manual generation of transaction Id for sales order then Sage X3 provides a standard functionality Manual sequence no. Set Manual sequence no to “Yes” in sales order types for which manual generation of transaction Id should be allowed. Set up –… Read More »
