We have scenario where we need to show same selection as per standard object but we need to have additional filter on selection. In this scenario, there is no need to add the additional selection criteria. We just need to add the following selection filter as below. Example: We need Customer selection using the BPC… Read More »
Many a times, the user creates 2 similar business partners in Sage X3 instead of 1 business partner, this results in 2 separate entities in all the related inquiries or reports. In such cases, Sage X3 provides BP Merge functionality which allows two BP accounts to be merged together, which will automatically transfer all the… Read More »
1. Setup variable to be updated. Note: Uncheck Expense notes 2. Setup Variable for a portal default value as well as the maximum allowable value to be claimed via the portal. These can be configured as separate variables or can comprise the same variable. Note: Check the Folder, The variable for the default and/or maximum values will… Read More »
You may come across the situation where you would like to know the database size of the folder or amount of space utilized by the folder in the database. Sage X3 has a special feature of getting database size of a particular folder in the screen. New Stuff: How to define filter criterion on database query… Read More »
Have you came across a scenario where you want to change the name of “Module and Sub Module”. Image 1: Home Page Navigate To: Administrator>Authering>Navigation Page Image 2: Pages Now Edit the Home Page content. Image 3 Edit module name like “Orders to sales orders”. Image 4: Navigation Pages Now, you can check the names of Module… Read More »
We have come across the scenario where the Journal which are created from the Sales or Purchase Invoice should not be editable. We have parameter values which will set the Category as Default when we Post the transaction. Img: Parameter Values → Common data(TC) –> Group CPT This will set default value as actual, which will… Read More »
Sage X3 has standard feature where you can create the bulk of work orders by using the back to back batch process. Fallow the below steps. Set Back to back check box checked. IMG: Product screen Select product source work order on sales order. IMG: Sales order screen Navigate to : Manufacturing >> Batch process>>… Read More »
In this blog, we will look how to assign a default format to each type of field and allows you to modify them. Adxfmt is an Adonix system variable of the table of 8 Char of 255 characters, which provides a default format according to the type of field of the file managed. Syntax: [S]adxfmt(255)(8)Char… Read More »
Sage X3 can have more than one folder. You may have come across a scenario where you need to know current folder language while accessing Sage X3 ERP. This can be achieved using the variable ‘messname’. This variable is accessible only in read mode. Please refer below screen shot for the syntax. Figure 1: To… Read More »
To create Graphical Requester, follow below steps. Step 1: Create graphical requester. Set up → Usage → Report → Graphical Query tool Step 2: Create Menu Item. Navigate to Administration → Authoring → Pages → Menu Item As shown in above screenshot, we have created menu item with Link type as ‘QUERY’ and select Graphical… Read More »
