Sage 300 Construction and Real Estate allows selected types of records and selected fields to be updated externally. Office Connector Write puts this technology in your hands so that you can use Microsoft Excel to help you manage your Sage 300 Construction and Real Estate data. With a designer license, you have the tools to build your own write-enabled solutions using the built-in wizards that guide you step-by-step. Whether you build your own solution, use one of our existing solutions, or have a solution built for you, you are in control of what is written. Before any data is written, you can preview the information and then after data is written, you have a complete audit trail! Recap reports listing the details of what was written are generated every time you write data to Sage 300 Construction and Real Estate.
Owners of Office Connector Write use it to…
|Easy Connection||To access your Sage 300 Construction and Real Estate data there is no need for you to create data sources or build SQL queries. Simply select your data folder from the list, supply your Sage 300 Construction and Real Estate operator ID and password and you’re ready to begin working with your Sage 300 Construction and Real Estate data in Excel.|
|Sample Solutions||A set of over 10 report designs is included for you to use or to serve as starting points and educational resources.
|Security||Using Office Connector Administrator, you can decide which of your Sage 300 Construction and Real Estate operator IDs should have access to Office Connector Write. This easy to use tool was designed to complement and enhance your existing Sage 300 Construction and Real Estate security. If you have permission to write to your Sage 300 Construction and Real Estate database, you can ensure data integrity by approving specific write functions in the Approval Window.|
|Wizard Driven||With a designer license, wizards guide you through the steps to create Excel formulas containing Office Connector functions. As you progress through the wizard, Office Connector Write will identify the fields that can be written via the Sage 300 Construction and Real Estate ODBC driver.|
|Powerful Worksheet Function||Office Connector Write adds the TSWRITE function to your workbooks. Cells containing this function serve as instructions that map your Excel data to their intended target fields within Sage 300 Construction and Real Estate.|
|Online Help||All Office Connector functions and tools are fully documented in online help that is quickly accessible from within Excel.|
Office Connector Write is licensed by the number of users who will need to use it concurrently. Two types of licenses are offered which determine the features that are available to you. Any number of licenses of each type can be purchased.
|Feature||Standard License||Designer License|
|Send Data to Sage 300 Construction and Real Estate|
|Use Write Wizard to Create new Write Instructions||
Click here for information about supported operating systems, versions of Excel, and versions of Sage 300 Construction and Real Estate.