- What's new in Product Update 8
- What's new in Product Update 7
- What's new in Product Update 6
- What's new in Product Update 5
- What's new in Product Update 4
- What's new in Product Update 3
- What's new in Product Update 2
- What's new in Product Update 1
- What's new in Sage 300 2018
- Technical information
- Product Update 8 program fixes
- Product Update 7 program fixes
- Product Update 6 program fixes
- Product Update 5 program fixes
- Product Update 4 program fixes
- Product Update 3 program fixes
- Product Update 2 program fixes
- Product Update 1 program fixes and technical changes
- General information
- Compatibility with other programs
- Known issues
- Installing Sage 300
- Installing product updates
- Removing Sage 300
- Canadian Payroll
- US Payroll
- Sage 300 Intelligence Reporting
- Sage Intelligence Reporting Cloud
Sage 300 2018 release notes
Thank you for choosing a Sage business management solution.
These release notes contain important information about Sage 300, including information about product changes that are not in the documentation.
Product updates contain modified versions of one or more Sage 300 program components. A product update is not a full upgrade or a product replacement. Each product update is valid only until we release the next product update or the next version of Sage 300.
Depending on your purchase agreement, some features described here may not be available in your product.
What's new in Product Update 8
This product update includes fixes to both Sage 300cloud web screens and Sage 300 classic desktop screens. For details, see Product Update 8 program fixes.
What's new in Product Update 7
This product update includes fixes to both Sage 300cloud web screens and Sage 300 classic desktop screens. For details, see Product Update 7 program fixes.
What's new in Product Update 6
This product update includes fixes to both Sage 300cloud web screens and Sage 300 classic desktop screens. For details, see Product Update 6 program fixes.
What's new in Product Update 5
This product update includes fixes to both Sage 300cloud web screens and Sage 300 classic desktop screens. For details, see Product Update 5 program fixes.
What's new in Product Update 4
This product update includes fixes to both Sage 300cloud web screens and Sage 300 classic desktop screens. For details, see Product Update 4 program fixes.
What's new in Product Update 3
This product update includes fixes to both Sage 300cloud web screens and Sage 300 classic desktop screens. For details, see Product Update 3 program fixes.
What's new in Product Update 2
This section contains a summary of new features and changes in Product Update 2.
Simplified process for updating workstations
When installing a product update that includes changes to workstation setup, you now update workstations by simply reinstalling workstation setup. You no longer need to uninstall workstation setup first.
Changes to the way you enter subscription license information
If you have a Sage 300cloud subscription, enter your System Manager serial number on the License Information tab of the License Manager screen, in the Serial Number field. After entering the serial number, click Refresh.
Sage 300cloud web screens improvements
This product update includes the following new features and improvements in Sage 300cloud web screens:
- Improved way of selecting report formats. On reports that use an RPT file to determine the print layout, you now select the report format using a Finder instead of a Browse button. The Finder allows you to search through all RPT files that are available in the default directory and any customization directories assigned to you.
Note: To use custom reports in Sage 300cloud Web Screens, the Sage 300 application pool’s identity account in IIS Manager must have Read and Execute access rights to Customization directory.
- Sage Budgeting and Planning. Sage Budgeting and Planning now integrates with Sage 300cloud, and is offered in a limited use capacity at no charge. Sage Budgeting and Planning is a flexible and powerful planning and budgeting application, which helps enable quicker, more informed business decisions by automating and shortening the budgeting and planning cycles.
To download Sage Budgeting and Planning, go to Sage Budgeting and Planning.
Note: Sage Budgeting and Planning may not be available in all regions.
EU General Data Protection Regulation (GDPR) and Sage 300 Anonymizer
The GDPR is a set of laws that comes into force on May 25, 2018. The GDPR applies to you if you process or hold the personal data of people residing in the European Union, even if your company is located outside the EU.
In some situations, the GDPR may legally require you to stop holding personal data for an individual. In part, this means removing a customer or vendor’s personal data (such as their name and address) from Sage 300. A new tool—Sage 300 Anonymizer—helps you do this. To download Sage 300 Anonymizer and learn more about using it, see Knowledgebase article 88838.
Payroll Cheque Exporter for Canadian Payroll
A new Payroll Cheque Exporter tool lets you export data from payroll cheques. The data is exported to a file that you can open in Microsoft Excel to analyze payroll history (for example, to help determine vacation/holiday pay). To download the Payroll Cheque Exporter and learn more about it, see Knowledgebase article 90019.
What's new in Product Update 1
This section contains a summary of new features and changes in Product Update 1.
General improvements
This product update includes the following new features and improvements in both Sage 300cloud web screens and Sage 300 classic screens:
- Receive copies of emails that you send to customers or vendors. You can receive copies of emails that you send. To do so, in the Send Copies To field on the Email tab of the Company Profile screen, enter one or more email addresses where copies should be sent.
- Clear tax history by tax authority and date range. On the Tax Services Clear History screen, you can now control which transactions are cleared by entering a range of tax authorities and either fiscal periods or document dates.
- Generate tax tracking reports for any date range. On the Tax Tracking report, when reporting by document date, you can now specify a starting date for the range of document dates.
- Customize Sage 300 so users see only companies for which they have security rights. If security is turned on for your Sage 300 system, you can set up your system so that users see only companies for which they have security rights when they sign on. For more information, see Sage Knowledgebase article 21367 and Sage Knowledgebase article 87424.
- See when you last ran day-end processing. The I/C Day End Processing screen, or the P/O Day End Processing screen if you use Purchase Orders as a stand-alone program, displays the last date and time that you ran day-end processing.
Sage 300cloud web screens improvements
This product update includes the following new features and improvements in Sage 300cloud web screens:
- Redesigned toolbar and menus give you more space on web screens. To give you a little more room to work, we have moved the navigation menu to the left side of the screen and made it possible to hide the web toolbar (click Tools at the top of the screen).
By default, the navigation menu is displayed in a collapsed mode that shows small icons for each module. When you point to the menu, it automatically expands to show the full names of modules. You can permanently expand the menu by clicking Expand Menu
at the bottom of the menu.
- Improved navigation menu makes it easier to find screens and features. Administrative Services, Common Services, Bank Services, and Tax Services are now at the top level of the menu along with other modules. Also, items on the menu are listed in a more meaningful order.
- Filter data when exporting. When exporting data, you can apply filters to export only data that meets certain criteria.
- Use custom formats when printing reports in Order Entry, Purchase Orders, and Inventory Control. On reports that use an RPT file to determine the print layout, a new Browse button allows you to specify any valid RPT file, including but not limited to the standard ones that come with Sage 300.
- Enhanced user language setting. Specifying a user’s preferred language on the Users screen sets the user’s language for both Sage 300 classic screens and Sage 300cloud web screens. (For Sage 300cloud web screens, users no longer need to specify their preferred language in their browser.)
Also, user languages now include locales, which affect Sage 300cloud web screens. A locale identifies the user’s country or region - for example, English (United States) or English (Canada) – and affects the presentation or formatting of some information, such as dates.
What's new in Sage 300 2018
This section contains a summary of new features and changes in the 2018 release.
General improvements
This release includes the following new features and improvements in both Sage 300cloud web screens and Sage 300 classic screens:
- Export Declaration Number field. On the Taxes tab of the A/R Invoice Entry and O/E Invoice Entry screens, an Export Declaration Number field allows you to enter export declaration numbers for exported goods. This information is required for tax purposes in some jurisdictions (such as Malaysia and Singapore).
Sage 300cloud web screens improvements
This release includes the option to install Sage 300cloud web screens: modernized versions of Sage 300 screens that you can use in a web browser.
Web screens run in parallel with the classic Sage 300 desktop screens, so there's no need to choose between desktop or web. Everyone in your organization can use the interface that best suits their needs, while working seamlessly with a single shared set of company data.
Here's a quick overview of what's new in Sage 300cloud 2018 web screens:
- Find and open recently used windows. On the web toolbar, a new Recently Used Windows list displays windows you've opened recently, making it easy to quickly find and open those windows again.
- Improved performance in the Finder. The Finder displays results faster than in previous versions of Sage 300, particularly when using a large database.
- Improved import/export process in I/C Physical Inventory Quantities screen. When importing and exporting data on the I/C Physical Inventory Quantities screen, you can now choose to import/export data from the detail table (select Inventory Worksheet Header) or the fields above the detail table (select Inventory Worksheet).
To learn more about new web screens and features available in this release, see the following documentation and resources:
Important! When using Sage 300cloud web screens over an external network or the internet, data must be protected with security measures such as Secure Socket Layer (SSL) or a Virtual Private Network (VPN). To determine appropriate security measures, consult with your information technology (IT) professional or Sage Business Partner.
If you use Sage Intelligence Reporting Cloud, we recommend that you configure Sage 300cloud web screens to run in a secured environment using digital certificates. If you do not, warnings will appear in your browser each time you start Sage Intelligence Reporting Cloud. For more information, see Knowledgebase article 84797.
Web screens are available in English, French, Spanish, and Chinese (Simplified and Traditional). Help and documentation for web screens is available in English and French.
Note: Users may need to adjust their web browser settings to ensure that web screens appear in the correct language. The preferred language for viewing web pages (specified in web browser settings) must match the language specified for the user in their Sage 300 user record.
Sage 300 classic screens improvements
This release includes the following new features and improvements in Sage 300 classic screens:
- Fresh, Modern Look and Feel. We've updated Sage 300 classic screens and visual process flows to make it easier to find information and complete tasks:
- The new visual appearance, including redesigned buttons, makes information clearer and more accessible.
- Tools and controls on the desktop now appear on a ribbon (instead of menus and a toolbar), making them easier to find and use.
- A new theme is available for visual process flows.
Technical information
This section provides information about
Product Update 8 program fixes
The following sections describe program fixes included in Product Update 8.
Printing Reports in Web Screens
When viewing Sage 300cloud web screens using Chrome version 83 (or newer) as your browser, you can print and export reports to files.
Product Update 7 program fixes
The following sections describe program fixes included in Product Update 7.
Report Printing
Fixed a problem in Sage 300cloud web screens that could prevent you from printing reports if you (or others in your organization) use the Reports list to open reports.
Note: If you use Firefox as your browser, you must close reports in the Window Manager before closing your browser. Otherwise, you or others may later be unable to print reports.
Product Update 6 program fixes
The following sections describe program fixes included in Product Update 6.
Project and Job Costing
Fixed a problem that could cause the Contract Maintenance screen to perform slowly or stop responding. This problem occurred if you repeatedly opened the Category Maintenance screen for different categories.
Accounts Payable
Fixed a problem in Sage 300cloud web screens on the Detail/Taxes screen for invoices, which could cause an incorrect amount to appear in the Tax Base field. This problem occurred if you changed the item tax class for a detail from a taxable tax class to an exempt tax class.
Product Update 5 program fixes
The following sections describe program fixes included in Product Update 5.
Accounts Receivable
In Sage 300 classic screens, the Refund Batch List screen performs faster, particularly when working with large batch lists.
Inventory Control
If you have set up G/L integration to create G/L transactions by adding them to an existing batch (this setting is specified on the G/L Integration screen), day end processing now performs faster than it did previously.
Ops Inquiry
Fixed a problem on the IC Item Inquiry screen that could prevent the Customer PO # from appearing. This problem occurred when posting an OE order with a PO number.
Sage 300 SDK
Fixed a problem that could prevent users from importing user authorizations for a subclassed program.
Product Update 4 program fixes
The following sections describe program fixes included in Product Update 4.
Item Finder
Fixed a problem that could cause incorrect quantities to be displayed in the Item finder.
Accounts Receivable
Fixed a problem in Sage 300cloud web screens that could prevent you from opening the Refund Entry screen. This problem occurred if you have activated only the Sage 300 financial modules.
Ops Inquiry
- When you open the Item finder on the Ops Inquiry IC Item Inquiry screen, the finder displays the same criteria you specified the last time you used this finder.
- On the Ops Inquiry IC Item Inquiry screen, the S/Os and Qty. Avail. tabs now open faster.
Product Update 3 program fixes
The following sections describe program fixes included in Product Update 3.
Activating Sage 300 programs
Fixed a problem that could prevent you from activating the Account Code Change, Customer Number Change, Item Number Change, or Vendor Number Change programs.
Help on Workstations
Fixed a problem that prevented you from opening help on workstations by pressing F1.
Accounts Receivable
- Fixed a problem that caused emailed customer statements to incorrectly display the statement balance where they should display the outstanding balance.
- Fixed a problem that occurred in Sage 300cloud web screens on the Invoice Batch screen, which prevented you from posting an invoice batch with a batch number greater than 32768.
Accounts Payable
Fixed a problem on the Create Payment Batch screen that could cause slow performance when generating payment batches if the Only Forced Documents option was selected.
Inventory Control
Fixed a problem that could occur when generating an inventory worksheet from the Physical Inventory screen, which caused Sage 300 to stop responding.
Purchase Orders
- In Sage 300cloud web screens on the Create PO From Requisition screen, when you use the Finder for the Requisition Number field, the Search button in the Finder is not available. Previously, this button looked like it was available, but if you clicked it an error message appeared.
- Fixed a problem in Sage 300cloud web screens that could occur when printing Purchase Orders report using POPOR04.RPT and POPOR05.RPT from the P/O Forms screen.
Project and Job Costing
Fixed a problem in Sage 300 classic screens that could cause the Contract Maintenance screen to stop responding.
Ops Inquiry
Fixed a problem on the S/Os tab of the IC Item Inquiry screen, which prevented information from being displayed in the Customer PO # field.
Item Number Change
Fixed a problem that could occur when combining item numbers, which caused the Item Number Change screen to stop responding.
Product Update 2 program fixes
The following sections describe program fixes included in Product Update 2.
Printing Checks
When printing checks from Accounts Payable or Accounts Receivable, if a check language other than English is specified for the transaction to which a check relates, the check amount is printed in the specified language. Previously, check amounts were always printed in English.
Performance
Fixed a problem in Sage 300 classic screens that could cause slow performance when opening screens.
Notes in Sage 300 Classic Screens
Fixed a problem in Sage 300 classic screens that could cause the Notes screen to stop responding.
Optional Fields in Sage 300cloud Web Screens
In Sage 300cloud web screens, when using the Finder in the Value field for an optional field, you can search for a specific value or part of a value.
Bank Services
Fixed a problem that occurred in Sage 300 classic screens on the Reverse Transactions screen, which prevented EFT Payroll Checks from appearing if you selected the Reverse Multiple Transactions option.
Accounts Payable
In Sage 300cloud web screens, the Vendor Currency field on the Payment Entry screen displays the vendor’s currency. Previously, the field displayed nothing.
General Ledger
Fixed a problem that could occur when printing from the Print Financial Statements screen in Financial Reporter, which could cause the Paper Size field on the Print for Print Financial Statements screen to display nothing or to display an incorrect paper size.
Inventory Control
- Fixed a problem that could cause an optional field to incorrectly appear on a serialized item. This problem sometimes occurred when you created a PO receipt that included multiple serialized items, some of which have optional fields assigned to them.
- Fixed a problem on the Update Item Pricing screen that prevented you from updating item pricing if you specified an optional field in the Select by field, and you specified the same value in both the From and To fields (as opposed to two different values to define a range).
Order Entry
- Fixed a problem on the Order Entry screen that occurred if you upgraded from Sage 300 2012, which replaced the date in the Deliver By field with the date from the Order Date field.
- Fixed a problem that could occur when creating an order from quotes, which set the Tax Included field for details on the order to “No”, regardless of whether “Yes” was specified on the quotes. This problem occurred if you selected the From Multiple Quotes option on the Order Entry screen, and then used the Create Order from Quotes screen to select quotes.
- Fixed a problem in Sage 300cloud web screens that occurred on the Order Entry screen when viewing an order with more than 10 details, if the number of details on the order is a multiple of 10 (that is, 20, 30, 40, and so on), in which case the Details table displayed only the last 10 details.
Project and Job Costing
- Fixed a problem with the Posted Documents section of the Clear History screen, which caused posted documents to always be cleared based on Transaction Date, even if you selected Year/Period in the Cutoff By field.
- On the Transaction History screen, for a debit note that has been applied to a credit note, the details table shows two rows: one with a transaction type of Posted, and one with a transaction type of Apply To. Previously, the details table showed only the row with a transaction type of Posted.
- Fixed a problem that caused the Timecards screen to stop working if you specified in the Employee Number field an employee who you do not have permission to view.
Sage 300 SDK
- Fixed a problem that occurred if you used 10-digit field IDs in a program developed using the Sage 300 SDK, which prevented the program from working.
- In programs developed using the Sage 300 SDK, you can now use custom colors for grid cells on Visual Basic screens.
- Fixed a problem that occurred if you have subclassed the G/L Account Segments view (GL0022), which caused an error message to incorrectly appear when opening some Sage 300cloud web screens.
Product Update 1 program fixes and technical changes
The following sections describe program fixes and API enhancements included in Product Update 1.
Signing On
Fixed a problem that could cause a "Server Busy" message to appear when signing on to Sage 300.
Default Fiscal Periods
Fixed a problem in Sage 300cloud web screens, which could cause an incorrect year and period to appear by default on some screens. This problem occurred if Period 1 in your fiscal calendar is not January 1–January 31.
System Manager
Fixed a problem that could cause Sage 300 classic screens to stop responding in certain circumstances.
Bank Services
Fixed a problem on the Reverse Transactions screen that prevented you from finding cleared checks if you selected the Reverse Multiple Transactions option.
Accounts Receivable
Fixed a problem that could cause the Customer Inquiry screen to stop responding when you were scrolling through details on the Documents tab.
General Ledger
- Fixed a problem caused by an update for Microsoft Office 2016, which could prevent you from printing financial statements using Financial Reporter.
- Fixed the following problems in Sage 300cloud web screens:
- If you use an account structure that does not begin with the Account segment, the following problems occurred on some reports when using the Finder to select an account segment:
- The Finder displayed incorrect information.
- When you selected an account segment in the Finder, it was not correctly entered in the field.
- When using an account structure with multiple segments, some reports incorrectly excluded some accounts.
- If you use an account structure that does not begin with the Account segment, the following problems occurred on some reports when using the Finder to select an account segment:
Purchase Orders
- Fixed a problem that prevented you from posting receipts.
- Fixed a problem in Sage 300cloud web screens, which could cause an error message to incorrectly appear when deleting an item from the detail table on the Purchase Order Entry screen.
Order Entry
- Fixed a problem that could prevent you from entering non-stock items on orders or using a macro to import orders that include non-stock items.
- Fixed a problem that could occur when closing the Current Orders Inquiry screen, which caused the screen to stop responding. This problem occurred only if you use Ops Inquiry.
- Fixed a problem in Sage 300 classic screens that could prevent you from drilling down to shipments from the Order Entry screen. This problem occurred if you have security authorization to view shipments, but not to enter or change shipments.
Project and Job Costing
Fixed a problem that prevented you from posting material returns.
Sage CRM Integration
If you change a customer or vendor record in Sage 300 and the customer or vendor ID begins with a space, the record is correctly updated in Sage CRM. Previously, a duplicate record was created in Sage CRM without the initial space in the customer or vendor ID.
Sage Fixed Assets Integration with Sage 300
Fixed a problem that caused the Options screen to stop responding if you clicked Synchronize.
Web API
A new GLSegmentCodes API end point allows you to work with G/L segment codes.
General information
- Sage 300 2018 supports upgrades only from versions 5.6, 6.0, 2012, 2014, 2016, or 2017.
-
If you use the Web Deployment option (distinct from the portal), note that:
- Sage 300 2018 does not support the DCOM remoting channel for Web Deployment.
- Adobe Reader is required to view and print reports in PDF format. To download the latest version of the free Adobe Reader software, visit: http://get.adobe.com/reader
- If you use workstation setup, you must also run Sage 300 Intelligence Reporting workstation setup (located in BX64A\WSSetup) on every workstation where you will view and use Intelligence Reporting screens.
- You require version 2018 (internally versioned as 6.5A) of all core programs that you plan to use.
If you use Canadian Payroll or US Payroll, you require version 2018 (internally versioned as 7.3A) of these programs.
Note: You must install Sage 300 before installing payroll programs.
- If you are upgrading from an earlier version, you must upgrade all Sage 300 programs to 2018 at the same time. Sage 300 2018 programs do not work with programs from earlier versions.
-
The following programs are installed with Sage 300, and are required to use Sage 300:
- MSXML (Microsoft XML Core Services) 6.0
- Microsoft SQL Server Native Client 11.0
- Microsoft .NET Framework 4.6.2
- Sage 300 2018 includes SP16 for SAP Crystal Reports® runtime engine.
- For the most current technical information about database and report changes, and about parameters for customizing printed forms, see Sage 300 Database and Report Changes, Sage 300 Parameters for Customizing Printed Forms, or Sage Knowledgebase article 68834.
Note: The guides mentioned above are available online only, and are not included with the Sage 300 install.
- Product documentation for Sage 300 is available from the Sage 300 Product Documents website.
Compatibility with other programs
For a complete list of compatible programs, database platforms, and operating systems, see the Sage 300 2018 Compatibility Guide, available from Sage Knowledgebase article 26777.
Known issues
-
When using the Notes screen on the Sage 300 classic desktop:
- When adding or editing a note, the text editing area and toolbar appear only if you have enabled active scripting and scripting of Java applets in Internet Explorer security settings. For more information, see Knowledgebase article 76898.
- The Notes screen does not appear correctly if you use the Medium - 125% display size (specified in Windows control panel). For more information, see Knowledgebase article 76926.
- When previewing reports in web screens, information in some reports is not aligned correctly. To work around this issue, export the report to PDF format. For more information, see Knowledgebase article 76337.
- If you use the Web Deployment option, when signing in for the first time after upgrading to Sage 300 2018 from an earlier version, the Sage 300 Web Session Manager prompts you to install an earlier version of Sage 300 .NET Libraries instead of Sage 300 .NET Libraries 2018. For instructions on how to work around this issue, see Knowledgebase article 76601.
- Sage 300 uses components of Microsoft Internet Explorer to display help topics. If the Enhanced Security Configuration setting is turned on for your browser, you will receive an error message when you try to display certain help topics. To display help correctly for all topics and to prevent the error message, you must add the following site to the list of Trusted sites in Internet Explorer: about:security_A4WCONTAINERXP.EXE.
- If you are using Sage 300 on a workstation in a client-server environment, you could have trouble viewing help. For example, your browser might display the message "Page cannot be displayed." For a solution, see Sage Knowledgebase article 18477, or Microsoft support article 896054.
Installing Sage 300
For detailed instructions on installing Sage 300, see the Sage 300 Installation and Administration Guide.
Note: Version 2018 installs components that support the deployment of the Sage 300 Portal. The installation program installs Java Runtime Environment and Sage 300 Tomcat silently. (Tomcat is installed as a private instance in your Program Files folder under \Common Files\Sage\Sage 300 ERP\Tomcat.)
- To avoid possible data corruption issues, if you upgrade to a later version of Sage 300 or Sage 300cloud, you must install all released product updates for that version before activating your data.
If you use Sage 300cloud web screens, you must also:
- Activate data for all company databases that use the same system database before signing in to web screens.
- Run IISRESET as the Windows administrator user.
- Sage 300 Payroll 2018 (7.3A) is compatible with Sage 300 2018. However, it must be installed separately.
Installing product updates
After installing this product update:
- On any workstations you use, you must reinstall workstation setup as the Windows administrator user.
- If you use Sage 300cloud web screens, you must use Database Setup to configure the Portal database again.
- You should clear your browser’s cache. (Some fixes included in the update may not take effect until you do.)
- If you use Web Deployment:
- You may need to delete some downloaded files to ensure that this product update is installed correctly. For more information, see Knowledgebase article 34330.
- You must run the Web Deployment Configuration Wizard.
Removing Sage 300
Before removing Sage 300, you must:
- Close all instances of the Sage 300 Desktop.
- Close all applications that integrate with Sage 300.
- Stop all Sage 300 services that are running, such as Sage 300 .Net Remoting Service and Sage 300 Tomcat.
To remove Sage 300 2018 programs:
- In Windows' Control Panel, click Programs And Features.
-
Open Uninstall Or Change A Program, and then:
- To remove all Sage 300 programs, double-click Sage 300 2018.
-
To remove individual Sage 300 programs:
- Click Sage 300 2018, and then click Change. (Do not double-click Sage 300 2018.)
- Click Modify, and then use the Select Features screen to select the programs you want to install and clear the selections for programs you want to remove.
Canadian Payroll
Sage 300 2018 includes Canadian Payroll 2018; and the July 1, 2017 payroll tax update.
For more information, see the Sage 300 Canadian Payroll Release Notes.
Note: Canadian Payroll may not be available in all regions.
US Payroll
Sage 300 2018 includes US Payroll 2018; and the Q2 2017 payroll tax update.
For more information, see the Sage 300 US Payroll Release Notes.
Note: US Payroll may not be available in all regions.
Sage 300 Intelligence Reporting
Sage 300 2018 includes Sage 300 2018 Intelligence Reporting. For more information, see the Sage Intelligence Community.
Known issues
- If you have multiple versions of Microsoft Excel installed, you may need to manually load the Report Designer Task Pane Excel Add-in.
- If you use exclusions in account and row set rules, exclusion accounts may appear when you drill down to balance.
- If Sage 300 Intelligence Reporting was installed by a user other than you (for example, an administrator), you must open Microsoft Excel before running reports in Report Viewer or Report Manager.
- In Report Viewer, an "Open File - Security Warning" message appears for every report you view. (This message should only appear once, when you first open Report Viewer.)
-
If you use Microsoft Excel 2013, and you save a report template in Report Manager using Save Excel Template:
- When you run the report in Excel, an “External Data” message may appear. You can proceed by clicking Yes.
- If the report template has a timeline, the timeline does not retain its filters.
Sage Intelligence Reporting Cloud
Sage Intelligence Reporting Cloud is a financial reporting tool integrated with Sage 300cloud.
To use Sage Intelligence Reporting Cloud, users must be assigned to a security group with Financial Reporter security authorization for Sage 300 General Ledger and Sage 300 Web API security authorization for Sage 300 Common Services.
Also, for the ADMIN user you must customize two Sage 300 program files. For more information, see Sage Knowledgebase article 84722.
We recommend that you configure Sage 300cloud web screens to run in a secured environment using digital certificates. If you do not, warnings will appear in your browser each time you start Sage Intelligence Reporting Cloud. For more information, see Knowledgebase article 84797.