|
Sage 300 CRE
Timberline Office
Connector
Sage 300 Construction and Real Estate (formerly Sage Timberline Office)
Office
Connector is a series of applications that automatically connects your
Sage 300
Construction and Real Estate data to Excel. This solution can save you
hours of time on reporting and analysis tasks using Excel. Best of all,
Office Connector is easy to learn and use and comes with a number of
prebuilt queries, getting you up and running immediately.
The Office Connector series consists of three separate products that
allow you to query, report, and move data back and forth between
Microsoft Excel and Sage 300:
- Sage 300 Office Connector Query—Automatically retrieves data from Sage
300 for
analysis and data manipulation using familiar Excel reports, worksheets,
graphs, and more.
- Sage 300 Office Connector Write—Maps data from your Excel worksheets and
forms to corresponding writable fields within Sage 300.
- Sage 300 Office Connector Import—Quickly saves Excel worksheets in
formats that can be imported into Sage 300.
- Sage 300 Office Connector Financials—Use your Sage 300 financial data in
Excel to create robust financial reports leveraging all of Excel’s
features, including: formatting for high-quality presentation, graphing
and charting, pivot tables, and more.
These innovative solutions will transform the way you work with your
Sage 300 Construction and Real Estate data, expanding your analysis and
reporting options through a familiar set of tools.
View your Sage 300 Construction and Real Estate data the way you want to
see it—through a live connection to Microsoft Excel. Take advantage of
Excel’s graphic,
formatting, and flexible placement of workbook functions to visualize
your information like never before.
•Seamlessly access your Sage 300 data from Excel.
•Embed dynamic queries that retrieve data from your Sage 300 database
and place it into your Excel workbooks.
•Refresh data at any time with the click of a button.
Sage 300 Construction and Real Estate
Benefits
• Transfer Sage 300 Construction and Real Estate data to/from Excel with
ease.
• Take advantage of Excel’s flexibility and familiarity.
• Reduce the time your company spends on data entry.
• Improve workflow and reporting.
• Empower employees to use Excel as a reporting and productivity tool.
• Gain added confidence in your numbers and data.
Office Connector Write
Send your Excel data directly to Sage 300 Construction and Real Estate.
Wizards make it easy to determine which fields can be created or
modified. The Approve Changes window puts you in complete control of
what is written.
•Instruct Sage 300 Office Connector to map values from your Excel
worksheets to the proper fields and records in your Sage 300 database.
•Preview information to be written before anything happens to ensure
data security and
integrity.
Office Connector Import
Get the capability you need to automatically create Excel files that are
compatible with various import functions in your Sage 300 Construction
and Real Estate database. Create import files from spreadsheets with the
click of a button—without the need to
recreate or reformat the information.
•Import Excel files into Sage 300 without modifying or adapting the
layout of your worksheets.
•Create a seamless import process with the click of a button.Prevent
lost time you’d normally spend recreating properly formatted import
files.
|
