Category Archives: Integration

Special Fields in Crystal Report prints in different language

In the Sage X3, you have various standard reports for almost every screen which are developed in Crystal Report. Also you can develop your own crystal report as per client need. After printing report, the content in the report gets printed depending on the language setup done in the Sage X3 for the login user.… Read More: Special Fields in Crystal Report prints in different language »

Enable Comment section for specific transaction type in sales invoice screen

In Sage X3, we have seen few fields on transaction screen are visible but users are not allowed to add data to these fields as they are non-editable fields. In similar way, on Sales invoice screen we found comment field as non-editable and user wants that particular field to be editable so that users can… Read More: Enable Comment section for specific transaction type in sales invoice… »

How to trigger a mail to the respective supplier against whom the RFQs has been created

In Sage X3, we recently had a requirement to configure an email to be triggered to the respective supplier against whom the RFQ has been created. So let’s see how we can create and configure an email. New Stuff: How to Check Quantity in PCS on QC Screen Step 1: Deploy the report. Step 2:… Read More: How to trigger a mail to the respective supplier against… »

How to Check Quantity in PCS on QC Screen

As we all know in Sage X3, whenever Purchase Receipt/ GRN is created with status “Q” then Quality Control entry of that Purchase Receipt/ GRN will be created automatically. So that user can enter the quantity which is Accepted, rejected or still remains in Quality. Recently we had a requirement from one of our client… Read More: How to Check Quantity in PCS on QC Screen »

Customization on Load WIP inquiry

Recently there was a requirement to flow the work center and it’s description from work center screen to Load WIP inquiry screen in Sage X3. Navigate: Manufacturing -> Planning -> Work Order -> Operations New Stuff: How to control the Scrap percentage while we make the Production tracking in Sage X3 Work Order Screen Initially… Read More: Customization on Load WIP inquiry »

Locking of delivery date and shipment date on the creation of Work Order against Sales Order

Recently we had a requirement from one of our client to lock the delivery date and shipment date fields in the sales order screen in such a way that once the work order is created against sales order then it will not allow the user to change/modify delivery date and shipment date fields in sales… Read More: Locking of delivery date and shipment date on the creation… »

Discount warning message on Sales Order based on the “Allowed Discount” field

As seen in our previous blog, we discussed about warning message validation on credit note as per the financial year. Today we are going to discuss another customization on the Sales Order screen which is very useful to users in their business process for customer transactions. One of our client has requested to have some… Read More: Discount warning message on Sales Order based on the “Allowed… »

Duplicate PAN Number Validation on Customer Master in Sage X3

Sage X3 has master screens like Product master, Supplier master, Customer master etc.. where we can save information about object, means in product master we can save data about product, in supplier master we can save information about supplier like wise. So as per the client’s requirement, we have added PAN No field at customer… Read More: Duplicate PAN Number Validation on Customer Master in Sage X3 »

Restriction on Sales Order if date exceeds the defined due date

Due date is defined in every Sales/Purchase transaction in Sage X3 on the basis of Payment terms and Payment terms is a mandatory field in every transaction. One of our client requested to restrict Sales Order transaction on the basis of due date. Number of days beyond which if payment of posted Sales Invoice is… Read More: Restriction on Sales Order if date exceeds the defined due… »