Tag Archives: Grid

Adjusting the number of lines to display in the Enterprise Planning screen

In Sage X3, there is an Enterprise Planning screen that provides a view of work in progress events based on actual demand. Events can include internal and external orders such as customer orders, supplier orders, subcontract orders, transfer orders, work orders, requests, transfers, material requirements and project demand. It operates by temporarily extracting data from… Read More: Adjusting the number of lines to display in the Enterprise… »

Adjusting the Number of Displayed Lines in the View Queries Screen

In the Reports module of Sage X3, there is a View Queries screen that enables users to search predefined data collections on screen. This functionality utilizes a graphical query tool designer, which is responsible for designing queries based on the SQL language. The graphical query tool designer includes a function to create screens that display… Read More: Adjusting the Number of Displayed Lines in the View Queries… »

Receipt selection at purchase invoice screen with Provisional Freight charges

Provisional freight charges refer to estimated freight costs that are temporarily assigned to transactions in Sage X3 ERP until actual freight costs are determined. These charges are useful when the exact freight costs cannot be determined at the time of transaction entry.Provisional freight at purchase receipt in Sage X3 ERP involves estimating and recording freight… Read More: Receipt selection at purchase invoice screen with Provisional Freight charges »

Error:“@X3.TRT/PJMTIMEMP_CSTD_PROPERTIES$adx (994) Error 112 : Non-existent structure member PRGBILNUM” at Project module Time Entry

In Sage X3, the process of entering time for a project involves specifying various details such as the date, task, and the amount of time spent on the project. This can be facilitated through the use of the assignment grid, where tasks assigned to an employee are conveniently displayed at the top, allowing for accurate… Read More: Error:“@X3.TRT/PJMTIMEMP_CSTD_PROPERTIES$adx (994) Error 112 : Non-existent structure member PRGBILNUM” at… »

How to implement validation on the Grid right click selection

This blog post will guide you in implementing validation before performing any standard right click selection functionality in the grid level. New Stuff: How to execute Import utility using code? Status is the variable used to know the result of an entry operation. There are various possible values for this variable depending on the entry operation.… Read More: How to implement validation on the Grid right click selection »

Adding selection window for any action

Sage ERP X3 provides the functionality of Select Recordings in a grid, via a window. Choose is used to open a window on a list of recordings extracted from a table and then to select a recording. New Stuff: Adding Menu Items in Sage ERP Version7 Syntax: Choose class [ Where Where_exp]  [ Order by  Order_by_exp… Read More: Adding selection window for any action »

Implementing Screen created using Table/Grid Option “KARIDAS”

In our last blog we have discussed the “Options” feature in the Table Block of the Screens, now lets check how it works. The below screen is GL Journal Entry [Lines Tab], which comprises table with option “KARID4S”, this option will enable the features as per the abbreviations set. i.e. K- Previous & next line… Read More: Implementing Screen created using Table/Grid Option “KARIDAS” »

Designing Screen using Table/Grid Option “KARIDAS”

Sage X3 allows an easy method to design screens, where in we have option to design screens in the form of Blocks. These Blocks can be of different types, List, Table, Dialogue etc. Now as you know that, Header and Detail screens are indispensible in any ERP software. It is an industry practice to display… Read More: Designing Screen using Table/Grid Option “KARIDAS” »