Tag Archives: inquiry screen

How to Resolve “Index Incorrect FLD(80)” Error in Stock Transaction Inquiry Screen in Sage X3

The Stock Transaction Inquiry screen in Sage X3 is a powerful tool used to track and analyze stock movements across the system. It allows users to view detailed transaction history, helping in inventory monitoring, audit tracking, and decision-making. Recently, a client required the addition of a custom field in the Stock Transaction Inquiry screen. While… Read More: How to Resolve “Index Incorrect FLD(80)” Error in Stock Transaction… »

Implementing User-Specific Access Control in Sage X3 for the Receipt Line Inquiry Screen

In Sage X3, the Receipt Line Inquiry screen allows users to view and manage detailed information about receipt transactions, including inventory receipts, supplier deliveries, and other related data. By default, all users have access to view all records in this screen. However, due to a client requirement, we need to restrict access such that: To… Read More: Implementing User-Specific Access Control in Sage X3 for the Receipt… »

Time management and Inquiry Screen (Load and Capacity)

To equip its end user Sage X3 now has a Load and capacity screen to judge the work put in by a particular user on ERP. The view offers a graphical representation of time spent by a user with respect to different  time periods that can be years , hours , minutes and months. Projects… Read More: Time management and Inquiry Screen (Load and Capacity) »

How to increase or decrease the number of lines in grid of any Inquiry screen

In each module of Sage X3, it has its own set of inquiries that allows to search and filter predefined data collections using a variety of prebuilt parameters. For example, in the sales module we have created a number of Orders, so to check Order data we can use the list of orders inquiry screens… Read More: How to increase or decrease the number of lines in… »

Customization on Load WIP inquiry

Recently there was a requirement to flow the work center and it’s description from work center screen to Load WIP inquiry screen in Sage X3. Navigate: Manufacturing -> Planning -> Work Order -> Operations New Stuff: How to control the Scrap percentage while we make the Production tracking in Sage X3 Work Order Screen Initially… Read More: Customization on Load WIP inquiry »

How to flow data in a column of Inquiry Screens

In Sage X3, we have Inquiry screens which display all the information from tables based on a certain filter criteria. We recently had a requirement to add Description 2 and Description 3 fields in the Inquiry Screens. In this blog we will see how we can manually display Description 2 and Description 3 of a… Read More: How to flow data in a column of Inquiry Screens »

User Restrictions on Purchase Inquiry Screen

In Sage X3, Users can check all the purchase related data using inquiry screens. But there is one drawback of this functionality that any user can check the data of all the other users also using inquiry screens. To overcome from this drawback, we did customization on Purchase Inquiry screens. By doing which users can… Read More: User Restrictions on Purchase Inquiry Screen »

How to get an Open PO Amount using inquiry screens in Sage X3

At first, we will see, what is an Open PO Amount? After creating GRN/Receipt against Purchase Order, remaining amount of PO i.e. (Total PO Amount including Tax – Total Receipt/GRN Amount including tax) is the Open PO Amount. That means Open PO Amount will be calculated until that PO is open. If PO is closed,… Read More: How to get an Open PO Amount using inquiry screens… »