3305 Main Street Ste 019 Vancouver, WA 98663

Write

STO_InstallBannerMockup15

Office Connector

Write


Attend Webinar

10-Day Evaluation

Buy Now

Download

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.

Example Applications

Owners of Office Connector Write use it to…

  • Create and Maintain Vendor Records
  • Update Contact Information
  • Spell-Check and Correct Data
  • Create and Maintain Employee Records
  • Update Misc Worksheet Amounts
  • Correct Data Entry Errors
  • Create and Maintain Customer Records
  • Update Notes and File Attachments
  • Maintain Custom Field Values
  • Create and Maintain Job Records
  • Update Pay Rates
  • Create and Update Budgets

Features

Feature Description
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.
Read more...
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.

Licensing

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

Supported Platforms

  Click here for information about supported operating systems, versions of Excel, and versions of Sage 300 Construction and Real Estate.