Sage X3 – Tips, Tricks and Components
In Sage X3, data is stored in several different tables and components of the application and sometimes we require the track of this data for insists or during building flow logics. Though this can be extracted from the database using queries however, Sage X3 provides an excellent approach to fetch this data from the application… Read More »
Retrieving data from a single table for the Sage X3 dashboard is straightforward. However, if you require data from multiple tables or linked tables, attempting to add a field from those tables triggers an error message: “Standard Query ‘QUERY_CODE’: Links not possible.” In our recent blog post, we’ve provided a clear solution to address this… Read More »
In Sage X3, the term “Dashboard” typically refers to a user interface feature that visually represents the relevant data. These dashboards are customizable and can be tailored to suit the specific needs of users or departments within an organization. Sage X3 dashboards allow users to monitor various aspects of their business in real time, such… Read More »
In Sage X3, we often work on data grid screens/masks where managing operations on multiple lines such as deletion, copying etc. becomes a hassle. However Sage X3 offers the users a way which operates with ease as shown below in an example of a patch creation where we want to remove several objects which are… Read More »
In Sage X3, every now and then a requirement requires a defaulting screen/mask field with a value upon initialization or start of processing. To achieve this requirement, Sage X3 offers several ways such as scripting in the Action script under specific events or through screen dictionaries.Below we are demonstrating how to default value through screen… Read More »
SEI defines the architectural view as a representation of a set of system elements and the relations associated with them. Moreover, SEI defines software architecture as a set of structures used to reason about the system dat comprise various system elements with their relations and external properties. In order to create view first we need… Read More »
In our previous blog, we have discussed regarding the process to create a Back-to-back order by using the sales orders. In this blog we will see How to create a Back-to-back order if sales order is on manual hold.However, in a Sage X3 when sales order status is on manual hold, then user can’t create… Read More »
The most important feature of any ERP is to provide data backup/ restore feature. Sage ERP X3 provides this in an option called Data Import/Extract available under its Development Parent Menu. The folder which consists of this data backup in Sage X3 is called as “SVG”. This folder is available in the below-mentioned path: Sage… Read More »
There are various scenarios when we need to check the Database Tables: [Before playing with data its always Safe to have a backup] Either we need to find the data added in backend for the hidden fields, as we are not able to check it on screen. In case if there is no screen developed… Read More »
Every ERP has hundreds of predefined reports and inquiry screens for the convenience of users. For accounting functions, there may be agreed upon set of reports and inquiry screens. However, one cannot predict or pre-empt what kind of data view user might want. That is where the flexibility of the system comes into play. Sage… Read More »