You may come across a situation where you want to add criteria’s for SQL requester. Follow below instructions to add search criteria to the SQL requester. New Stuff: How to use Import to Excel functionality in version 7? Step 1: Go to Setup> Usage> Reports> SQL requester Parameter definition: If this field is entered, a… Read More »
In Safe X3 Version 7 if you try to use export to excel functionality like exporting the field of the table or screen then you will find that the file will be exported with only link which holds the address that downloads ‘SyracuseOfficeAddinsSetup.EXE’ (Sage X3 for Excel add-in) Since SyracuseOffice Add-in is required to export the… Read More »
You may come across the situation, where you have custom screen in your module. In that screen, if you want to create packages for the shipments. You will able to create packages but SSCC code not able generate for the respective packages. Because, X3 initiates SSCC variable only when you enter into Delivery screen New… Read More »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
