Category Archives: Integration

Restriction on Purchase Invoice creation

As per the standard functionality of Sage X3, if the user is entering same Supplier Document No in new Purchase Invoice entry which is already entered or used in the existing invoice entry then user gets a warning message popup that “Reference entered on Invoice(Invoice No)” as shown in the below screenshot. But after clicking… Read More: Restriction on Purchase Invoice creation »

How to add Comment Text from transaction screen to the Crystal Report

In Sage X3, user have an option to add comment against every transaction screen on right panel after attachment symbol. In this comment field user can enter an additional information as per the requirements for e.g. description, terms & conditions, declaration, note etc. This comment field is considered as a header comment field which is… Read More: How to add Comment Text from transaction screen to the… »

How to add selection screen on field action

In Sage X3 , selection screen on a particular field helps users to search easily and select as per the requirement. In Sage x3, If user want search selection should be there on any field, then it is easy if we are directly using custom data type for the same, but if we have used… Read More: How to add selection screen on field action »

Multiple ways to sign a standard workflow

Sage X3 provide us multiple ways to sign a record in workflow process. There are various ways which helps user to save their time. Basically a user goes manually to a particular transaction and searches the record and then signs the record, this process is bit time consuming but we have few different methods to… Read More: Multiple ways to sign a standard workflow »

How to solve formatting issue in V12 using “Break After”

In earlier version of Sage X3 (before V12), whenever there was any requirement from client to add custom fields on standard transaction/master screen, developer has to select the position and block in which it will be displayed and has to place those fields by giving specific numbering to it. But most of the time, developer… Read More: How to solve formatting issue in V12 using “Break After” »

Restriction on WO Close unless Quality Transaction is clear

As you all know in Sage X3, Users can close any Work Order after Production Tracking by using WO Close screen. But one of our client wanted to restrict that WO Close functionality until that particular Work Order is Completely Tracked and Quality Control Transaction is done. Now we will see both the conditions one… Read More: Restriction on WO Close unless Quality Transaction is clear »

How to enable select all check box in the left side panel in Sage X3

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… »

How to exclude header part on the last page on Purchase Order Report

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… »

Change the Date Format Using 4GL Script

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 »

User Restrictions on Purchase Inquiry Screen

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 »