Function name: uniis used to verify if there are duplicated values in a series of variable or numeric expressions, alphanumeric expressions or dates. uni returns the rank of the first value equal to a previous value from the list, that is to say: If the first and the second are identical, uni returns 2 If… Read More: How to know if the duplicate values present in the… »
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… »
In our previous blog How to Re-Open Posted/Paid Customer Invoices in Sage X3 we saw the functionality of accounting cancellation i.e. to re-open a posted/Paid Customer BP Invoice in Sage X3 which will reverse the Accounting journal as well of the particular invoice from Journals. New Stuff: Find earliest date from range of Dates As per… Read More: Disable Accounting Cancellation on Customer BP Invoice »
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 »
