A Change in report printing process with release of Sage 300 2021.2

By | July 11, 2023

In recent times, there has been a noticeable trend among Sage 300 users where they are transitioning from the traditional Sage 300 desktop application to the more advanced and user-friendly Sage 300 web screens. The continuous improvements made by Sage to both platforms have resulted in a more stable and reliable software experience. Users have reported that the latest versions of Sage 300 exhibit improved performance compared to previous iterations. These web-based screens offer a modern and intuitive interface, making it easier for users to navigate and perform tasks efficiently

New Stuff :- Sage300 Lot Master Screen Customization For Additional Details.

In this blog we are going to discuss  the most impactful change in Sage 300 Cloud with the release Sage 300 2021 PU2. Prior to this Product update the reports in web screens were generated in preview automatically in the same browser tab. However, with the introduction of the 2021 PU2 release, Sage has made a significant alteration to this functionality.  After this release, the preview of report is no longer displayed in SAP crystal Reports viewer. Instead of this, Sage has implemented a direct export feature for reports. While printing report, The Export Report screen appears in a new browser tab and provides options for saving a report to a file. The report with chosen format will be exported and saved to the user’s Downloads folder. It is important to note that if a physical hard copy of the report is desired, the report should be exported to PDF first, then users can proceed to print the report on a physical printer according to their requirements.

Please refer to below screenshot of Export report screen.

Report01

In order to enhance flexibility and accommodate user preferences, Sage has introduced two additional settings.

  • While exporting report, if you do not like to select the report format each time, you can force the Export Report function to just export the report using default form selected. To do the same please follow below steps:
    • Go to Web.config file from the \Online\Web folder.
    • Open the Web.config file in a text editor.
    • Look for the key: “ReportPromptForExportFormat”
    • Changes the value: False
    • Save the changes and restart the IIS.
  • If you want you change the report format to other, then follow below steps:
    • Go to Web.config file from the \Online\Web folder.
    • Open the Web.config file in a text editor.
    • Look for the key: “ReportDefaultExportFormat ”
    • Changes the default format value 5 to one of the format values from the list below.
    • Save the changes and restart the IIS.
  • Available format values:
    • 3 : Word
    • 4 : Excel format
    • 5 : PDF format(Default)
    • 8 : Excel Record
    • 10 : CSV format
    • 13 : XML

Please refer to below screenshot:

Report02

This change in the report generation process within Sage 300 Cloud through the 2021 PU2 release offers users a more streamlined approach to accessing and saving their reports, providing greater flexibility in handling and sharing information.

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation competence.

Greytrix offers unique GUMU™ integrated solutions of  Sage 300 with Sage CRM, Salesforce(listed on Salesforce Appexchange), Dynamics 365 CRM and Magento eCommerce along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 300 customization and development services and integration services for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP and for Sage 300c development services we offer, upgrades of older codes and screens to new web screens, latest integrations using Data and web services  to Sage business partners, end users and Sage PSG worldwide.

Greytrix offers 20+ addons for Sage 300 to enhance productivity such as GreyMatrixDocument AttachmentDocument NumberingAuto-Bank ReconciliationPurchase Approval SystemThree way PO matchingBill of Lading and VAT for Middle East. The GUMU™ integration for Dynamics 365 CRM – Sage ERP is listed on Microsoft Appsource with easy implementation package.

The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button.

For more details on Sage 300 and Sage 300c Services, please contact us at accpac@greytrix.com, We will like to hear from you.