Category Archives: Installation

How to Install Microsoft Excel add-in in Sage X3

Sage X3 has an accompanying Excel add-in that you can use to export data from grids in Sage X3 into a Microsoft Excel spreadsheet. In this blog, we will run through the steps involved in installing the add-in and using it for a simple export. Integrating an Excel add-in with Sage X3 can be a… Read More »

Powershell error encountered ‘The certificate chain was issued by an authority that is not trusted’ during configuring it in Sage X3 Console

In Sage X3, we may come across this error ‘The certificate chain was issued by an authority that is not trusted’’ while trying to configure Application in the console. This issue occurs when you upgrade runtime to any version 95.2.85 and greater. Cause: Solution: To solve powershell error, follow below steps: Uninstall-module -Name SQLServer -RequiredVersion… Read More »

How to Restrict Single Delivery Creation from Multiple Orders in Sage X3

Sage X3 offers functionality allowing the consolidation of multiple orders into a single delivery. If your business process requires limiting such entries to prevent confusion during invoice report printing, follow the steps below: While creating Order there exist an option of Invoicing Mode, with choices including 1/Order, 1/Shipment, and 1/Invoice. Choose the ‘1/Order’ option. Users… Read More »

How to Use Conditional Formatting in Sage X3

Introduction When you look at raw data, it can be hard to understand what it all means because it’s just a bunch of numbers or information. It’s difficult to see patterns or trends when the data is in this simple form. One tool that helps with visualizing data is called conditional formatting. This tool makes… Read More »

Revision Management for Sales Orders in Sage X3

Revision management for sales orders was implemented to enable users to track updates made on sales orders for both headers and lines using a revision number. This new feature gives full visibility to the updates made by users to a sales order. Revision management allows you to easily and quickly track updates made on the… Read More »

How to get notification if an user deletes a Sales order in Sage X3

In Sage X3, notifications are typically used to alert users about certain events or actions within the system. These notifications can be configured to appear in various parts of the system, such as the user’s dashboard, or they can be sent via email.Notifications in Sage X3 provide a flexible and configurable way to keep users… Read More »

Statement creation functionality in Sage X3

As we all know open items Open Item refers to a financial transaction or record that has not yet been fully processed, reconciled, or settled. Sage X3 provides a special function to group open items related to the operations saved for BP like invoices, credit memos etc. on a statement. We are allowed to create the… Read More »

How do I add a new report to a function?

In Sage X3, you can add a new report to a function on the different objects screen. When the standard reports are not sufficient, we use an existing report and customize it according to our requirements. We can also add the validations on report printing. For example, On the screen, the user wants to print… Read More »

Automate sending reports on emails in Sage x3

Workflow in Sage X3 allows you to automate steps such as sending emails with attachments etc. Sage X3’s workflow function allows you to create a process that sends an email when certain conditions are met, such as fulfilling/satisfying the condition or triggering an event. This email may include attachments, such as documents or reports generated… Read More »

Create Refund for Overpayment

Overpayment by customers can present unexpected hurdles, ranging from accounting balance. In this blog, we will explore the process of resolving overpayments made by customers. Consider a scenario where we have a $2,000 invoice and receive a payment of $3,000, which we record in Payment/Receipt Entry using the Transaction Type Check Receipts (RECCH) function located… Read More »