In Sage X3, we have created a screen where in Tax Invoice report is getting printed from the Tax invoice custom screen. In this screen we have added a filter “From Invoice” and “To Invoice” number which filters the list of invoices which are posted in a selected range. New Stuff: Formula based Material Issue… Read More »
You may come across the situation, where you want to filter the X3 table/view with the user-defined conditions through code. The following sample code will help you to provide the user defined conditions to filter the table. New Stuff: How to validate begin and ending range in X3 grid…? Step 1: Declare the variables and open… Read More »
Sometimes you may come across a situation where you want to give selection on any field using tables which are not the linked tables of the object. New Stuff: Guide to setup Recurring Journals In Sage X3 we can add selection (F12 functionality) and filter the selection records as per the requirement. Kindly follow the below… Read More »
We can easily assign the F12 selection to the fields by associating the data type that with the fields. But what if there is need to filter the selection records dynamically? Sage X3 has Standard action GSELECT, with the help of this action we can add a F12 selection to field and also we can… Read More »
In X3, we developer may come across with the requirement where we need to filter the local menu values for the fields. There are simple techniques available in X3 to filter the local menu values. Follow the below steps to filter the local menu field records: The M data type of local menu is non-modifiable… Read More »
In Customization, we developer may come across the situation where there is a need to filter the left list of the Sage X3 screen. We can achieve this with the simple code. CLEGAUCHE is the action which called before loading the left list so we can use this action to modify the characteristics of the sort… Read More »
Almost all the Sage X3 developers are aware of the concept of miscellaneous tables; which are nothing but the inbuilt tables of Sage X3. But theses Miscellaneous tables have a very convincing feature called “Dependent Table”. This feature is applied when we need to create a selection field which will be dependent on another parent… Read More »
We have created a second company using similar core model and the new user will work only for this specific company (everything in one folder). What is the easiest way to set a filter between companies and assign this filter per user? The Filter should be switched in one place and will work for all… Read More »