How to create Bill of Lading against Delivery in Sage X3

A Bill of Lading is a legal document used to show the agreement between the shipper and the carrier. Trucking companies need this document to move goods. It usually includes the freight class, description, number of packages, weight, volume, and other shipping details. For deliveries, a Bill of Lading can be created from the delivery… Read More »

How to Handle CHQNUM [CHN] Error when Cancelling a Payment or Receipt in Sage X3

In Sage X3, the check number field used during payment and receipt entry helps with tracking and auditing. Its availability and behavior depend on the checkbook functionality, which is optional and managed through system setup. Fig 1 : Manual check Screen If the check number does not exist in the checkbook, you will encounter this… Read More »

How to Display AP/AR (Customer BP Invoice) Records on Sales Invoice Inquiry in Sage X3

In Sage X3, the Sales Invoice Inquiry function is widely used to review sales invoices and related transactions. By default, this inquiry only displays records coming from the Sales module. However, there may be scenarios where you also need to view AP/AR (Customer BP Invoice) records alongside your sales invoices. This document will walk you… Read More »

How Modern Distilleries Achieve Scale and Compliance with Sage X3

In today’s distilleries, Liquor is crafted, not manufactured.Every batch carries the weight of heritage, brand reputation and market expectations. In this business, growth never happens overnight. A liquor brand matures the same way a fine whisky does — with patience, control, and a process where nothing is left to chance. But as operations expand,it requires… Read More »

WhatsApp Integration with Sage X3

We have introduced a new WhatsApp Integration module in Sage X3. With this feature, customers or vendors can now receive selected transaction details along with attachments directly via WhatsApp. This integration streamlines communication, enhances efficiency, and ensures that important documents are delivered quickly and securely. Features of WhatsApp Integration Module: The WhatsApp Integration Module in… Read More »

How to Create a Complementary Invoice in Sage X3

A Complementary Invoice in Sage X3 allows users to apply additional charges or costs to an existing Supplier Invoice. These could include tariffs, freight, or third-party service charges that need to be absorbed into inventory valuation, especially when using FIFO or Average Cost methods. IntroductionIn this guide, we will demonstrate how to create a Complementary… Read More »

How to Fetch Data from FY Depreciation Plan to Period Depreciation Plan in the Depreciation Plan Screen in Sage X3

Sage X3 is an enterprise resource planning (ERP) system that helps organizations efficiently manage operations and data across all functional areas — including Sales, Purchasing, Inventory, Projects, and Finance. During one of our implementations, a client requested a customization in the Depreciation Plan screen. Specifically, the requirement was to ensure that the value present in… Read More »

Alternative to the “IN” Operator of SQL in Sage X3

In Sage X3 development, there are times when you need to filter records based on a selective list of values—similar to using the IN operator in SQL. However, Sage X3 does not provide a direct equivalent of SQL’s IN operator within its standard 4GL syntax. Fortunately, there is an effective alternative: the FIND() function. Using the FIND() Function as… Read More »

How Sage X3 ERP for Distribution Transforms Inventory Control for Modern Wholesale Businesses

Each second matters in the distribution industry. With fast-paced orders and rising customer expectations, a single misplaced shipment can shake your entire supply chain. However, relying on disconnected systems, siloed inventory data, and manual spreadsheet updates is still quite common. Basically, working without an ERP for distribution industry or with a legacy business management system.… Read More »