In Sage X3, one of the client’s requirements was to have a comparison report for Quotes made by the suppliers for the given RFQ products. This report needed to have a dynamic nature of rows-columns design for which we’ve implemented the use of cross-tab option in Crystal report. New Stuff: Weigh Bridge Integration in Sage… Read More: Dynamic Row-Column structure report for Quote comparison »
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… »
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 »
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 »
In Sage X3, one of our client requested to add the currency symbol before the amount in the Purchase Order report according to the currency field in Purchase Order screen. New Stuff: How to print a field once which is repeating in Sage X3 report Currency Field Follow the below steps to achieve the above… Read More: How to add dynamic currency symbol in Sage X3 report »
In Sage X3, developer has freedom to develop their own reports in Crystal reports as per their client requirement. So we have also developed one of the report in India pack report called as Vendor transaction/Ledger report. This report display all the vendor transactions for selected parameter range. In this report, there is section where… Read More: How to print a field once which is repeating in… »
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 add Custom Reports to Printer Icon on Customized… »
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: Formatting of text using HTML tags for Sage X3 Reports »
In Sage X3, user have an option to add comment against every transaction screen on right panel after attachment symbol. In this comment field user can enter an additional information as per the requirements for e.g. description, terms & conditions, declaration, note etc. This comment field is considered as a header comment field which is… Read More: How to add Comment Text from transaction screen to the… »
Sage X3 reports are developed in Crystal reports and can be modified as per user needs if you have required Crystal version installed on developer system. One of our client has requested to add ‘Terms and conditions’ on last page of the Purchase Order report. This was one of the easy task to add on… Read More: How to exclude header part on the last page on… »
