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 »

Quarantine Label in Sage X3

Labeling is one of the influential parts of the packaging of the product. The label includes the information of inventory/product and which helps the customer to communicate with the company and greatest advantage identify the product and provide necessary information for the same. There are different kinds of labels such as Rejection, Approved, etc. which… Read More »

How to Prevent Users from Posting Sales Invoices and Purchase Invoices in Sage X3

In sage x3, Sometimes there may be a requirement that not all the user should be able to post sales and purchase invoice, We can allow the restriction for the user for posting of sales and purchase invoice. With the steps provided below extra security can be set up in Sage X3 that will prohibit… Read More »

How to Setup a Default Payment Approval Status in Sage X3

The posting of the payment of invoices coming from the Purchase, Sales or AP-AR Accounting modules is the payments generation. When you enter a Supplier Invoice there a Pay Approval selection box on the Header of the record. Only when the Invoice is marked as “Authorized to Pay” can it be selected by the Payment… Read More »

How to set default location and location type on product category.

Sage X3 gives us functionality where we can set default location and location type at product category level. If a particular category of product is available at multiple locations of sites, we can set a default location in this case and also if there is multiple categories of location (Receipt, stock, picking etc.) we can… Read More »

How to disable the Tax3 field of Sales Order screen if the customer is not TCS Applicable

There was a requirement from the user to add a check box on Customer master as “TCS Applicable” and “Tax Level 3” field of detail line on the Sales Order screen should be activated only when the “TCS Applicable” check box for any customer is ticked, otherwise it should be disabled. To achieve the above… Read More »