Course 8507A:

General Ledger I in Microsoft Dynamics GP 9.0

Length:1 Days
Published:December 21, 2005
Language(s):English
Audience(s):Information Workers
Level:200
Technology:Microsoft Dynamics GP 9.0
Type:Course
Delivery Method:Instructor-led (classroom)
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.
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 OutlineModule 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 accountsLab : Entering a new Unit AccountsLab : Entering a new Fixed Allocation AccountLab : Entering a new Variable Allocation AccountsLab : Mass Modify the Chart of AccountsLab : Account Segment SetupLab : Creating a Blank Budget in Microsoft( Excel(Lab : Importing a Budget from ExcelLab : 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 transactionLab : Enter a recurring transactionLab : Enter a clearing entryLab : 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 GroupsLab : Set up Analysis CodesLab : Assign Analysis Codes to Posting AccountLab : 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 AccessLab : Setting up Intercompany Posting AccountsLab : Granting Company Access to a Specific CurrencyLab : Entering Intercompany Setup InformationLab : 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 OrganizationLab : Define the Relationship Between each of the Structure ComponentsLab : Grant Access to the Organizational Structure Assignment WindowLab : Assign Users to a Specific Company and DivisionLab : Assign Account-level Security to the Organizational StructureLab : 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 ReportLab : Create a report option for the Quick Financial ReportLab : 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 InquiryLab : Save Query as a FavoriteLab : Create a SmartList Inquiry for Account TransactionsLab : Create a SmartList Inquiry for Account SummariesLab : 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.
Before attending this course, students must have:
  • General knowledge of Microsoft Windows
  • Basic knowledge of accounting principles
Have Questions? For advice about training and certification, connect with peers: For questions about a specific certification, chat with a Microsoft Certified Professional (MCP): To find out about recommended blogs, Web sites, and upcoming Live Meetings on popular topics, visit our community site:
Course index

Find Training Near You

Location:
Eg: Seattle, WA or Paris, France

Related Services