In the realm of modern business operations, efficiency, accuracy, and transparency are priority In this pursuit, enterprise resource planning (ERP) systems play a pivotal role, and among them, Sage X3 stands out as a comprehensive solution catering to various aspects of business management. In Sage X3, there is a requirement from one of our client… Read More »
In Sage X3, we may come across a situation where we need to create SQL query tool by adding fields from the table. There was one requirement from one of our clients to add parameters (filters) for the SQL query tool in the criteria tab. In this blog, we will explore the process of assigning… Read More »
Crystal report is an application used to create custom reports from a various of data sources. It includes major features such as formulas, cross-tab reports, sub-reports , special fields and conditional formatting etc. In Sage X3 recently we had an requirement that one of our client wants the hardcoded declaration based on supplier type and… Read More »
In Sage X3, one of the client’s requirement was to have a dynamic “Policy Status” field which will reflect the current status where the policy is Active or De-active for the selected module. Here another condition was that at a given time span only one policy per module can be kept Active, rest will stay… Read More »
As per the standard functionality of Sage X3, if the user is entering same Supplier Document No in new Purchase Invoice entry which is already entered or used in the existing invoice entry then user gets a warning message popup that “Reference entered on Invoice(Invoice No)” as shown in the below screenshot. But after clicking… Read More »
As we know, Sage X3 supports multiple date formats as per the users requirement. The default date format in Sage X3 is setup in setup–> Parameters. For the developers who wants to manipulate date field value, can use date functions in 4GL. Also there is inbuilt string function which can be useful for the developers… Read More »
In Sage X3 we can control transaction creation by specifying the duration for which creation should be allowed. In order to prohibit the entry of invoices/credit memos Sage X3 provide a parameter level control where we can specify the duration for which sales transaction should be active these parameter set up is available for Sales,… Read More »
Date gets complicated when we define the year in 2 digits, you will not know to which century it belongs. For example, if we declare the date as [01/01/25], Now this date may belong to any century i.e 19th or 20th century depending on the pivot year which is set. This pivot year information is… Read More »
The System Date plays an important factor in any ERP, similarly, Sage X3 also keeps a track of the current system date [logical date] when users login in the system. Apart from this, X3 also maintains a parameter which will keep a check on the system date which will be allowed to login in Sage… Read More »