OAS Lunch & Learn Video Library

Click the thumbnails below to view or download each video.

Tim Cowher Tim Cowher

Syncing Data with Excel from Custom API Endpoints

John McPherson of ResultSet presented a session focused on extracting and manipulating data from Unanet AE into Excel using API endpoints. He walked through setting up API calls and authentication, demonstrated configuring and testing API calls in Excel using Power Query, and reviewed data transformation and refresh capabilities.

Read More
Tim Cowher Tim Cowher

Year End Process

Tammy Kilhullen presented on year-end processes, sharing a checklist and a custom report to identify prior fiscal years not closed. She also reviewed cash basis accounting, overhead allocation, revenue generation, and applying ICC to projects.

Read More
Tim Cowher Tim Cowher

Queries

Courtney Drews presented on the topic of Queries. This session covers the process of building and using queries. Courtney demonstrated various aspects of query building, including filtering, sorting, and using the data dictionary.

Read More
Tim Cowher Tim Cowher

Dashboards

Janice Barton presented on Unanet dashboards, covering their purpose, setup, permissions, and how they support project management, along with configuration and customization options.

Read More