Tag Archives: reports

How to add Custom Reports to Printer Icon on Customized Window

Report: A report is a document that presents information in an organized format for a specific purpose. Crystal Report: Crystal Reports is an application used to create custom reports from a variety of data sources. It includes the major features for an application to create database reporting environments, such as data access, report design/formatting, report viewing, and application integration. Crystal Reports… Read More »

How to open printing screen & print a desired report on click of customized menu item

In Sage X3, reports play an important role for representing transactions and records for analysis and growth perspective. Reports can be printed by navigating to the reports module as well as it can be printed via writing script file using 4GL code in sage X3. Sometimes there might be a requirement if the end user… Read More »

Formatting of text using HTML tags for Sage X3 Reports

In Sage X3, every company/site/supplier/customer have their addresses that we fetch from the respective screens to Standard or Custom reports. Normally we create a formula in Crystal Report for address with the required fields and place that formula wherever required. This can be also achieved by using HTML tags in formula. Using this method can… Read More »

How to setup commission factor for sales representative in X3

Commission also called a sales commission, is a payment given to salespeople for each individual sale. When planning a commission structure, sales leaders should consider factors like how much of their budget they can allocate for commission, how much they’ll pay for different levels of sales output, employee’s base salaries, and potential bonuses or incentives… Read More »

Configuring Financial Data Extraction in Sage X3 with Type of extraction as Account root

The Purpose of the Financial Data Extraction is representing Financial Data of an Organization/Company in form of Financial Reporting to their concerned stakeholders. This will help to evaluate the Company’s performance over specific period (Half-yearly/Yearly), eventually helping the management to take effective decisions based on the financial reports generated. Financial reports, Balance Sheet and Profit… Read More »

How to Assign Default Values to Crystal Reports

When launching a print option from an Sage X3 function, it can be interesting to propose default values to the launch setups. This function is used to store values by default for the print setups as a function of the launch context (identified by a function code). A print means printing a Crystal Reports report,… Read More »

Print Codes in Sage X3

A print code is a code used to launch the automatic prints within the framework of the software’s functions. A print is a generic term which may correspond to: Crystal Reports report. Request or an SQL query that is an inquiry which can then be printed. An export to a file by using an import-export… Read More »

Send Invoice Reports Automatically in Sage X3

Often we are requested for a feature that sends a mail along with a report copy of Invoice automatically when an Invoice is created in Sage X3. This blog will take you through a graceful solution that enables users to intimate the clients about the Invoice raised. Prerequisites: Print Server needs to installed and configured.… Read More »