What are the changes in Web services in Sage X3 Product Update 9 and later?

Sage X3 Business Cloud product update brought 9 with it significant changes to web services, here is an overview

  • Generic SOAP web services are based on classic clients and act exactly like it did previously

  • The license now controls the data volume consumed through web service and there is no control on the count of clients defined in the pool

  • Web services are managed within the Syracuse administration, there is no more Console configuration

  • All setups and tests of web services will now be carried out in the new Sage X3 Web methodology (You can no longer use the “old” web tester)

Entities

  • hosts (Administration, ADMINISTRATION, Servers, Hosts): Defines the number of Web Service child processes. By default this is set to 0, so it must be configured. This allows you to work with the Sage X3 web load balancer mode

  • soapClassicPools (Administration>ADMINISTRATION, Web Services, Classic SOAP pools configuration): : Defines pools, count of clients to be initialized during pool setup, maximum count of clients allowed by pool (to avoid overload)
    Note: If you set two child processes and two clients per pool, you will have four clients started. (Nb of clients=Nb of child processes*Nb of clients per child processes)

  • soapGenerics (Administration, ADMINISTRATION, Web Services, Classic SOAP Web services): Retrieve WSDL description and is the internal tester for every operation (save, read, query, delete…)

  • restWebServices (Administration, ADMINISTRATION, Web Services, Rest web services):Declares outgoing rest web services to be used from the SAFE X3 dedicated API.

  • licenseViews: (Administration, USAGE, Session management, License follow up) Allows view into Web services consumption

License Parameters

  • WSGRACELIMIT: (%) defines the oversize percentage allowed (typically 10%) if the maximum size is fixed at 1MB / day, this means that:

    • 1 MB per DAY without speed limitation

    • The next 10% (100Kb) at a lower speed

    • The web service does not respond when the 1.1 MB limit is reached

  • WSGRACESLOWDOWN: indicates the rate used to decrease the speed of the Web services when the grace limit is reached

  • WSPERIOD: determines the period on which the size limitation applies (DAY/MONTH/YEAR)

  • WSSIZELIMIT: size, in MB, of the license for the web services

2021 PU2 onward change of web screen report printing process in Sage 300 Cloud

2021 PU2 onward change of web screen report printing process in Sage 300 Cloud

In previous versions of Sage 300 Cloud web Screens reports were generated in preview automatically in the same browser tab. However, after installing 2021 PU2, the default Export Report screen will be loaded into a new tab in your browser. You will now have to select the export format for the report and the export file will be downloaded to your downloads folder. To print a hard copy of the report, export your report to PDF first, then print it to a printer from the PDF.

How to work with the new changes

A note of caution, follow proper backup process and have a roll back point ready before you make any of the following steps.

Now, if you do not like to choose a different format to export to each time, you can configure the Export Report function to just export the report using the default format selected, perform these steps:

  1. Find the web.config file from the \Online\Web folder.
  2. Open the web.config file with a text editor.
  3. Search for the key: ReportPromptForExportFormat
  4. Change the value to: False
  5. Save the change.
  6. Restart IIS.

If you want to change the report format to a specific format, perform the following steps:

  1. Find the web.config file from the \Online\Web folder.
  2. Open the web.config file with a text editor.
  3. Search for the key: ReportDefaultExportFormat
  4. Change the default format value 5 to the one of the format values from the list above.
  5. Save the change.
  6. Restart IIS.

Format values available:

  • 3 = Word
  • 4 = Excel format
  • 5 = PDF format (Default)
  • 8 = Excel record
  • 10 = CSV format
  • 13 = XML

Please note this feature will be added to 2020.6 (PU6) also and it is expected to be released in August 2021.

If you’d like more assistance in sorting this out, please contact us on hello@evomatiq.com