Category Archives: Integration

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

How to default Validity date to certain days from Date of creation for Sales Quote module

In Sage X3, Users can create Sales Quotes for keeping a track of which customer has placed their quotes for the products. When these quotes are created from the screen then the date of creation is defaulted to current date, there is another field in the Management tab of the screen called Validity date which… Read More: How to default Validity date to certain days from Date… »

Print error – The printing selection did not return any document.

In Sage X3, Version 12 we have encountered the error “The Print selection did not return any document” while printing the reports. As such issue did not occur in the lower versions, so we decided to troubleshoot the same. After checking various blogs, we found that this issue occurred in the Sage X3 v12 versions,… Read More: Print error – The printing selection did not return any… »

Validation on Gross/Net Price and Qty fields in Sales/Purchase Invoice Transactions

As we all know, while creating any transaction in Sage X3, we can enter quantity and price manually in detail line as per the requirement. But one of our client wanted to restrict the creation of the Sales/Purchase Invoice Transactions if the user is trying to enter ‘0’ in Gross/Net Price and Quantity fields. Even… Read More: Validation on Gross/Net Price and Qty fields in Sales/Purchase Invoice… »

Mailing label from the Crystal Report

In Sage X3, there various reports in each module which are printed by users whenever applicable. Also for warehouse users it mandatory to print the labels and stick on the products/Assets. One of our client has requested to design barcode label for their assets in their inventory. In this blog, we will see how to… Read More: Mailing label from the Crystal Report »