Microsoft Dynamics GP Project Accounting

Code: 8516
Course duration: 3 days

8516: Project Series in Microsoft Dynamics GP 9.0 (3 Days)

About this Course

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.

Guaranteed to Run

2018-03-07 09:00 to 2018-03-09 17:00
Fort Lauderdale, Florida (Virtual Instructor-Led)
2017-12-11 09:00 to 2017-12-15 17:00
Attend Online
2017-12-04 09:00 to 2017-12-08 17:00
Attend Online
2017-12-04 09:00 to 2017-12-08 17:00
Attend Online
2017-11-27 09:00 to 2017-12-01 17:00
Attend Online

Course Reviews

No reviews found for this course.

Be the first to write a review