Microsoft Dynamics GP Project Series
Course 8516: Three days;
Instructor-Led
Course Fee:
$1497.00
Course Time: 3 days, 9:30 am - 4:30 pm, or 6 evenings, 6pm - 9pm
Introduction
The three-day Microsoft Dynamics GP Project Series
course explores project management from an accounting
perspective. This course teaches you how to create
contracts, projects, and cost categories, and you
receive information about how to budget. You also learn
how to enter costs for projects and perform time and
materials billing and progress billing. During this
class, we discuss nearly every feature in the Project
Series module.
This course will also teach you how to define default
values that automatically populate data fields and
gather the information you need to make better business
decisions by exploring powerful inquiry and lookup
functions.
Audience
Microsoft Dynamics GP Project Series training is
recommended for anyone who plans to implement, use,
maintain, consult, or support Microsoft Dynamics GP. The
class is targeted toward data entry clerks,
administrators, office managers, CEOs, and consultants
who need to understand the technical aspects of Project
Series and gain foundational knowledge of the
application functionality.
At course completion
After completing this course, students should be able
to:
| • |
Perform all Project Series-related data entry
functions, including customer invoicing and cost
transactions (including timesheets and employee
expenses).
|
| • |
Perform maintenance on Project Series
documents and maintenance records, such as
customers, employees, and vendors.
|
| • |
Configure contracts, projects, and cost
categories.
|
| • |
Set up and configure billing cycles to
facilitate automated billing.
|
| • |
Create and assign rate tables to manage cost
and billing rates.
|
| • |
Create and use contract and project
templates.
|
| • |
Use reports and inquiry windows in Project
Series to extract whatever project-related
information is applicable to your business.
|
Prerequisites
Before attending this course, students must have:
| • |
General knowledge of Windows
|
| • |
Working knowledge of Microsoft Dynamics GP
|
| • |
Basic knowledge of accounting principles
|
Microsoft Certification exams
No Microsoft Certification exams are associated with
this course currently.
Course materials
The student kit includes a comprehensive workbook and
other necessary materials for the class.
Course outline
Chapter 1: Introduction
The purpose of this chapter is to give students a
general overview of the features and benefits of using
the Project Series module in an integrated environment.
It also focuses on the integration of this module with
other modules in the Microsoft Dynamics GP application.
In addition, the chapter presents a holistic view of the
Project Series suite.
Main Topics
| • |
Project Series Features and Benefits
|
| • |
Project Series Overview and Roadmap
|
| • |
Integration
|
| • |
Holistic View of Project Series Suite
|
After completing this chapter, students should be
able to:
| • |
Identify the features and benefits available
when using Project Series
|
| • |
Discuss integration that takes place between
Project Series and other modules within the
Microsoft Dynamics GP system
|
| • |
Identify the navigation used to access the
windows for transactions, reports, utilities,
routines, and inquiries in Project Series
|
Chapter 2: Setup
This chapter focuses on the procedures for setting up
Project Series. We examine in detail the options
available to set up this module to reflect the way your
organization does business. Time is spent discussing the
benefits of using different setup options. You must set
up users, default account sources, each cost transaction
type, and billing. Once your Project Series setup has
been completed, you can start to use the Project Series
module.
Main Topics
| • |
Project User Setup
|
| • |
Project Series Setup
|
| • |
Timesheet, Equipment, Miscellaneous,
Inventory Transfer, Employee Expense, Purchase
Order, Purchasing Invoice Setup
|
| • |
Billing Setup
|
| • |
Billing Notes and Reports
|
Lab: User Class and User Setup
| • |
Create a user class for use in Project
Series.
|
| • |
Create a user by using the user class.
|
Lab: Project Setup
| • |
Setup the Project Series module.
|
Lab: Timesheet, Equipment, Miscellaneous,
Inventory Transfer, Employee Expense, Purchase Order,
and Purchasing Invoice Setup
| • |
Set up the Transaction Setup window for each
of the cost transaction types.
|
Lab: Billing Setup
| • |
Set up the billing functionality for Project
Series.
|
| • |
Create a miscellaneous ID.
|
After completing this chapter, students should be
able to:
| • |
Set up the Project Series module.
|
| • |
Configure Setup windows for Timesheet,
Equipment, Miscellaneous, Inventory Transfer,
Employee Expense, Purchase Order, and Purchasing
Invoice transaction types.
|
| • |
Configure the Billing Setup window.
|
Chapter 3: Configuration
This chapter focuses on the procedures for
configuring Project Series. You must examine in detail
the options available to customize this module to
reflect the way your organization does business. Time is
spent discussing the benefits of using different project
types and accounting methods. You create contracts,
projects, and cost categories to track the information
crucial to your company. After your Project Series set
up has been defined, there are many reports available to
document the selected preferences.
Main Topics
| • |
PA Customer, Employee, and Vendor Options
|
| • |
Equipment ID and Miscellaneous ID Setup
|
| • |
Project Series Setup and Options
|
| • |
Cost Category Maintenance
|
| • |
Rate Tables
|
| • |
Billing Cycle Maintenance
|
| • |
Fees
|
| • |
Contracts and Projects
|
| • |
Project Types and Accounting Methods
|
| • |
Third Party Billing
|
| • |
Change Order Maintenance
|
| • |
Budgeting
|
| • |
Templates
|
Lab: Customer Class Setup
| • |
Create a customer class for use in Project
Series.
|
Lab: Employee Maintenance
| • |
Add Project Series information to the PA
Employee Options window.
|
Lab: Equipment Class Setup and Equipment
Maintenance
| • |
Create an equipment class.
|
| • |
Create an equipment ID.
|
Lab: Miscellaneous Class Setup and Miscellaneous
Maintenance
| • |
Modify an existing customer class.
|
| • |
Create a miscellaneous ID.
|
Lab: Cost Category Class Setup & Cost Category
Maintenance
| • |
Add a new cost category class.
|
| • |
Create a new cost category ID.
|
| • |
Modify existing cost categories.
|
Lab: Position, Employee and Equipment Rate Tables
| • |
Create a new rate table for each type.
|
Lab: Billing Cycle Maintenance
| • |
Create two new billing cycle IDs.
|
Lab: Fee Maintenance
| • |
Create a new fee ID for each of the four fee
types.
|
Lab: Contract Maintenance
| • |
Create and configure a new contract.
|
Lab: Project Maintenance
| • |
Create and configure three new projects, one
for each project type.
|
Lab: Template Maintenance and Copying Templates
| • |
Create and configure a new template for a
contract and project.
|
| • |
Copy the template settings to a new contract.
|
After completing this chapter, students should be
able to:
| • |
Maintain employee, customer, and vendor
records for Project Series.
|
| • |
Set up cost categories.
|
| • |
Create contracts, projects, fees, and budget.
|
| • |
Create a rate table.
|
| • |
Create a billing cycle.
|
| • |
Create and use templates for projects and
contracts.
|
Chapter 4: Daily Procedures
The purpose of this chapter is to define the ways
that transactions can be entered and posted in Project
Series. You explore the difference types of Project
Series transactions. In addition you must demonstrate
posting implications for other Microsoft Dynamics GP
modules from Project Series and learn the differences
between standard and references transactions. Entering
timesheets, employee expenses, equipment logs,
miscellaneous logs, purchasing, inventory, and billing
transactions is covered in this chapter.
Main Topics
| • |
Transaction Entry Overview
|
| • |
Posting Overview
|
| • |
Timesheet Entry
|
| • |
Employee Expense Entry
|
| • |
Equipment and Miscellaneous Log Entry
|
| • |
Purchase Orders and Receiving Transactions
|
| • |
Inventory Transfer Entry
|
| • |
Billing Invoices
|
| • |
Billing Cycle Processing
|
| • |
Progress Billing
|
| • |
Revenue Recognition Transactions
|
Lab: Timesheet Transactions
| • |
Enter and post a timesheet.
|
Lab: Employee Expense Transactions
| • |
Enter and post an employee expense.
|
Lab: Equipment Log Transactions
| • |
Enter and post an equipment log.
|
Lab: Miscellaneous Log Transactions
| • |
Enter and post a miscellaneous log.
|
Lab: Purchase Orders
| • |
Enter a purchase order.
|
Lab: Receiving Transactions
| • |
Enter and post a receiving transaction that
matches to the previous lab.
|
Lab: Purchasing Invoice Transactions
| • |
Enter and post a purchasing invoice
transaction that matches to the previous lab.
|
Lab: Inventory Transfer Transactions
| • |
Enter and post an inventory transfer
transaction.
|
Lab: Billing Cycle
Lab: Cash Receipt
| • |
Enter a cash receipt.
|
| • |
Apply the receipt to a Project Series
invoice.
|
Lab: Revenue Recognition
| • |
Enter and post a revenue recognition
transaction.
|
| • |
Apply the receipt to a Project Series
invoice.
|
After completing this chapter, students should be
able to:
| • |
Enter the different types of transactions in
Project Series.
|
| • |
Create and post a billing invoice.
|
| • |
Use Cycle Biller to create invoices.
|
| • |
Enter a revenue recognition transaction.
|
Chapter 5: Maintaining Records
This section covers administrative topics in Project
Series. The chapter also discusses topics related to
repairing data.
Main Topics
| • |
Voiding Posted Transactions (Receivables
Management)
|
| • |
Data Recovery and Maintenance
|
| • |
Mass Contract Delete
|
| • |
Initialize Smartlist
|
| • |
PA Reconcile
|
After completing this chapter, students should be
able to:
| • |
Properly void an RM invoice as it relates to
Project Series.
|
| • |
Reconcile PA data.
|
| • |
Use PA utilities.
|
Chapter 6: Inquiries and Reports
This chapter examines the functionality available to
inquire about your Project Series data. This chapter
examines the functionality available to report on your
Project Series records. Basically, this chapter includes
details about every report available in Project Series.
Main Topics
| • |
Inquiries
|
| • |
Reports Options
|
| • |
Printing of Reports and Accessing Information
|
After completing this chapter, students should be
able to:
| • |
Use any of the inquiry windows in Project
Series.
|
| • |
Create a Reports option.
|
Chapter 7: Period-End Procedures
This chapter examines the processes that are
completed at the end of the month, period, calendar, and
fiscal year. This chapter focuses on the errors that may
cause Project Series to be out of balance with the
general ledger.
You look at the reports that should be printed prior
to performing the closing process. Time is spent
examining what actually takes place during the closing
process and the two types of closings: calendar year and
fiscal year.
Main Topics
| • |
Period-end Checklist
|
| • |
Aging Process
|
| • |
Aging WIP Process
|
| • |
Paid Sales Transaction Removal
|
| • |
Remove Completed Purchase Orders
|
| • |
Close Fiscal Period
|
After completing this chapter, students should be
able to:
| • |
Complete the processes that should be
performed at the end of the period.
|
| • |
Complete the processes that may be performed
at the end of a calendar or fiscal year.
|
Appendix A: SmartList
This appendix discusses the use of SmartList to
access Project Series data. There are also optional
exercises that can be completed by students if there is
time in class.
Main Topics
| • |
Using SmartLists
|
| • |
Creating Objects
|
| • |
Using the Search Button
|
| • |
Saving New Objects as Favorites
|
Lab: PA Projects
| • |
Create a SmartList inquiry.
|
| • |
Export the results to Microsoft Word.
|
Lab: PA Timesheet Historical Trx
| • |
Create a SmartList inquiry.
|
| • |
Export the results to Microsoft Word.
|
After completing this appendix, students should be
able to:
| • |
Use SmartLists to access valuable Project
Series data.
|
| • |
Create new SmartList objects.
|
| • |
Use the Search button to manage the
information in a view.
|
| • |
Explain the various options that are
available when using SmartLists.
|
Appendix B: Case Study
This case study is a comprehensive lab that can be
used to reinforce the learning that has occurred
throughout the Project Series class. The case study is
generally completed by students on their own after
class.
Main Topics
| • |
Project User Setup
|
| • |
Transaction Setup
|
| • |
Employee Setup
|
| • |
Cost Category Setup
|
| • |
Templates
|
| • |
Contract and Project Configuration
|
| • |
Cost Transaction Entry
|
| • |
Billing Invoice Entry
|
| • |
Fee Assignments
|
| • |
Revenue Recognition
|
| • |
Reporting
|
After completing this appendix, students should be
able to:
| • |
Understand the necessary processes to set up
and manage their Project Series module
|
| • |
Have more confidence in their ability to use
Project Series in their company
|
Appendix C: Answers
This appendix contains the solutions to all the labs
contained in the workbook. It also contains solutions
for the case study in appendix B.
Main Topics
After completing this appendix, students should be
able to:
| • |
Complete any of the labs or case studies in
the workbook.
|
Appendix D: Posting Flow
This appendix contains general ledger debit and
credit posting accounts for nearly every transaction
type in Project Series.
Main Topics
| • |
Posting Flow for Project Accounting
Transactions
|
After completing this appendix, students should be
able to:
| • |
Know which accounting will be posted to when
transactions are entered in Project Series.
|
Appendix E: Reference
This appendix contains reference material to improve
your experience with Project Series.
Main Topics
| • |
Implementation Guide
|
| • |
List of Types of Project Management Tools
|
| • |
List of Billing Invoice Reports and Their
Reports Writer Equivalent Names
|
| • |
List of Billing Invoice Reports and a
Description of What Is Included on the Report
|
| • |
Glossary of Terms
|
After completing this appendix, students should be
able to:
| • |
Implement Project Series.
|
|
