Category Archives: Sage ERP X3

How to create and add formula on inquiry screen

An inquiry screen is used to extract information from one or more table and present it in the from of a grid. It help us to display the records based on the filter criteria we entered. In Sage X3, we have a multiple inquiry screens available such as Stock by product, stock by lot,stock by… Read More: How to create and add formula on inquiry screen »

How to Create Query Tool to Get Desired Output in Sage X3 V12

In Sage X3, we may come across a situation where we need to create a query tool by adding fields from the table also while adding fields we may get the below error as shown in Fig 3. Step 1: To create a query tool Go To -> Set up -> Usage -> Reports ->… Read More: How to Create Query Tool to Get Desired Output in… »

Non Conformance Management in Sage X3 V12

In Sage X3 V12, a new functionality is added which will help in enhancement in quality standard. In any organization it’s important to maintain Quality control process be it at sales level, manufacturing level or purchasing level. Quality control is a critical aspect of the development cycle of a product also on handling return products… Read More: Non Conformance Management in Sage X3 V12 »

Restricting purchase order creation if there is no request/open order

Sometime we may come under a situation where we need to restrict the purchase order if there is no purchase request. This scenario can be handled on the basis of product. We may have a condition where we need to apply this restriction only for some type of product. We can apply this restriction for… Read More: Restricting purchase order creation if there is no request/open order »

Implement SSL Certificates With Sage X3 Syracuse Web Server

There are many situations where users want to implement an SSL certificate with Sage X3 Syracuse web server and want to be able to access Sage X3 without first attaching it to their network. So in this blog, we will learn how to implement the SSL Certificate into Sage X3 Syracuse as well as all… Read More: Implement SSL Certificates With Sage X3 Syracuse Web Server »

How to do Period End procedure in Sage X3

Fiscal Period is the period of time reflected in financial statements. Usually, the fiscal period is either the calendar year or a quarter. Fiscal period is also known as an accounting period. The fiscal year is the consecutive 12-month period during which a business or organization plans its budget. It does not have to be… Read More: How to do Period End procedure in Sage X3 »

How to Align Lot numbers with Work order numbers

A Work order is an order to make one or more products. Conventionally, the work order uses a bill of materials (BOM) to create a list of materials to be issued, and a routing to make a list of operations to be performed on work centers. Work orders dictate what product need to be manufactured,… Read More: How to Align Lot numbers with Work order numbers »

How to add checkbox in Crystal Report

There are many instances when client wants to give multiple copies of the invoices to their customers, where they must segregate multiple copies into original and duplicate. So we have given option on the report for those client where at the header part Original and Duplicate check boxes are given. So if the specific invoice… Read More: How to add checkbox in Crystal Report »