Course 805735

Dynamics GP 2013 to 2018 Financials - General Ledger (GL) Accounts Receivable (AR) Accounts Payable (AP) Fixed Assets ( FA) Bank Management

This course explores company setup procedures, how to use reports and inquiries, how to use SmartList to expand inquiry and analysis capabilities and tips for the user to personalize Microsoft Dynamics GP to streamline business practices. Explores the accounting cycle and the processes required to enter financial data into the system. It covers how to set up general ledger accounts, enter general ledger transactions, and post the transactions. This course also shows how to perform additional functions such as account reconciliation, budgeting, allocation, period-end procedures and year-end closing procedures. Examines the accounting cycle and the processes required to enter vendor invoices and process checks. This course also shows you how to perform additional functions such as adjustments, prepayments, month-end closing, and cash flow control. Receivables Management module explores the accounting cycle and the processes required to enter invoices and receive payments from customers. This course also explains how to perform additional functions such as entering credit memos, prepayments, small balance write offs, print customer statements, enter and void scheduled payments, and month-end closing procedures.

Who Should Attend

This GP Boot Camp is intended for customers and partners wanting to learn the basic features and elements required to effectively use Microsoft Dynamics GP, General Ledger, Payables and Receivables. The class is targeted toward data entry clerks, administrators, office managers, CEOs, and consultants who need to understand the basic technical aspects of Microsoft Dynamics GP and gain some basic general knowledge of the application’s functionality.

What You'll Learn

  • Use basic elements such as lookup windows, browse buttons and zooms to access data in Microsoft Dynamics GP.
  • Enter record and window level notes and attach OLE notes to records.
  • Use SmartList to export data to Microsoft Word or Microsoft Excel for further analysis.
  • Use the Posting Setup options to define posting processes.
  • Identify what is required to use Word Templates.
  • Customize system and company setup procedures using the Setup Checklist.
  • Set up fiscal periods, account formats, credit cards and payment terms.
  • Use inquiries and reports to get at the information that is needed from Microsoft Dynamics GP.
  • Customize Microsoft Dynamics GP toolbars, home pages and display settings.
  • Describe the benefits of using Business Alerts and Process Servers.
  • View and use resource descriptions for tables and fields in Microsoft Dynamics GP.
  • Customize General Ledger settings
  • Set up a chart of accounts including posting, unit and allocation accounts
  • Enter and post transactions using transactional or batch posting methods
  • Perform key inquiries and print reports in General Ledger
  • Maintain records in General Ledger
  • Print financial statements and other key reports to manage a business
  • Complete period and year-end procedures
  • Set up Payables Management and identify the customizable options available in the setup windows.
  • Perform all Payables Management related data entry functions including vendor invoicing, check processing, recurring vouchers, and manual checks.
  • Select documents for payment and make appropriate adjustments to payment amounts prior to check processing.
  • Correct input errors using the Edit Transaction Information window.
  • Perform maintenance on Payables Management documents and other records such as vendors and recurring invoices.
  • Understand the steps and requirements to void checks and invoices.
  • Use inquiries or print reports to verify data and perform financial analysis for audit trail purposes.
  • Identify the impact of Payables Management on other areas of Microsoft Dynamics GP.
  • Perform Receivables Management related data entry functions including customer invoicing, customer payment application and recurring invoices.
  • Perform maintenance on Receivables Management documents and maintenance records such as customers, customer classes and scheduled payments.
  • Apply payments and prepayments to customer balances or against specific invoices.
  • Print standard reports for audit trail purposes, financial analysis and to verify data entry.
    Troubleshoot and correct input errors including an incorrect posting date or incorrect document amounts.
  • Perform month-end procedures including aging customer documents, closing statement cycles and printing customer statements.
  • Create asset records, asset books, asset classes, and asset book classes.
  • Maintain asset records using transfers, changes, and retirements.
  • Depreciate assets and post depreciation from Fixed Assets to General Ledger.
  • Understand the possible integration points Fixed Assets has with other Microsoft Dynamics GP modules.
  • Identify available utilities that are used to manage asset records.

Courses include:

  • Intro to Dynamics GP (Monday)
  • Dynamics GP General Ledger & Bank Reconcilliation (Tuesday)
  • Dynamics GP Payables (Wednesday)
  • Dynamics GP Receivables (Thursday)
  • Dynamics GP Fixed Assets (Friday)

Introduction to Microsoft Dynamics GP – Day 1

Module 1: Overview and Basic Elements

This module introduces many of the basic elements that are used throughout Microsoft Dynamics GP. The main window of the application is discussed along with logging on to Dynamics, and many common window functions and objects in Microsoft Dynamics GP are identified and explained.

Lessons

  • Basic Elements
  • Using Notes
  • User Preferences
  • Navigation Pane
  • Home Pages
  • Help and Other Documentation

Module 2: SmartList, Reports, and Inquiries

This module discusses SmartList, an inquiry tool that can be used to access data. It also discusses reporting and inquiry capabilities and the use of Microsoft Word Templates to generate common documents.

Lessons

  • SmartLists
  • Microsoft Word Templates
  • Report Options and Printing
  • Report Groups
  • Report List and My Reports
  • Excel Reports
  • Inquiries, Named Printers and Process Monitor

Module 3: System and Posting Setup

This module explains some basic system setups along with information about the different ways to post transactions in Microsoft Dynamics GP. System setups discussed include security, users and user classes. Posting Setup is discussed along with related topics such as audit trails and source documents.

Lessons

  • System Setup
  • Posting Methods and Setup Options
  • Posting Accounts and Audit Trails

Module 4: Company Setup Procedures

This module examines how to set up companies in Microsoft Dynamics GP and then define options specific to each company. The company setup windows are used to define company parameters such as company information, Internet information, fiscal periods, account format, credit cards, shipping methods, payment terms and custom links.

Lessons

  • Creating Companies
  • Accessing Companies
  • Setup Checklist
  • Account Format
  • Fiscal Periods
  • Company Information and Setup Options
  • Shipping Methods
  • Payment Terms
  • Credit Cards
  • Other Company Setups
  • Internet Information
  • Emailing Documents
  • Unified Communications Tax Setup Tax Calculations in Receivables and Payables Tax Calculations in Sales Order Processing

Module 5: Customization and Utilities

This module explains the ways to customize a number of elements in the Microsoft Dynamics GP system to individual needs, enabling work to be completed more efficiently. Additionally, resource information on tables and fields are discussed and some other miscellaneous system utilities are also a focus in this module.

Lessons

  • Series Checklists
  • Customizing Toolbars
  • Activity Tracking
  • Process Server Overview
  • Other Customization Options
  • Removing Security Setup Records
  • Installation and Customization
  • Table Information and Maintenance
  • Backups

General Ledger & Bank Reconcilliation -Day 2

Module 1: Overview and Setup

This module provides a general overview of the features and benefits of using General Ledger in an integrated environment and focuses on how General Ledger integrates with other functional areas in the Microsoft Dynamics GP application. This module also focuses on the setup procedures and different types of accounts in General Ledger and how to define budgets for accounts using Microsoft Dynamics GP or Microsoft Excel.

Lessons

  • Features and Benefits
  • General Ledger Setup
  • Account Categories
  • Posting Account Setup
  • Unit Account Setup
  • Fixed Allocation Account Setup
  • Variable Allocation Account Setup
  • Account Segment Setup
  • Mass Modify Chart of Accounts
  • Define the Retained Earnings Account
  • Set Up Budgets
  • Budget Maintenance
  • Combining Budgets
  • Quick Journal Setup
  • Transaction Matching Setup
  • Entering Beginning Balances

Module 2: Daily Procedures

This module defines the ways that transactions can be entered and posted in General Ledger. It explores the difference between transaction level and batch level posting and the methods for posting batches. It also demonstrates how to use clearing entries to transfer the balance of an account that is no longer being used to another account.

Lessons

  • Batch Entry
  • Transaction Entry
  • Calculate Taxes in General Ledger
  • Clearing Transaction Entry
  • Budget Transaction Entry
  • Quick Journal Entry
  • Linking Transactions
  • Batch Recovery

 Module 3: Additional Functionality

This module examines how to use Multidimensional Analysis, Intercompany functionality and set up Organizational Structures to use account security.

Lessons

  • Multidimensional Analysis Groups and Codes
  • Assign Analysis Groups to Accounts
  • Multidimensional Analysis Transactions
  • Define Intercompany Relationships
  • Entering Intercompany Transactions
  • Organizational Structures Setup
  • 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
  • Activating Account Security

Module 4: Maintaining Records

This module examines the functionality available to maintain General Ledger records. There is a lesson 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 other sub-ledgers. Inquiries and reports are also discussed in this module.

Lessons

  • 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

Module 5: Period-End Closing

This module 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 module also looks at financial statements typically printed at the end of periods. 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 Closing
  • Year-End Closing
  • Quick Financial Statements
  • Printing Financial Statements
  • Advanced Financial Analysis

Day 2 Continued -Bank Reconciliation

This course explores the processes required to manage cash receipts, cash disbursements, and other transactions that affect checkbook balances. It also shows you how to perform the checkbook reconciliation process in the Bank Reconciliation module, ensuring accuracy of your financial data and its relation to your financial institution statements.

Who Should Attend

This course is intended for customers who want to learn the basic features and to develop a working knowledge of the typical day-to-day procedures required to effectively use Microsoft Dynamics GP Bank Reconciliation. Bank Reconciliation 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 have to understand the technical aspects of Bank Reconciliation and gain foundational knowledge of the application functionality.

Course Outline

Module 1: Overview and Setup Procedures

This module gives students a general overview of the features and benefits of using the Bank Reconciliation in an integrated environment. It also focuses on the setup procedures for Bank Reconciliation, and the options available to customize it to reflect the way your organization does business. This module also covers entering beginning balances for each checkbook in preparation for using Bank Reconciliation.

Lessons

  • Features and Benefits
  • Bank Reconciliation Setup
  • Checkbook Maintenance
  • Transfer Existing Checkbooks to Bank Reconciliation

Module 2: Daily Procedures

This module defines the ways that transactions can be entered and posted in Bank Reconciliation. The different types of transactions, receipts, and deposits that may be entered in Bank Reconciliation are discussed. This module also explains how each type of transaction may update the cash account balance in the General Ledger, the checkbook balance in Bank Reconciliation, or both.

Lessons

  • Bank Transaction Entry
  • Enter Checks, Withdrawals and Adjustments
  • Enter Receipt Transactions
  • Miscellaneous Checks
  • Bank Transfer Entry
  • Deposit with Receipts
  • Deposit without Receipts
  • Clear Unused Receipts

Module 3: Reconcile Bank Statements

This module examines the steps that are required to reconcile a checkbook to the bank statement using Bank Reconciliation. The process to enter miscellaneous transactions and adjustments during the reconcile process is also covered in this module. Time is also spent discussing the transaction posting that occurs during the reconcile process.

Lessons

  • Reconcile Bank Statements
  • Select Bank Transactions
  • Enter Adjustments and Reconcile

Module 4: Maintaining Records

This module examines the functionality available to maintain Bank Reconciliation records. The processes to void transactions, transfers, and deposits are covered. Time is also spent discussing the procedure for changing and deleting records and how to remove historical information from Bank Reconciliation and the effects of removing this type of history is discussed. The inquiry windows and some reports that can be generated from Bank Reconciliation are also discussed.

Lessons

  • Voiding Transactions
  • Deleting Checkbooks
  • Removing History
  • Using Inquiries
  • Report Options and Printing
  • Report Groups
  • Report List

Labs

Lab: Bank Reconciliation Setup
Lab: Checkbook Setup
Lab: Enter an Outstanding Check
Lab: Enter a Check Transaction
Lab: Enter a Cash Receipt
Lab: Printing a Check
Lab: Enter a Bank Transfer
Lab: Enter a Deposit with Receipts
Lab: Enter a Deposit without Receipts
Lab: Reconciling a Checkbook
Lab: Removing History

What You'll Learn

  • Identify the impact of the Bank Reconciliation module on other modules.
  • Customize the setup of Bank Reconciliation to fit their business needs.
  • Perform all Bank Reconciliation related data entry functions. This includes bank transactions, bank deposits, and bank transfers.
  • Perform maintenance on Bank Reconciliation documents and records such as checkbooks.
  • Print standard reports for audit trail purposes, financial analysis, and to verify data entry.
  • Perform the bank reconciliation process in Bank Reconciliation.

Payables Management - Day 3

Module 1: Overview and Setup Procedures

This module discusses the necessary setup options to start using Payables Management in Microsoft Dynamics GP. It discusses the general setup windows and also key record setups including vendors and vendor classes.

Lessons

  • Features and Benefits
  • Payables Management Setup
  • Payables Setup Options
  • Vendor Class Maintenance
  • Vendor Class Accounts Setup
  • Vendor Maintenance
  • Vendor Maintenance Options
  • Vendor Address Maintenance
  • Vendor Account Maintenance
  • Beginning Balances
  • Vendor History

Module 2: Daily Procedures

This module explains the different types of transactions that can be entered in Payables Management. Transactions discussed include invoices, credit memos, debit memos and scheduled payment invoices.

Lessons

  • Batch Entry
  • Payables Transaction Entry
  • Scheduled Payments Entry
  • Post Scheduled Payments

Module 3: Entering Payments

This module explains how to enter payments made to vendors. It discusses entering manual payments and generating checks to pay vendors.

Lessons

  • Payables Manual Payment Entry
  • Computer Checks – Select Checks
  • Edit Payables Checks
  • Edit Payables Check Batches
  • Print and Post Checks
  • Apply Payables Documents
  • Batch Recovery

Module 4: Intercompany Transactions

This module discusses the capabilities and use of intercompany transactions in Payables Management.

Lessons

  • Define Intercompany Relationships
  • Enter Intercompany Transactions
  • Post Intercompany Transactions in General Ledger
  • View Intercompany Transactions in Inquiry

Module 5: Maintaining Records

This module focuses on how to manage vendor relationships and the transaction data that you collect from purchasing transactions. Also included in this module is information about reporting and inquiry on vendors and transactions that are associated with purchasing.

Lessons

  • Vendor and Transaction Holds
  • Void Open Payables Transactions
  • Void Historical Transactions
  • Edit Payables Transactions
  • Change or Delete Vendor Records
  • Remove History
  • Reconcile
  • Use Inquiries
  • Report Options and Printing
  • Report Groups

Module 6: Period-End Procedures

This module discusses period-end closings and the recommended steps that must be completed at each closing. Many of the steps are optional.

Lessons

  • Closing a Period
  • Close the Calendar Year
  • Close the Fiscal Year

Receivables - Day 4

Module 1: Overview and Setup Procedures

This module gives students a general overview of the features and benefits of using Receivables Management in an integrated environment. In addition it discusses setup procedures and examines in detail the options available to customize. It also focuses on the integration between Receivables Management and General Ledger in Microsoft Dynamics GP.

Lessons

  • Features and Benefits
  • Setup Procedures
  • Receivables Management Setup
  • Receivables Setup Options
  • Sales Territory Maintenance
  • Salesperson Maintenance
  • Customer Class Setup
  • Customer Maintenance
  • Customer Maintenance Options
  • National Accounts Maintenance
  • Refund Check Setup
  • Sales Email Setup
  • Beginning Balances

Module 2: Daily Procedures

This module explains the daily procedures performed in Receivables Management. It focuses on the entry of transactions such as invoices, cash receipts, and finance charges.

Lessons

  • Transaction Entry Overview
  • Receivables Batch Entry
  • Receivables Transaction Entry
  • Enter Receivables Scheduled Payments
  • Enter Cash Receipts
  • Apply Posted Transactions
  • Enter Refund Checks
  • Batch Recovery

Module 3: Maintaining Records

This module focuses on the process of maintaining records in Receivables Management. It focuses on how to manage and view receivables data.

Lessons

  • NSF Checks, Voiding, and Waiving Posted Transactions
  • Change and Delete Records
  • Edit Receivables Transactions
  • Remove History
  • Reconcile
  • Perform an Inquiry
  • Reports

Module 4: Period-End Processing

This module explains the procedures performed at the end of fiscal periods in Receivables Management.

Lessons

  • Period-End Procedures Overview
  • Aging Process
  • Finance Charges
  • Print Statements
  • Reprint Statements
  • Paid Sales Transactions Removal
  • Other Period-End Procedures
  • Reconcile Receivables to General Ledger
  • Year-End Routines

Fixed Assets - Day 5

Module 1: Overview and Setup Procedures

This module provides an overview of the features and benefits of using Fixed Assets in Microsoft Dynamics GP in an integrated environment. It examines the options available to customize this module to reflect the way your organization does business. You will learn how to set up assets to track depreciation information for a company and will discuss how to use asset classes and asset books to organize asset data.

Lessons

  • Features and Benefits
  • Fixed Assets Processes and Integration
  • Configure the Fixed Assets Calendar
  • Enter Account Groups
  • Enter Fixed Assets Post Accounts
  • Create Insurance and Asset Class Records
  • Create Book Records
  • Create Book Class Records
  • Fixed Assets Company Setup
  • Create Location and Physical Location Records
  • Create Lease, Retirement and Structure Records
  • Fixed Assets User Preferences
  • Enter Existing Assets

Module 2: Daily Procedures

This module defines the ways that assets can be added in Fixed Assets. It explores the Payables Management and Purchase Order Processing interface and how to import new asset additions using the Asset Import/Export window. The major focus of this chapter is the interface from Payables and Purchase Order to Fixed Assets.

Lessons

  • Asset General Information
  • Asset Account Information
  • Asset Book Information
  • Asset Insurance and Lease Records
  • Asset User Data
  • Payables Management Interface
  • Purchase Order Processing Interface

Module 3: Maintaining Records

This module examines the functionality available to maintain Fixed Assets records. The process to perform depreciation projections, asset transfers, and asset retirements is discussed in detail. The utilities that ensure the integrity of data such as file maintenance, reconcile, and deleting assets are examined. It also discusses the Inquiry windows and reports that can be generated from the Fixed Assets module.

Lessons

  • Select Assets
  • Depreciation Projections
  • Changing Asset Information
  • Transferring Assets
  • Retire Assets
  • Retire Undo
  • Asset Utilities
  • Using Inquiries
  • Report Options and Printing
  • Report List

Module 4: Period-End Procedures

This module examines the processes that are completed at the end of the month, period, calendar, and fiscal year. It focuses on issues that may cause Fixed Assets to be out of balance with the General Ledger. It also discusses the reports that should be printed prior to performing the closing process.

Lessons

  • Period-End Procedures
  • Year-End Procedures

*NOTE: if an average rating and rating count are shown on this page, they are based on all reviews associated with Dynamics Edge that are shown on the review page, and are not restricted to reviews only for the particular course offered on this page.


805735Dynamics GP 2013 to 2018 Financials - General Ledger (GL) Accounts Receivable (AR) Accounts Payable (AP) Fixed Assets ( FA) Bank Management
Banner rating d5dfd02e10e7bea369b370d45102dadcf6d70e41b6bfce1ee178127969f7852a
Dynamics Edge4.67 out of 50 stars, based on 80 reviews*

Purchase

Price: $3295
Duration: 5 days
Select Date:
Number of Seats:
Selected Date:
Selected Location:
Class Time: - EST