Author Archives: Greytrix

How to add Signature workflow in Purchase Price List

Signature workflow is a feature provided by Sage for Automatic signature for a record if it is modified or created by the first level user defined in the Assignment rule. Once the user sign’s the record you will see “Signed” against the user and is processed to the next level of user for signature defined… Read More: How to add Signature workflow in Purchase Price List »

Defaulting Screen/Mask fields in Sage X3

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: Defaulting Screen/Mask fields in Sage X3 »

Workflow in Sales Price List

While creating any transaction in Sage X3, user has to enter “Gross Price” manually for the products in the detail line. But sometimes we use Price Lists to flow Gross Price automatically on the basis of Product and Supplier/ Customer combination. We have different price lists for Sales and Purchase with the respective Customers and… Read More: Workflow in Sales Price List »

Box Customization

Sage X3, formerly known as Sage Business Cloud Enterprise Management, is an ERP software suite that includes integrated functionality for financial management, sales, customer service, distribution, inventory, manufacturing, and business intelligence. Recently we had a requirement in Sage X3 from one of our client, in sales delivery screen, the data of Number of Boxes, Box… Read More: Box Customization »

How to add Statistical Group

An out-of-the box implementation of Sage X3 includes three statistical groups for Products, Customers, and Vendors. Statistical groups provide the means to group or categorize products, customers and suppliers for reporting or inquiries. Sage X3 supports up to five statistical groups, so we can create an additional two groups. Let’s see how we can create… Read More: How to add Statistical Group »

PREVIOUS() function in Crystal Reports

In the Sage X3, we have various standard reports for almost every screen which are developed in Crystal Report. Also we can develop new customized crystal report as per the client’s need. For one of our client we have developed a report that contains all the information related to Work Orders (report is printing in… Read More: PREVIOUS() function in Crystal Reports »

How to conditionally format fields using the Highlighting Expert in Crystal Report

In the Sage X3, we have various standard reports for almost every screen which are developed in Crystal Report. Also we can develop customized reports as per client‘s need. Crystal Reports is a popular Windows-based report writer solution that allows a developer to create reports and dashboards from a variety of data sources with a… Read More: How to conditionally format fields using the Highlighting Expert in… »

How to increase or decrease the number of lines in grid of any Inquiry screen

In each module of Sage X3, it has its own set of inquiries that allows to search and filter predefined data collections using a variety of prebuilt parameters. For example, in the sales module we have created a number of Orders, so to check Order data we can use the list of orders inquiry screens… Read More: How to increase or decrease the number of lines in… »

Tracking Restriction and Creation on the basis of Stock Availability

As we know, Production Tracking is created against Work Order in Sage X3. But if stock of raw materials/components is not available then creation of Tracking should be restricted. Usually this type of customizations are done to restrict Tracking creation. But here in this customization we have added one more condition to handle partial Tracking… Read More: Tracking Restriction and Creation on the basis of Stock Availability »

Modifying the WO component product in Sage X3

In Sage X3, During a WO process we get Header product’s BOM components auto loaded up and sometimes we want to replace a component code. To achieve this requirement, let us take you through a simple and effective process provided by Sage X3 as shown: We’ll be referencing the following screen from Sage X3 for… Read More: Modifying the WO component product in Sage X3 »