|
---|
Play Video
|
Duration: 11 minutes
In this video, we'll cover how to use couple Excel's Data Validation feature with Sage 300 Construction and Real Estate data provided by Office Connector. Although the example is GL focused, the concepts covered in this training video can be applied to many different scenarios.
|
|
Play Video
|
Duration: 2 minutes
Learn how to use tools in Office Connector Query Designer to get a list of internal field names that can be used in Office Connector Query worksheet functions.
|
|
Play Video
|
Duration: 2.5 minutes
When utilizing the queries that are created using the Query Wizard, it is common to add other columns that contain formulas. This video discusses how to do this correctly so that formulas are automatically copied down to new rows when the data in the query is refreshed.
|
|
Play Video |
Duration: 10.5 minutes
Watch and learn how to create the vendor list report based on Exercise 1 of Office Connector Query Getting Started. Click here for the step-by-step instructions and try it yourself! |
|
Play Video
|
Duration: 1.5 minutes
This video shows how you can use Office Connector's Lookup Wizard to insert TSLookup functions into your worksheet. TSLookup functions allow you to retrieve data from any field in any table by using the primary key (identifier such as an account number) to locate the record you want.
|
|
Play Video
|
Duration: 6 minutes
In this video, we'll cover how to apply drill-down capability to reports using the OCDrillDown function that is part of Office Connector Query.
|
|
Play Video
|
Duration: 3.5 minutes
When designing a report that includes a query, you may sometimes wish to have data-entry columns. This video addresses how to use the OCRetain function to keep your manually input values on the correct rows when the query inserts rows for new data.
|
|
|
Play Video
|
Duration: 15 minutes
This video provides a basic introduction to the Office Connector Query software. It includes instructions on opening the software, available self-help resources, data security, and running reports provided with Office Connector Query for Sage 300 Construction and Real Estate.
|
|
Play Video
|
Duration: 3.5 minutes
Learn how to use the Query Wizard to create a simple report showing Job Cost transactions for any job you choose. In the process, you'll also learn about named cells in Excel and how to add multiple conditions in the Query Wizard.
|
|