Category Archives: Sage ERP X3

Auto-attachments tagging routine customization in Sage X3

In Sage X3, one of our client’s requirements was to have a way to get their attachments auto-tag to their respective transactions in a regular interval of time. For this we’ve developed a customization in place that’ll not only fulfill the requirement with minimal user efforts but also take in consideration of several validations and… Read More »

Validation of the payment screen’s UTR number field.

One of our clients asked that the validation be added to the UTR number field in Sage X3 for the payment screens listed below. “ADVP Payment Against Advance” and “PAYMT Payment Against Invoice”. The “POST” button for these payment windows shouldn’t be enabled until the required UTR number has been entered. Typically, “UTR number” denotes the “Unique… Read More »

How to view data in different formats in SEI

We are able to produce reports, dashboards, and views with Sage Enterprise Intelligence. Additionally, SEI makes data analysis simple. Users may choose to view data in SEI in a different format at times. This blog post will explain how to see data in various formats within SEI.Figure 1 illustrates how only the data code is… Read More »

How to update the fields in the signature history table for a custom workflow in Sage X3

In Sage X3, workflows are used to automate and streamline business processes by defining a sequence of tasks that need to be performed in a specific order. These tasks can involve approvals, reviews, or other actions necessary for the completion of a business process. Workflows in Sage X3 help organizations enforce consistency, reduce manual intervention,… Read More »

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 solve the error@“Field BPAADD(Alphanumeric) : mid$ Function not defined for the value given” when extracting the Excel export from the Purchasing Receipt Line Inquiry screens

Sage X3 is enterprise resource planning (ERP) product which help organization to manage all the operation of organization and database into a single software solution. Sage X3 contains list of modules like sales, purchase, inventory, project, financial and many more. One of our clients is encountering an error “Field BPAADD(Alphanumeric) : mid$ Function not defined… Read More »

Receipt selection at purchase invoice screen with Provisional Freight charges

Provisional freight charges refer to estimated freight costs that are temporarily assigned to transactions in Sage X3 ERP until actual freight costs are determined. These charges are useful when the exact freight costs cannot be determined at the time of transaction entry.Provisional freight at purchase receipt in Sage X3 ERP involves estimating and recording freight… 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 »