You may come across the situation where you would like to know the count of index(keys) in the table which may help you. Sage x3 has a special feature of getting keys of the table with the help of “nbind” keyword which will return you the value in number. New Stuff: How to create the Recurring… Read More: Count the number of keys(index) in the table. »
Recently we came across a scenario where the client wished to recreate customer BP invoices every month or week or daily again and again. When we checked in X3 it provided us with a simple solution to this. Navigate through: A/P-A/R accounting>Invoicing>Recurring customer invoices Add the customer invoice in invoice number filed and select the… Read More: How to Create Recurring Customer BP Invoices »
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 »
