OAS Lunch & Learn Video Library
Click the thumbnails below to view or download each video.
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.
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.
Dashboards
Janice Barton presented on Unanet dashboards, covering their purpose, setup, permissions, and how they support project management, along with configuration and customization options.
