Microsoft Dynamics GP Project Accounting | Microsoft Training, MS Dynamics NAV, CRM, GP, AX, Business Central

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 Profile

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.

Prerequisites

Before attending this course, students must have:

General knowledge of Windows
Working knowledge of Microsoft Dynamics GP
Basic knowledge of accounting principles

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.

Course Outline

Module 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.

Lessons

Project Series Features and Benefits
Project Series Overview and Roadmap
Integration
Holistic View of Project Series Suite

After completing this chapter, students will 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

Module 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.

Lessons

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 will 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.

Module 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.

Lessons

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 will 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.

Module 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.

Lessons

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

Process Cycle Biller.

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 will 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.

Module 5: Maintaining Records

This section covers administrative topics in Project Series. The chapter also discusses topics related to repairing data.

Lessons

Voiding Posted Transactions (Receivables Management)
Data Recovery and Maintenance
Mass Contract Delete
Initialize Smartlist
PA Reconcile

After completing this chapter, students will be able to:

Properly void an RM invoice as it relates to Project Series.
Reconcile PA data.
Use PA utilities.

Module 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.

Lessons

Inquiries
Reports Options
Printing of Reports and Accessing Information

After completing this chapter, students will be able to:

Use any of the inquiry windows in Project Series.
Create a Reports option.

Module 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.

Lessons

Period-end Checklist
Aging Process
Aging WIP Process
Paid Sales Transaction Removal
Remove Completed Purchase Orders
Close Fiscal Period

After completing this chapter, students will 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.

Module 8: Appendix: 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.

Lessons

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 chapter, students will 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.

Module 9: Appendix: 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.

Lessons

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 chapter, students will 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

Module 10: Appendix: 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.

Lessons

Solutions

After completing this chapter, students will be able to:

Complete any of the labs or case studies in the workbook.

Module 11: Appendix: Posting Flow

This appendix contains general ledger debit and credit posting accounts for nearly every transaction type in Project Series.

Lessons

Posting Flow for Project Accounting Transactions

After completing this chapter, students will be able to:

Know which accounting will be posted to when transactions are entered in Project Series.

Module 12: Appendix: Reference

This appendix contains reference material to improve your experience with Project Series.

Lessons

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 chapter, students will be able to:

Implement Project Series.

Course Reviews

No reviews found for this course.

Be the first to write a review