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 »
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… »
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 »
In sage X3, enter key has some default functionality for e.g. in some screens it is used to trigger OK button functionality while in grid level it is used to jump on the next line and so on. So, depending on the requirement and screen type Enter key has different types of functionalities. But with… Read More: How to change Enter key functionality »
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 »
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 »
In Sage X3, we may come across a situation where we need to prevent printing of a report and we can achieve this using code. Steps to follow : To prevent printing of a report we need to create a specific processing script for the report and put the following code in the file. The… Read More: How to prevent the printing of a report programmatically »
Sometimes, you want to delete the address of a customer or Supplier or BP which is wrong or you want to change the address or you want to delete the address for some other reason. You can follow the below steps to check if the address can be deleted. Steps: If you need to delete… Read More: Customer or Supplier address deletion »
As we all know sage x3 uses dimensional accounting which helps to improve and simplify the reporting. There may be a case where dimensions should not be used in combination with another dimension. Restriction codes can be configured to prevent such cases. We have seen how to configure restriction code and setup Account/Dimension restriction code… Read More: How to restrict dimension relationships within dimension type »
Purchase return is normally a part of business. In which, goods are returned to the supplier if they had any defects or not according to the specifications of the buyer. In Sage X3, while creating Purchase Return we may come across an error like ‘The quantity to be returned exceeds the maximum authorized: 0 UN’.… Read More: How to resolve ‘The quantity to be returned exceeds the… »
