OAS Lunch & Learn Video Library

Click the Thumbnails Below to View or Download Each Video

Enter Key Words to Search the Video Library (Ex. Customizations, Project Planning, Budgeting, Reporting):

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

Credit Card Reconciliation

Jessica Gandy presented a session on credit card expense management, demonstrating a new import tool that streamlines transaction entry through a dashboard interface. She also reviewed the credit card reconciliation workflow, including expense reporting methods and matching transactions to purchase journals.

Read More
Tim Cowher Tim Cowher

Expense Codes & Expense Groups

Martha Griffith presented a session on Expense Codes and Expense Groups, explaining how expense codes categorize non-labor expenses and support unit billing. She reviewed expense group setup, including markup rates, GL mapping, and project-level overrides, shared practical tips on dates and recalculating markups, and addressed common unit billing challenges.

Read More
Tim Cowher Tim Cowher

Project Planning Part 4: Additional Tips

Tammy Kilhullen presented on project planning and template management in Unanet, demonstrating project templates, rate increases across fiscal years, and timeline adjustments using the Gantt chart. She also covered resource groups, budget calculations, permission settings, and addressed questions around moving time entries and billing issues.

Read More
Tim Cowher Tim Cowher

Project Planning Part 3: Web Version

Martha Griffith presented on project planning in the web version of the system, demonstrating budgeting, resource scheduling, and Gantt chart features, and concluded with a discussion on web versus desktop advantages and a Q&A on workflow, customization, and reporting.

Read More
Tim Cowher Tim Cowher

Project Planning Part 2: Resource Allocation & Scheduling

Tammy Kilhullen led a session on resource planning and scheduling in Unanet, covering Resource Groups, the Project Plan Report, the Resource Scheduler, and the Labor Schedule Summary Dashboard. The session also reviewed planned versus actual hours and included a practical Q&A.

Read More
Tim Cowher Tim Cowher

Project Planning Part 1: Budgeting & Allocation

Martha Griffith led a session on Project Planning, focusing on budgeting and allocation. Topics included managing different project cost types, using a test database, creating variance columns, budgeting in ODC, ICC, and OCC modes, allocation and timesheet workflows, project notifications, and building Gantt charts in both the desktop and web versions of Unanet.

Read More
Tim Cowher Tim Cowher

Labor Distribution

Courtney Mahon reviewed labor distribution in Unanet, emphasizing accurate labor mapping, timely timesheet submission, and approval. She also addressed common timesheet and utilization challenges and clarified intercompany transactions.

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