In our recent blog “” we have discussed about Headings, Variables and Totals. Now we are going to see How to Attach Totals to Heading. TOTALS:- Totals are used to ensure that each heading has the correct effect on a payslip. Whether it is to increase or deduct or have no effect other than record keeping.… 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 »
Sometimes we come across a scenario where user needs the purchase order to be closed only after certain conditions or never. Sage provides a functionality ‘PO line closing method’ which helps the user in setting them. Navigate: Parameter –> Parameter values –> Purchase Click on Rest Management — > PO line closing method Set the… Read More »
We have came across the scenario where we need to add detail comment to a purchase order product. For which sage has provided a default functionality known as line TEXT. Img: Purchase – Orders – Order Click on Text to add comments to purchase order product. These can be formatted using the functionalities provided… Read More »
