General Ledger I in Microsoft Dynamics Great Plains 9.0

Code: 8507
Course duration: 1 days
Price:

8507: General Ledger I in Microsoft Dynamics GP 9.0 (1 Day)

About this Course

The one-day Microsoft Dynamics GP General Ledger course explores the accounting cycle and the processes required to enter financial data into the system. This course also shows you how to perform additional functions such as account reconciliation, budgeting, allocation, period-end and year-end closing procedures.

A thorough understanding of these topics allows you to streamline monthly and year-end closing processes by learning how to automate routine activities such as account allocations, and reports. You learn how to accelerate data entry with transaction batch options while reducing data entry errors. This course also teaches 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 reporting options.

Audience Profile

Customers wanting to learn the basic features and to develop a working knowledge of the typical day-to-day procedures required to effectively use General Ledger.

The class is targeted toward data entry clerks, administrators, office managers, CEOs, and consultants who need to understand the technical aspects of Microsoft Dynamics GP General Ledger and gain foundational knowledge of the application functionality.

Prerequisites

Before attending this course, students must have:

  • General knowledge of Microsoft Windows
  • Basic knowledge of accounting principles

At Course Completion

After completing this course, students should be able to:

  • Customize General Ledger settings
  • Set up a chart of accounts including: posting, unit, and allocation accounts
  • Enter and post transactions using transaction or batch posting methods
  • Perform key inquiries and print reports in General Ledger
  • Complete period-end and year-end procedures-

Course Outline

Module 1: Overview


This chapter provides a general overview of the features and benefits of using the General Ledger module in an integrated environment. It also focuses on how this module integrates with other modules in the Microsoft Dynamics GP application.

Lessons

  • General Ledger Features and Benefits
  • General Ledger Overview and Roadmap
  • Integration

After completing this chapter, students will be able to:

  • Identify the features and benefits available when using General Ledger
  • Discuss integration that takes place between General Ledger and other modules within the application
  • Identify the navigation used to access the windows for transactions, reports, utilities, routines, and inquiries in General Ledger

Module 2: Setup Procedures


This chapter focuses on the setup procedures for the General Ledger module. We will examine the different types of posting accounts and budget calculation methods in detail. A section also focuses on Quick Journals which increase efficiency and accuracy for posting transactions that occur on a regular basis but have varying amounts posted to each account. General Ledger setup reports are also discussed briefly. Entering beginning balances and the options available for this are examined after all account types have been created.

Lessons

  • General Ledger Setup Checklist
  • Company and Posting Setup Procedures
  • General Ledger Setup
  • Account Categories
  • Posting Accounts Setup
  • Unit Accounts Setup
  • Fixed Allocation Account Setup
  • Variable Allocation Account Setup
  • Mass Modify Chart of Accounts
  • Account Segment Setup
  • Retained Earnings Account Setup
  • Setting up Budgets
  • Excel-based Budgeting
  • Budget Maintenance
  • Quick Journal Setup
  • Transaction Matching Setup
  • General Ledger Setup Reports
  • Entering Beginning Balances

Lab : Entering new Posting accounts

Lab : Entering a new Unit Accounts

Lab : Entering a new Fixed Allocation Account

Lab : Entering a new Variable Allocation Accounts

Lab : Mass Modify the Chart of Accounts

Lab : Account Segment Setup

Lab : Creating a Blank Budget in Microsoft Excel

Lab : Importing a Budget from Excel

Lab : Quick Journal Setup

After completing this chapter, students will be able to:

  • Customize settings for the General Ledger module
  • Enter their chart of accounts and budget information
  • Create Quick Journal entries to speed data entry and minimize errors
  • Enter Beginning Balances for their chart of accounts

Module 3: Daily Procedures


This chapter defines the ways that transactions can be entered and posted in General Ledger. You explore the difference between transaction level and batch level posting, and the methods for posting batches. The chapter demonstrates how to use clearing entries to transfer the balance of an account that is no longer being used to another account. In addition to these topics, the chapter covers linking transactions for analysis purposes using Transaction Matching and the ability to recover batches should there have been a power fluctuation or posting interruption.

Lessons

  • Transaction Entry Overview
  • Standard and Reversing Transactions
  • Batch Entry
  • Calculate Taxes in General Ledger
  • Post Transaction
  • Clearing Transactions
  • Quick Journal Entries
  • Linking Transactions
  • Batch Recovery

Lab : Enter a unit account transaction

Lab : Enter a recurring transaction

Lab : Enter a clearing entry

Lab : Enter a Quick Journal Entry for payroll

After completing this chapter, students will be able to:

  • Enter transactions involving posting, unit and allocation accounts
  • Modify their chart of accounts
  • Use Transaction Matching for analysis purposes
  • Print edit lists and post transactions

Module 4: Multidimensional Analysis


This chapter examines how to use analysis codes and analysis groups to allow for detailed inquiry and reporting capabilities without creating additional general ledger accounts. This chapter discusses how to record detailed data about your transactions and performed detailed analysis of the data after it is posted in the system.

Lessons

  • Setting up Analysis Groups and Codes
  • Assigning Analysis Groups to Accounts
  • Entering Transactions using Multidimensional Analysis
  • Performing Multidimensional Analysis Inquiries
  • Analysis Reports

Lab : Set up Analysis Groups

Lab : Set up Analysis Codes

Lab : Assign Analysis Codes to Posting Account

Lab : Enter and post Transactions using Analysis Codes

After completing this chapter, students will be able to:

  • Use the functionality available in Multidimensional Analysis
  • Set up Analysis Groups and Analysis Codes
  • Enter transactions using Analysis Codes
  • Retrieve analysis information from posted transactions

Module 5: Intercompany Transactions


This chapter shows how to record transactions in one company that creates transactions in another company's General Ledger. You examine the terms that are specific to Intercompany Processing and demonstrate the accounts that must be created to allow these types of transactions to be entered and posted.

Lessons

  • Intercompany Processing overview
  • Defining Intercompany relationships
  • Entering General Ledger Intercompany Transactions
  • Posting Intercompany Transactions in the Destination Company
  • Viewing the Intercompany Transactions in Inquiry

Lab : Granting Multicurrency Access

Lab : Setting up Intercompany Posting Accounts

Lab : Granting Company Access to a Specific Currency

Lab : Entering Intercompany Setup Information

Lab : Entering and Posting an Intercompany Transaction

After completing this chapter, students will be able to:

  • Set up Intercompany relationships
  • Enter intercompany transactions in the origination company
  • Post intercompany transactions in the destination company
  • Trace intercompany transaction back to the originating entry

Module 6: Organizational Structures


This chapter focuses on defining the components of your organization and the relationships between them. Once defined, users and accounts can be assigned to the various parts of the organization. If Account Level Security is activated in this company, users can use only those accounts to which they have been given access, based on their position in the organization.

Lessons

  • Organization Structures Overview
  • Defining Components of the Organization
  • Define Organizational Relationships
  • Assign User Classes to the Organizational Structure
  • Assign Users to the Organizational Structure
  • Assign a Range of Accounts to the Organizational Structure
  • Assign an Individual Account to the Organizational Structure
  • Activate Account Security

Lab : Define the Organizational Structure of an Organization

Lab : Define the Relationship Between each of the Structure Components

Lab : Grant Access to the Organizational Structure Assignment Window

Lab : Assign Users to a Specific Company and Division

Lab : Assign Account-level Security to the Organizational Structure

Lab : Verify Security has Been Activated

After completing this chapter, students will be able to:

  • Define discrete business entities
  • Define relationships between multiple business entities
  • Define account security levels based on their organizational structure

Module 7: Maintaining Records


This chapter examines the functionality available to maintain your General Ledger records. There is also a section that focuses on correcting posted entries as well as changing and deleting records. Retrieving information is also a big focus of this chapter. Account Rollup Inquiry and Transaction Matching setup and analysis capabilities are discussed in this chapter. Time is also spent discussing the inquiry windows and reports that can be generated from the General Ledger module.

Lessons

  • Correcting a Posted Transaction
  • Change and Delete Account Records
  • Remove History
  • Archive Matched Transactions
  • Reconcile
  • Retrieve Information
  • Creating Report Options
  • Creating and Printing Report Groups

After completing this chapter, students will be able to:

  • Correct posted entries
  • Change and delete records
  • Use inquiries to retrieve information
  • Use Transaction Matching
  • Use Account Rollup Inquiries
  • Set up report options and report groups for reporting purposes

Module 8: Period-End Procedures


This chapter examines the process of closing an accounting period and the fiscal year. The steps necessary to complete each phase of the closing process are discussed for the end of a period as well as a fiscal year. You look at the reports and financial statements that should be printed before performing the closing process. Time is spent examining what actually takes place during the closing process and the two approaches that an organization may use for this process.

Lessons

  • Period-end Checklist
  • Printing Financial Statements and Reports
  • Consolidating a Period
  • Closing the Fiscal Period
  • Year-end Closing Checklist
  • Year-end Closing

After completing this chapter, students will be able to:

  • Complete the processes that are performed at the end of an accounting period
  • Consolidate periods and be aware of the effects of performing the consolidation process
  • Complete the processes that performed at the end of a fiscal year
  • Perform the Year-end closing process

Module 9: Financial Statement Formatting


This chapter shows the financial statements you can print using Quick Financial statements. Time is spent defining the type of financial statement to be printed and the formatting and printing options that are available for these reports. An overview of Advanced Financial Analysis and using the Accelerator File is presented.

Lessons

  • Types of Quick Financial Statements
  • Defining the layout
  • Printing Options for Quick Financial statements
  • Advanced Financial Analysis Overview
  • Using the Accelerator File
  • AFA Printing Features

Lab : Create a Quick Financial Report

Lab : Create a report option for the Quick Financial Report

Lab : Print a Quick Financial Report

After completing this chapter, students will be able to:

  • Create Quick Financial statements
  • Print Quick Financial statements
  • Format financial statements
  • Use Advanced Financial Analysis to modify financial statements

Module 10: Appendix A: SmartList


This appendix discusses the use of SmartList to access financial data. There are also optional exercises that can be completed by students if time permits.

Lessons

  • Using SmartLists
  • Creating Objects
  • Using the Search Button
  • Saving New Objects as Favorites

Lab : Create a SmartList Inquiry

Lab : Save Query as a Favorite

Lab : Create a SmartList Inquiry for Account Transactions

Lab : Create a SmartList Inquiry for Account Summaries

Lab : Create a SmartList Inquiry for Multidimensional Analyses

After completing this chapter, students will be able to:

  • Use SmartLists to access valuable financial 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 11: Appendix B: Test Your Knowledge


This appendix presents questions on various topics in General Ledger. It is a good review tool to test what you have learned.

Lessons

  • Test Your Knowledge Questions
  • Quiz

After completing this chapter, students will be able to:

  • Gauge how much they have learned about General Ledger
  • Identify areas that need to be reviewed

Module 12: Appendix C: Case Study


This case study is a comprehensive lab that can be used to reinforce the learning that has occurred throughout the General Ledger class.

Lessons

  • Posting Setup
  • General Ledger Setup
  • Source Document Setup
  • Creating Accounts
  • Creating Quick Journals & Budgets
  • Entering Transactions
  • Performing Inquiries
  • Printing Trial Balance Report

After completing this chapter, students will be able to:

  • Understand the necessary processes to set up and manage their General Ledger
  • Have more confidence in their ability to use General Ledger in their company

Module 13: Appendix D: Answers


This section includes the answers to all the labs that appear through out the manual as well as the case study.

Course Reviews

No reviews found for this course.

Be the first to write a review