Sage Enterprise Management (Sage X3) provides us with a feature to setup Sales price based on the Purchase price of Product. This set-up is subsequently used for charging a customer based on the purchasing cost of the product. E.g. an instance where you want to sell a product to a customer on the 50% margin… Read More: How to define Sales price of product based on Purchase… »
Stock count is a process of counting inventory on a periodic basis throughout the year. It is the physical verification of the quantities and condition of items held in an inventory or warehouse. This may be done to provide an audit of existing stock. It is also the source of stock discrepancy information. Stock-taking may be performed as an intensive… Read More: How to Setup Stock Count in Sage Enterprise Management »
You may come across the situation where you have to check the conformity of a string according to a pattern. Syntax: pat(EXPR_STR,EXPR_PAT) EXPR_STR : is a string or CLOB expression that contains the string to be tested. EXPR_PAT : is a string or CLOB expression that contains the pattern used for the verification. Example :… Read More: How to check the conformity of a string according to… »
In Sage X3, we may come across a scenario where we need to link unallocated Sales orders to Purchase orders. To solve this functionality: Create a sales order, make sure that the product which is used is not allocated or linked to any stock. Navigate to Stock → Assignment → Assignment workbench Step1: To select… Read More: How to link unallocated Sales orders with Purchase orders in… »
In Sage X3, we may come across a scenario where we face the difficulty while creating the back to back order. To solve this functionality: Step1: Navigate to Sales → Orders → orders Create a sales order, make sure that the product which we used in the lines grid, the supplier has to be defined… Read More: How to solve “Field VACBPR : Record does not exist… »
In many of scenario in debugging, we need to trace the variable values or any working logic in the background. This logs will help us to debug and work on the logic in the background. This function sets the Sage X3 engine in log mode. When log mode is activated, a file located in the… Read More: How create Sage X3 engine in log mode? »
adxmac is a function used to identify the server in which the current folder, or one of its reference folder, is installed. It also allows you to obtain the network name of the client (in version 7 mode, the client is the node.js server) Syntax: adxmac(Index) Examples: # What is the application server name APPSERV_NAME=adxmac(0)… Read More: To identify the server in which the current folder is… »
You may come across the situation where you need to set different report destinations for different users. To set the destination user go to Set up >>Destination by user Select a user for which you want to set a destination, report name, and destination. About Us Greytrix is a one-stop solution provider for Sage ERP… Read More: How to set report destination by user in Sage Enterprise… »
We can generate logs using openlog. Also, it is possible to get the name of the log file generated using getlogname() function. Syntax: LOG_FILE = getlogname() This function returns the file name of the last Sage ERP X3 engine log. When the log mode is activated, a file located in the ‘TMP’ subfolder of the folder… Read More: How to get Log File name generated using openlog in… »
Fixed Assets is one of the solution capabilities of Sage X3. Asset splitting is one of the functionalities of Fixed Assets in Sage X3. Asset splitting is the process of splitting assets i.e. one asset can be split into multiple assets. In Sage X3, we may encounter a scenario where we need to split an… Read More: Asset splitting functionality in Sage X3 »
