Sage X3 – Tips, Tricks and Components
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 »
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 »
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 »
Sage ERP X3 offers a basic functionality to optimize the grid by changing the AMKOPTION. For a section of the grid options, this field contains a list of characters as mentioned below, each representing an authorized basic function in the grid. We can add/remove each character in grid options column for optimization as we want… Read More »
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 »
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 »
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 »
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 »