To create a Shipping calendar we will use X3 calendar functionality.The shipping calendar will help us with delivery tracking. Specially it will be helpful for sales and warehouse teams. For creation of “Shipping calendar” we are going to use SORDER and BPCARRIER table’s. Step 1: Go to Setup>Usage>Reports>Graphical query tool. Create new query Fig: Graphical… Read More »
Account pyramids are the manner in which accounts are associated with one another in account groups as user-defined in sage x3. The account pyramids could also be known as account rollups in the way that account groups ‘roll up’ to greater account categorizations in summary form for reporting purposes. In Sage X3, Account pyramids can… Read More »
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 »
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 »
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 »
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 »