As we all know, in Sage X3 when users want to create Purchase invoice against purchase receipt, he/she has to select receipt from the left list one by one. Recently one of our client wanted to have an option to select all Receipts in a single click from the left side panel while creating purchase… Read More: How to enable select all check box in the left… »
Sage X3 reports are developed in Crystal reports and can be modified as per user needs if you have required Crystal version installed on developer system. One of our client has requested to add ‘Terms and conditions’ on last page of the Purchase Order report. This was one of the easy task to add on… Read More: How to exclude header part on the last page on… »
As we know, Sage X3 supports multiple date formats as per the user’s requirement. The default date format in Sage X3 is set in setup–> Parameters. The developers who want to manipulate the date field value can use the date format using 4GL script. Also, there is an inbuilt string function that can be useful… Read More: Change the Date Format Using 4GL Script »
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 »
An inquiry screen is used to extract information from one or more table and present it in the from of a grid. It help us to display the records based on the filter criteria we entered. In Sage X3, we have a multiple inquiry screens available such as Stock by product, stock by lot,stock by… Read More: How to create and add formula on inquiry screen »
In Sage X3, we may come across a situation where we need to create a query tool by adding fields from the table also while adding fields we may get the below error as shown in Fig 3. Step 1: To create a query tool Go To -> Set up -> Usage -> Reports ->… Read More: How to Create Query Tool to Get Desired Output in… »
In Sage X3 V12, a new functionality is added which will help in enhancement in quality standard. In any organization it’s important to maintain Quality control process be it at sales level, manufacturing level or purchasing level. Quality control is a critical aspect of the development cycle of a product also on handling return products… Read More: Non Conformance Management in Sage X3 V12 »
In sage X3, enter key has some default functionality for e.g. in some screens it is used to trigger OK button functionality while in grid level it is used to jump on the next line and so on. So, depending on the requirement and screen type Enter key has different types of functionalities. But with… Read More: How to change Enter key functionality »
Sometime we may come under a situation where we need to restrict the purchase order if there is no purchase request. This scenario can be handled on the basis of product. We may have a condition where we need to apply this restriction only for some type of product. We can apply this restriction for… Read More: Restricting purchase order creation if there is no request/open order »
In sage X3, we have a functionality of printing various types of reports such as Order, Invoice, Payments, and Receipt etc. This report is created by using a crystal report. Crystal Report is a very powerful tool used to pull data from sage and present it in a ways you want. Sometimes in crystal report,… Read More: How to Exclude Weekends From Total Number of Days in… »
