General Ledger in Microsoft Dynamics GP 10.0
Course 8812: One day; Instructor-led
Prerequisites
Before attending
this course, students must have:
• General
knowledge of Microsoft Windows
• Basic
knowledge of accounting principles
Microsoft Certified Professional Exams
No Microsoft Certified Professional exams are associated with this course currently.
Course Materials
The student materials include a comprehensive workbook and access to the Microsoft Dynamics GP application.
Course Outline
Chapter 1: Overview and Setup
This chapter provides a general overview of the features and benefits of using the General Ledger module in an integrated environment. and focuses on how this module integrates with other modules in the Microsoft Dynamics GP application. This chapter also focuses on the setup procedures for the General Ledger module. The chapter examines the different types of accounts in General Ledger, and how to define budgets for accounts using Microsoft Dynamics GP or Microsoft Excel. There is a section that 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. Entering beginning balances and the options available for this are also examined.
Main Topics
• General
Ledger Features and Benefits
• Integration
• General
Ledger Setup
• Account
Categories
• Posting
Accounts Setup
• Unit
Accounts Setup
• Fixed
Allocation Account Setup
• Variable
Allocation Account Setup
• Account
Segment Setup
• Mass
Modify Chart of Accounts
• Defining
the Retained Earnings Account
• Setting
up Budgets
• Excel-based
Budgeting
• Budget
Maintenance
• Quick
Journal Setup
• Transaction
Matching Setup
• Entering
Beginning Balances
Labs
• Entering
a Posting Account
• Entering
a Unit Accounts
• Entering
a Fixed Allocation Account
• Entering
a Variable Allocation Accounts
• Mass
Modify the Chart of Accounts
• Account
Segment Setup
• Creating
a Bank Budget in Microsoft Excel
• Importing
a Budget from Excel
• Quick
Journal Setup
After completing
this module, students will be able to:
• Identify
the features and benefits available in General Ledger.
• Discuss
integration that takes place between General Ledger and other modules.
• Identify
the navigation used to access the windows used to set up General Ledger.
• Customize
settings for the General Ledger module.
• Enter
a chart of accounts; posting, unit, fixed allocation and variable allocation.
• Define
a retained earnings account and understand the options available.
• Enter
budget information.
• Create
Quick Journal entries to speed data entry and minimize errors.
• Enter
Beginning Balances for their chart of accounts.
Chapter 2: Daily Procedures
This chapter defines the ways that transactions can be entered and posted in General Ledger. The chapter explores the difference between transaction level and batch level posting, and the methods for posting batches. The chapter also 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 be a power fluctuation or posting interruption.
Main Topics
• Batch
Entry
• Transaction
Entry
• Calculate
Taxes in General Ledger
• Clearing
Transaction Entry
• Quick
Journal Entry
• Linking
Transactions
• Batch
Recovery
Labs
• Transaction
Entry, Unit Accounts
• Transaction
Entry, Allocation Accounts
• Transaction
Entry, Recurring Transactions
• Clearing
Entry
• Quick
Journal Entry
After completing
this module, 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.
Chapter 3: Additional Functionality
This chapter examines how to use Multidimensional Analysis, enter Intercompany transactions and set up Organizational Structures to use account security.
Main Topics
• Multidimensional
Analysis Groups and Codes
• Assigning
Analysis Groups to Accounts
• Entering
Transactions using Multidimensional Analysis
• Performing
Multidimensional Analysis Inquiries
• Defining
Intercompany Relationships
• Entering
Intercompany Transactions
• Posting
Intercompany Transactions
• Organizational
Structures Setup
• Define
Organizational Relationships
• Assigning
User Classes to Organizational Structures
• Assigning
Users to Organizational Structures
• Assigning
a Range of Accounts to Organizational Structures
• Assigning
Individual Accounts to Organizational Structures
• Activating
Account Security
Labs
• Multidimensional
Analysis
• Organizational
Structure Setup
• Organization
Tree Setup
• Organizational
Structure User Setup
• Organizational
Structure Mass Assignment
After completing
this module, 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.
• 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.
• Define
discrete business entities using Organizational Structures.
• Define
relationships between multiple business entities.
• Define
account security levels based on their organizational structure.
Chapter 4: Maintaining Records
This chapter examines the functionality available to maintain General Ledger records. There is a section that focuses on correcting posted entries as well as changing and deleting account records. Information about the reconcile features in General Ledger are discussed, including the capability of reconciling to the payables and receivables sub-ledgers. Retrieving information is also a big focus of this chapter. Time is spent discussing the inquiry windows and how reports can be generated from the General Ledger module using report options and groups.
Main Topics
• Correcting
a Posted Transaction
• Change,
Inactivate and Delete Account Records
• Reconcile
• Reconcile
to GL
• Remove
History
• Archive
Matched Transactions
• Account
Rollups
• Using
Inquiries
• Report
Options and Printing
• Report
Groups
• Report
List
After completing
this module, students will be able to:
• Correct
posted entries.
• Change
and delete records.
• Use
inquiries to retrieve information.
• Use
Account Rollup Inquiry.
• Set
up report options and report groups for reporting purposes.
Chapter 5: 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. The chapter looks 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.
Main Topics
• Period-End
Closing
• Year-End
Closing
• Quick
Financial Statements
• Printing
Financial Statements
• Advanced
Financial Analysis
After completing
this module, students will be able to:
• Complete
period-end processes for an accounting period in General Ledger.
• Consolidate
periods and be aware of the effects of performing the consolidation process.
• Complete
the processes that should be performed at the end of a fiscal year.
• Create
and print quick financial statements.
• Understand
basic concepts of using Advanced Financial Analysis.
Appendix A: Job Aids
This appendix includes job aids that are used in General Ledger.
Appendix B: Case Study
For more information or to give feedback, send e-mail to info@OneApex.com or call 949-597-2100
 |
 |
 |
