Creating a Crystal Report isn’t just about displaying the correct data—it’s also about presenting that data in a clean, organized, and professional manner. A report with awkward page breaks or large blank spaces can be difficult to read, even if the data is accurate. While working with Crystal Reports, developers often face two common layout… Read More »
Introduction In project-based and manufacturing organizations, effective inventory control is vital for operational efficiency, profitability, and audit compliance. Materials are regularly issued to projects, production, subcontractors, or transferred between locations. Without proper controls, this often results in discrepancies, unapproved consumption, and weak traceability. The new Material Requisition Slip (MRS) feature in Sage X3 solves this by… Read More »
Clients often have many custom requirements. Sometimes a completely new module needs to be developed from scratch. In such cases, we create new Windows, Screens, Objects, and Actions according to the client’s needs. When we create a custom Window from scratch, we frequently face one common issue: after building the complete Window, the field-level actions… Read More »
When working with Sage X3 4GL, developers often customize screens by adding actions such as After Change, Before Entry, or After Entry to fields. However, things become a little more complex when the field is a dimension (array) field. A common challenge is that a field action is triggered for every dimension of the field,… Read More »
New Stuff: Creating a Custom Sequence Number in Sage X3 Using a Function Figure 1 Figure 2 Figure 3 Figure 4 5. On the Miscellaneous Receipts screen, you may wish to hide the price and order price fields. They will NOT show the costing that will be used. Rather, they will remain blank, which can… Read More »
In many business scenarios, the standard sequence numbering provided by Sage X3 may not fully satisfy statutory, operational, or reporting requirements. Organizations often require document entry numbers that contain additional business-specific information such as: This article explains how to create a custom sequence number in Sage X3 by using a user-defined function within the sequence… Read More »
A client recently raised an issue that when a Purchase Order (PO) is rejected in Sage X3, the system automatically closes the Purchase Order. We investigated the functionality to understand the root cause. Signature Management (Approval Workflow) is an important feature in Sage X3, especially for maintaining accuracy and control in the Procurement and Inventory… Read More »
Effective project management requires accurate monitoring of work completion and progress. In Sage X3, the Work Order (WO) screen plays a vital role in managing project-related activities, tracking execution status, recording operational details, and monitoring project completion. To improve data accuracy and prevent incorrect progress reporting, a validation has been implemented for the Project Progress… Read More »
Managing accurate pricing in purchase transactions is essential for maintaining cost control and consistency. In Sage X3, the Price List functionality allows businesses to automate pricing in Purchase Orders based on predefined conditions. One of the most useful features is the ability to define prices based on a Supplier–Product combination, ensuring that the correct gross… Read More »
While working on workflow email notifications in Sage X3, we faced an issue related to approval mail triggering during workflow execution. The client’s requirement was to send automatic email notifications at the time of 1st approval and 2nd approval whenever a user signed the workflow transaction. Although the workflow was functioning correctly and approvals were… Read More »
