Course 8344A:

Microsoft Business Solutions - Great Plains 8.0 General Ledger I

Length:1 Days
Published:September 24, 2004
Language(s):English
Audience(s):IT Professionals
Level:200
Technology:Microsoft Business Solutions–Great Plains 8.0
Type:Course
Delivery Method:Instructor-led (classroom)
About this CourseCourse 8344: The one-day Microsoft Business Solutions – Great Plains General Ledger course explores the accounting cycle and the processes required to enter financial data into the system.
Course OutlineModule 1: Introduction
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 Great Plains application.
Lessons
  • General Ledger Features and Benefits
  • General Ledger Overview and Roadmap
  • Integration
Module 2: Setup Procedures
This chapter focuses on the setup procedures for the General Ledger module. You 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. Once your General Ledger has been set up there are many reports that are available to document the selected preferences. The next step is to enter Beginning Balances and the options available for this step 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
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
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
After completing this chapter, students will be able to:
  • Utilize 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
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
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
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
Module 9: Financial Statement Formatting
In 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
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: Conclusion
This chapter reviews the key points discussed in this course.
Lessons
  • Posting accounts must be assigned to Account Categories
  • Unit Accounts track non-financial information
  • Fixed and Variable allocation accounts may be used to allocate expenses to a department or division based on percentages or breakdown account balances
  • Reversing and clearing transaction help speed data entry by automating these processes
  • Budgets may be created using the Budget Wizard in Great Plains and exported or imported to Microsoft Excel
  • Quick Journals provide a template for entering journal entries
  • Recurring batches may be used for transactions that occur frequently, such as monthly
  • Inquiries provide users with an excellent tool for tracing transactions back to the source document
  • Quick Financial statements are easy to customize and are based on account categories
  • Intercompany Processing allows you to record intercompany transactions quickly and easily
  • The year end process automates the clearing of profit and loss accounts to retained earning and brings the balance sheet accounts forward
  • Several tools, such as: Transaction Matching, Account Rollup Inquiry and Organizational Structures are provided to help customize Great Plains to meet your business needs
Module 11: Appendix: 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
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 12: Appendix: Canadian Information
This chapter focuses on sales and purchases taxes specific to Canadian businesses. Setting up tax details and tax schedules and calculating taxes on transactions is included in this section. In addition, creating two customer and vendor classes (US and Canada) for each vendor or customer to maintain separate sub-ledgers and balance to General Ledger is covered in this section. Based on country-specific needs, this chapter is optional for classroom presentation.
Lessons
  • Purchasing Tax Details and Schedules
  • Sales Tax Details and Schedules
  • Vendor & Customer Classes
Module 13: Appendix: 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
Before attending this course, students must have:
  • General knowledge of Microsoft Windows
  • Completed the Microsoft Great Plains Tutorial
  • 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:

Find Training Near You

Tip

Our Microsoft Certified Partners for Learning Solutions have not yet provided us with their schedules. This training may still be scheduled in your area.

Search for Certified Learning Solutions Partners in your area.

Related Services