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: Visibility of field on the basis of Transaction Type »
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: How to set parameters for SQL Query tool report »
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: How to restrict the text based on date condition by… »
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: How to set dynamic Status field on screen based on… »
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: Restriction on Purchase Invoice creation »
As we know, Sage X3 supports multiple date formats as per the user’s requirement. The default date format in Sage X3 is set in setup–> Parameters. The developers who want to manipulate the date field value can use the date format using 4GL script. Also, there is an inbuilt string function that can be useful… Read More: Change the Date Format Using 4GL Script »
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: How to overcome ‘Date prohibited ‘error in sales, purchase and… »
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: How to handle two digit year in date »
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: Login Warning on Logical Date in Sage X3 »
