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 »

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 »

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 »

How to repeat group header on each page in Crystal Reports

In Sage X3, we had 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 below screen shot). One would think that placing the captions… Read More »

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 »

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 »