Posts

Showing posts from May, 2017

Sage X3 - Add or customize report in X3

Image
This is to show you how you can create a new or customize existing crystal report and link it to Sage X3. Here is taking Customer Invoice report as an example without changing any report parameters. First, You have to create a new report dictionary. Go to Development > Script Dictionary > Reports, select SBONFAC 'Customer Invoice' , rename it to ZSBONFAC. Change the Report name to ZSBONFAC also, this should same as your crystal report name. Once report dictionary created, you may add new print code for the report dictionary. Go to Setup > Destination > Print Code, create new print code for SBONFAC with new Print code = ZSBONFAC.  You need to create the default value for the new report, it will populate the default value before report is printed. Go to Setup > Destination > Default Values, duplicate SBONFAC and create new ZSBONFAC. Copy default values from SBONFAC to ZSBONFAC  for all the parameters. You may modify exis