When working with Sage X3 4GL, developers often customize screens by adding actions such as After Change, Before Entry, or After Entry to fields. However, things become a little more complex when the field is a dimension (array) field. A common challenge is that a field action is triggered for every dimension of the field,… Read More: How to Find the Current Index of a Dimension Field… »
Harness the power of Sage X3 with our custom solution that effortlessly converts your sales invoice data into JSON format, ready for uploading to a government portal through a third-party API. In this blog post, we’ll guide you through this tailor-made process. When it comes to E-invoice generation for government compliance, sometimes you need a… Read More: Download sales invoice data in JSON format through Sage X3 »
In Sage X3, we often work on data grid screens/masks where managing operations on multiple lines such as deletion, copying etc. becomes a hassle. However Sage X3 offers the users a way which operates with ease as shown below in an example of a patch creation where we want to remove several objects which are… Read More: Multiple grid lines selection & operation in Sage X3 »
In Sage X3, every now and then a requirement requires a defaulting screen/mask field with a value upon initialization or start of processing. To achieve this requirement, Sage X3 offers several ways such as scripting in the Action script under specific events or through screen dictionaries.Below we are demonstrating how to default value through screen… Read More: Defaulting Screen/Mask fields in Sage X3 »
In Sage X3, one of the client’s requirements was to get a left-list browser on a custom miscellaneous type window from where we were creating transactions in an unique way.Since we know for left-lists an object needs to be linked in the browser tab of the window under development window, and the object requires a… Read More: Refreshing the Left-List data for misc. windows using 4GL scripting… »
Sage X3 has Supplier master where we can define information about supplier, where we have added PAN number field which will store PAN number of supplier. So for that field one of our client requested us to add validation for PAN number which can accept only string in PAN format i.e. length of the string… Read More: PAN No Field Validation in Sage X3 »
In Sage X3, in customer master user have provision to define multiple addresses with different address codes. So one of our client has requested to add some custom fields on address tab of customer master. And flow it to the Sales order depending on the address code selection on Sales order screen Suppose user wants… Read More: How to flow custom fields from Customer master to Sales… »
In Sage X3, User have option to close Purchase order manually by using “close order” button on Purchase order screen. But one of our client has requested to automate this process on certain event so that user doesn’t have to take of this manually. To achieve this we have come up with some customization on… Read More: How to ‘Close PO’ programmatically using 4GL Script »
As we know, using attachment featured In Sage X3, user can attach various documents/files against any masters or transactions screen. With this feature users can attach file types like word document, Image, Text, PDF and Excel etc. The attached documents can be the reference/source documents of that particular entry. This helps all the users to… Read More: Calculating number of attachments in Sage X3 »
There are many a time when we need to get the aggregate or maximum function but 4GL Language does not offer a syntax for the same. But we definitely have an option to use SQL queries in 4GL and this does the most of the job for us. Just go through the statements mentioned below:… Read More: Executing an SQL Query Using 4GL Language »
