Category Archives: Integration

Validation on the Sales order screen if credit limit exceeds

In Sage X3, the maximum credit amount for the customer can be defined in the authorised credit field in the Customer master. There are 3 options available in the in Management tab in Customer master:-Check-No check-Hold With the help of these options we can easily manage the Credit limit of the customer.We had a requirement… Read More: Validation on the Sales order screen if credit limit exceeds »

Warning message on the screen when “To date” is smaller than “From date”

Sage X3, is a complete business management solution designed to drive productivity and give you total control and visibility of your enterprise. With customizable configuration, the flexible solution equips you with everything you need to drive business success. Easy to understand all the modules. Recently, we had a requirement from one of our client for… Read More: Warning message on the screen when “To date” is smaller… »

Product Code and Description Automation

In Sage X3, we recently had a requirement to generate custom product code based on the product category, specifications selected by the user, and to generate product description based on the product code. Screen path:Miscellaneous tables:Development – > Miscellaneous tables – > DefinitionDevelopment – > Miscellaneous tables – > DataWindow:Development -> Script Dictionary-> Windows ->OITM… Read More: Product Code and Description Automation »

How to Repeat Group Header on Each Page in Crystal Reports

In Sage X3, we developed one custom report for our client where the detail section continues to the next page of the report but the heading/captions did not get printed on each page as captions were placed on the group header section (please refer to screenshot below). One would think that placing the captions in… Read More: How to Repeat Group Header on Each Page in Crystal… »

How to solve “Transaction stopped” error while creating sales invoice in Sage X3

Sage X3 is enterprise resource planning (ERP) product which helps organization to manage all the operation of organization and database into a single software solution. Sage X3 contains list of modules like sales, purchase, inventory, project, financial and many more. In sales module, sometimes an error occurs – “Transaction stopped” while creating sales invoice as… Read More: How to solve “Transaction stopped” error while creating sales invoice… »

Addition of Location in Physical elements screen in Fixed Asset Module

Recently in Sage X3, we had got a requirement from the client to add the Location field in Physical elements screen in the Fixed Asset tab. New Stuff: How to create process flows in Sage X3 V12 [Fixed Asset Screen – Physical element] For this we first need to add the field in “PHYELT” table… Read More: Addition of Location in Physical elements screen in Fixed Asset… »

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 »