Sometime we may come under a situation where we have to close the sales order through code. Keyword DIVSOHCLE is used to close the sales order record. For example: Below is a sales order which we have to close through our code. Fig1: Sales order record Use the keyword as… Read More »
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 »
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 »
Sage Enterprise Management provides a Global parameter TABTRA which is used to define if a log of the operations carried out by the users in a table named AESPION should be saved. It can take the values defined in the 939 local menu. Thus it is possible to log nothing or to log all the… Read More »
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 »
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 »
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 »
Sage X3 can have more than one folder. You may have come across a scenario where you need to know current folder language while accessing Sage X3 ERP. This can be achieved using the variable ‘messname’. This variable is accessible only in read mode. Please refer below screen shot for the syntax. Figure 1: To… Read More »
This Function is used to define periods during which a business partner is not open. Such a calendar is defined by a code of 3 characters and this can be entered at the level of the customers, the supplier and the sites. These calendars are used notably: For all the production planning operations as a… Read More »
Matching tolerance is a functionality in Sage X3 which allows the user to set up and maintain tolerances in purchase module. Kindly follow the below mentioned step to set up matching tolerance: Navigate to Setup >> Purchasing >>Matching tolerances The Matching tolerances codes are used to define the degree to which the quantity of purchased… Read More »