Tag Archives: Sage X3 Technical

External URL Policies Functionality in Sage X3

All businesses have a lot of concerns about security. Sage commits to continuously improve the security of its products. The most popular protocols, HTTP and HTTPS, are supported by Sage X3 for network calls to a variety of services (internally and externally. The user’s home page or a page linked to a function are two… Read More »

What does the Letter indicate in Quality Control

This function is used to carry out the quality control, that is to say to check the conformity of the products prior to their placement in stock. During the receipt to stock or during the use of the product. The Status change function is used to request a quality control operation for a product or… Read More »

Global Variables in Sage Enterprise Intelligence

Introduction: Sage Enterprise Intelligence has a feature to create scripts and run them in the environment using the script builder. These scripts can be created and run to create worksheets, dashboards, and SEI reports, so for these scripts, sometimes we need to provide global values that can be made available to the user for access… Read More »

How to solve webservice error: ”nextLong”

We may come across the “nextLong “error while invoking web service. One way to resolve the “nextLong” error is below. In Version 11 and Version 12, created object based web service for saving the product .While trying to save new product we received nextLong error with Type 4. Refer. Fig., 1.1 Cause: If no field… Read More »

Extracting a variable length amount from a file line

There might be a situation where we would need to read a file and extract a variable length amount from a line. So, consider an example string/file line- “abcdef1122,52pqr”. Here the amount which we need to extract is “1122,52”. Refer the below code snippet- Here, First, we find the position of “,” and store it… Read More »

Reading Values from a csv file using a Separator

To read values from a csv file using a separator and writing the required values in a new file, follow the below steps- Open the directory where the csv file is located Specify the separator(e.g. “;”) and new line(e.g. “chr$(10)”) Read the values from a file Store the required values in variables Close the directory,… Read More »

How to extract a Substring from a String in Sage X3

While dealing with strings, we often require certain characters or a substring from given string. Sage X3 provides a special function to extract a substring from provided CLOB or a string. Syntax:  mid$(EXP_STRING,EXP_POS,EXP_NB) Where,  EXP_STRING is an expression returning a CLOB or string value. EXP_POS is an expression returning an integer value that is the… Read More »

How to define default allocation type used in order entry | Sage X3

Sage Enterprise Management (formerly Sage X3) is a robust financial accounting system with a wide range of features and functionalities aligned with your specific business requirements. In this blog, we will discuss one of the important concepts of defining default allocation type in Sage Enterprise Management (formerly Sage X3) used in Order entry. Defining an… Read More »