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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
