THE OFFICE CONNECTOR SUITE
The Office Connector Suite consists of three (3) separately licensed products that will automatically connect to your Sage 300 Construction and Real Estate database. The Office Connector Suite allows you to use Microsoft Excel® to transform how you work with your Sage 300 Construction and Real Estate data. The three (3) separately licensed products are:
- Office Connector Query - Design and run reports as well as refresh your report data at anytime. NOTE - there are two (2) types of licenses available for purchase:
- An extension to Office Connector Query - Office Connector Financials delivers a set of functions for use in Excel that you can use to pull various types of financial values from Sage 300 Construction and Real Estate General Ledger. With your financial data in Excel, you’re empowered to create robust financial reports leveraging all of Excel’s features, including: formatting for high-quality presentation, graphing and charting, pivot tables, and more.
NOTE - Office Connector Financials is a site-level extension to all of your Office Connector Query licenses. In other words, you can acquire Office Connector Financials for a flat price regardless of the number of users or licenses of Office Connector Query. The financial functions are then enabled for all of your Office Connector Query Designer or Office Connector Query Standard licenses.
- Office Connector Write - Create new records as well as update existing records in Sage 300 Construction and Real Estate based on the data in your Excel worksheets. Office Connector Write allows you to use Microsoft Excel® to manage your Sage 300 Construction and Real Estate data. NOTE - there are two (2) types of licenses available for purchase:
- Office Connector Import - Create files to be imported into Sage 300 Construction and Real Estate in order to create transactions. With the Office Connector add-in for Excel, you can properly format and organize your data however you wish and then Office Connector Import collects that data and assembles it into your desired import files. NOTE - licensing is 'feature' based and depends on the type of import file you plan to create.