Sleep is used to interrupt the execution of a process during a given time. The Sleep instruction is used to create pauses in a process. After a Sleep, the process pauses for a duration equal to the number of seconds given in the parameter, then continues normally. New Stuff: How to get SQL server user… Read More: Sleep Command Feature in 4GL »
We came across a scenario to fetch the SQL server Database , user name and password in sage X3. Here is the step. New Stuff: Update read only field using import utility. Step 1: Create the view as per the screen shot, Step 2: Add the fields in this view as given below, Step 3: Finally… Read More: How to get the SQL server user name and password… »
While working on one of my project customization I came across the situation where X3 was not updating a read only filed using import utility. New Stuff: How to get the index name of the table? After some R&D, I came out with a simple solution. To avoid this you may follow below setting in X3.… Read More: Update read only field using import utility »
You may come across the situation where you like to know the name of the index in the table. Sage ERP X3 has a special feature of getting indexname of the table with the help of “keyname” keyword which will return you the value . keyname: keyname determines the name of the keys of an open table.… Read More: How to get index name of table in Sage ERP… »
We have come across the situation, where we design Requestor and then we also want to add the levels to Requestor. Sage X3 has a special in-built feature to add levels in requester. New Stuff: How to determine if a mask variable can be entered or displayed? Follow the below instructions to add levels to… Read More: Adding levels in Requester »
Function varmode is used to verify if a mask variable can be entered or is displayed. The varmode function returns an integer that is: New Stuff: Disable Accounting Cancellation on Customer BP Invoice. If the variable is in enter mode, varmode returns 0. If the variable is in display mode, varmode returns 1. Syntax: varmode ( field_name… Read More: How to determine if a mask variable can be entered… »
While comparing dates you may come across the situation where you like to have the earliest date from a range of date. Sage x3 has a special feature of finding the earliest date with the help of “min” keyword. min is used to calculate the overall minimum of any number of variables or expressions of… Read More: Find earliest date from range of dates »
Sage ERP X3 offers functionality to create the direct purchase receipt by just setting a parameter. This parameter indicates whether a user is authorized to create a direct receipt (not attached to a purchase order, a shipment request or an inter-company shipment). New Stuff: How to calculate remainder using X3 mod function? The list of possible… Read More: How to create direct receipt in Sage X3 »
You may come across the situation, where you having arithmetic operation with numbers. You may want to calculate the remainder of division. New Stuff: How to open Sage ERP X3 Code file in Eclipse Editor in Version7? Sage X3 has a special function to calculate the remainder of division. mod: This function calculates the remainder of… Read More: How to calculate remainder using x3 mod function »
This blog post will guide you through on adding the Sage ERP X3 Code file to the eclipse folder. In Safe X3, navigate to ‘screen dictionary’ and under ‘scripts’ section, select the option ‘Editor’. New Stuff: Customize the Title bar of the Client workstation. Make sure you open the eclipse before clicking on ‘Editor’ and… Read More: How to open Sage ERP X3 Code file in eclipse… »
