Tag Archives: Sage X3 Technical blog

Learn how to Extract Right Sub-string from a Given String in Sage X3

In Sage X3, you might face various scenarios where you want to get the sub-string from an existing string. You can derive the sub-string from leftmost/rightmost direction, starting from a particular position for a given string using this tip in the blog. This blog will help you to get the rightmost sub-string from any particular… Read More »

How to resolve “Valuation price null not authorized!” error in Sage X3

 While creating miscellaneous receipt transaction in Sage X3, we will often encounter an error “Valuation price null not authorized!”  This error is particularly generated for the products which are not having the value or gross price in stock. We can resolve this by following the below steps: Navigate to: Setup > Stock > Valuation method. Select… Read More »

How to Extract a Left Sub-String from a given string in Sage X3

In Sage X3, you may come across various scenarios where you need to get a sub-string from an existing string. You can derive sub-string from both the ends i.e. from the left or the right or starting from any particular position of a given string. This blog will help you to extract the leftmost sub-string… Read More »

How to Know Error Number and Error Line in Sage X3

In any programming language, we need to do error handling for smooth working of any functionality. In Sage X3, the error management is done by Onerrgo instruction. When the errors are intercepted by the instruction Onerrgo, an error leads to a branching to the corresponding label. The corresponding error number can then be found in… Read More »

How to determine the characters of the user entry types in sage ERP X3?

Adxtuc determines the characters of the user entry types. You may define types of entry that will be added to – or even substituted by –  standard types within an Adonix application. These extra types are described by one letter: their “code.” Syntax: [S]adxtuc (33) (32) Char Example: Output: Description : You may parameterize 32… Read More »

Fetch the ADC print destination value in coding

While printing the report through code you may need to print the report or label in the printer defined on the ADC destination .The below mentioned global variable are available in x3 in which the label destination and Document destination are stored GVTETI : This global variable is used to store the  Label destination GVTDOC… 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 allow Manual Generation of Transaction ID for Sales Order?

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 »

How to Roundup Decimal Number to the next Nearest Number.

While dealing with arithmetic operations, you may want to roundup the calculation result to the next nearest number. Sage X3 has a special function to achieve this. ARR : rounds a number to the next nearest number. ARR ( exp_num1, exp_num2 ) Parameter details:  exp_num1: Decimal number that will pass to “arr” function. exp_num2: if… Read More »