Category Archives: Sage ERP X3

Sage X3 Sales Commission add on

As we all know that the sales commission is a key aspect of sales compensation. It’s the amount of money a salesperson earns based on the number of sales they have made. Most businesses rely on manual procedures to calculate commissions which causes errors and delays in making the payments. Accuracy in sales commission calculation… Read More »

PO Quantity Validation on Order Pre-receipt screen

In Sage X3, Order pre-receipt transaction is made before we received the goods and make the GRN. During Order Pre-Receipt transaction, user select the respective Purchase Order number from the left list and data gets populated in the lines tab with the Order number and their respective details on the screen. Recently, we got the… Read More »

How to get total transaction amount of supplier for current fiscal year

In Sage X3, only posted transactions will be considered for accounting effects. Here in this blog we had a requirment from a client that , there should be a field on the header of purchase invoice screen, in which total transaction amount of the Supplier should be displayed for current fiscal year according to the… Read More »

Validation on Purchase Invoice screen

As we know in Purchase Invoice screen, Supplier Document No and Supplier Invoice Date fields are mandatory. In Sage X3, while creating Purchase Invoice transaction, user can enter same No and Date for different invoice numbers. But one of our client requested to add a validation for the Purchase Invoice where, if the Supplier, Supplier Invoice… Read More »

How to enable “Accounting Cancellation” option on Purchase Invoice Screen

As per the standard functionality of Sage X3, Accounting Document (Journal) will be created immediately once the invoice is posted and “Accounting Cancellation” button automatically gets enabled. And any user can click on this button and reverse the posted invoice transaction. But sometimes, that accounting cancellation option remains disable even after posting the invoice. As… Read More »

How to solve ‘Accounting destination’ error while creating payments in Sage X3

Payment is the transfer of money or goods and services in exchange for a product or service. A payment can be made in the form of cash, check, credit card and debit card. Payments can be done against invoices that are generated from Sales/Purchase Invoice and Customer/Supplier BP invoice from the AP-AR accounting module. Payments… Read More »

How to delete the U tables after post-migration in Sage X3

Now days Every company wants to upgrade the system or data with newly functionality on the higher version. In Some industries the company wants to migrate the data from lower version to higher version in Sage X3. For those needs to done some steps in Sage X3 i.e., Execution of Pre-migration and Post-migration script in… Read More »

How to solve error “BP incompatible with that of the project” in Sage X3 V12

In Sage X3, version 12, as we already aware that Project module in newly introduced.Project management has the capacity for services and manufacturing sectors to manage planning and quotations, manage budgets and control costs, organize and allocate resources, and raise external documents. Sage X3 Project management provides the functionality to plan, to develop estimates and manage resources and… Read More »

How to add Custom Reports to Printer Icon on Customized Window

Report: A report is a document that presents information in an organized format for a specific purpose. Crystal Report: Crystal Reports is an application used to create custom reports from a variety of data sources. It includes the major features for an application to create database reporting environments, such as data access, report design/formatting, report viewing, and application integration. Crystal Reports… Read More »