Microsoft Dynamics GP Training & Classes

Installation and Configuration-Training

[Note- Microsoft Dynamics GP – All versions available]

COURSE DESCRIPTION
The Microsoft Dynamics GP Installation and Configuration course provides the tools to help users understand technologies and techniques necessary to successfully install Microsoft Dynamics GP.

WHO SHOULD ATTEND
Microsoft Dynamics GP Installation and Configuration training is recommended for people who plan to install, implement, configure, consult, or support Microsoft Dynamics GP. The class is intended for administrators, implementers, developers, and consultants who need to understand the technical aspects of Microsoft Dynamics GP. The course is not intended for non-technical staff.

WHAT YOU’LL LEARN

  • Identify requirements and prerequisites for installing Microsoft Dynamics GP
  • Install Microsoft SQL Server
  • Install Microsoft Dynamics GP
  • Use Microsoft Dynamics GP Utilities to uniquely configure an installation and perform any other required tasks for an installation
  • Troubleshoot installation issues and errors
  • Identify hardware and software requirements for desktop clients
  • Install Microsoft Dynamics GP desktop on a client computer
  • Create an Installation Package
  • Understand how to install service packs and updates to Microsoft Dynamics GP
  • Identify the prerequisites and requirements for the Microsoft Dynamics GP Web Client
  • Understand the components and concepts of the web client
  • Complete necessary system setups within the Microsoft Dynamics GP application such as home pages, passwords, users, and security
  • Set up company information
  • Configure, backup, and maintain SQL databases for Microsoft Dynamics GP
  • Understand how to optimize performance and troubleshoot issues with Microsoft Dynamics GP
  • Understand how to set up and use a process server for Microsoft Dynamics GP
  • Identify the available reporting options that are available for Microsoft Dynamics GP and set up and configure them for use

 

COURSE OUTLINE

Module 1: System Requirements and SQL Server Installation
This module outlines the recommendations and the requirements that you must have to install Microsoft SQL Server for use with Microsoft Dynamics GP. Additionally, this module covers tips for optimizing the system in preparation for the installation of Microsoft Dynamics GP. This includes network requirements and server configuration.

Lessons

  • Microsoft Dynamics GP System Requirements
  • Microsoft SQL Server Installation and Configuration
  • Microsoft SQL Server Express Installation and Configuration
    SQL Server Books Online

Module 2: Data Server Installation and Utilities
This module explains how to select the location and features that will be installed to meet the organization’s specific requirements.

Lessons

  • Microsoft Dynamics GP Installation
  • Microsoft Dynamics GP Utilities
  • Microsoft Dynamics GP Utilities – Basic Installation
  • Microsoft Dynamics GP Utilities – Advanced Installation
  • SQL Server Changes After System Database Initialization
  • Microsoft Dynamics GP Utilities – Additional Tasks
  • Troubleshoot Errors

Module 3: Desktop Client Installation, Components and Maintenance
This module explains how to complete an installation for a desktop client. It also discusses how to create an installation package, to install other desktop clients and provides background on key components and features that are available in Microsoft Dynamics GP to maintain the application for end users.

Lessons

  • Microsoft Dynamics GP Desktop Client Prerequisites, Requirements and Installation
  • Client Installation Package
  • Service Packs and Automatic Updates
  • Installation Components and Files
  • Identity Columns
  • Stored Procedures

Module 4: Web Client Installation and Components
This module describes the process that is used to install Microsoft Dynamics GP Web Client. The module also discusses the prerequisites and the requirements for an installation.

Lessons

  • Web Client Installation and Components
  • Microsoft Dynamics GP Web Client Installation
  • Navigation Comparison
  • Troubleshooting the Microsoft Dynamics GP Web Client

Module 5: System Manager
This module discusses the setup of system and company settings such as home page, users, passwords, user security and preferences necessary when setting up Microsoft Dynamics GP.

Lessons

  • Home Page
  • System Setup
  • Security
  • Advanced Financial Analysis Reports Security
  • User Activity and Preferences
  • Company Setup

Module 6: Post Installation Administration
This module explains the administrative tasks that are necessary after installation of Microsoft Dynamics GP to help ensure consistency and maintain performance of the system. It introduces the tools that are used to perform these tasks.

Lessons

  • Database Options
  • Database Backup Procedures
  • Microsoft Dynamics GP – SQL Maintenance
  • Drop and Create Auto Procedures
  • Microsoft Dynamics GP Database Maintenance Utility
  • SQL Database Maintenance (DBCC)
  • Use the Microsoft SQL Server Maintenance Plan Wizard
  • Microsoft Dynamics GP Maintenance Procedures

Module 7: Optimize Performance and Troubleshooting
This module discusses how to monitor performance and troubleshoot issues with Microsoft Dynamics GP and Microsoft SQL Server. It also includes considerations for when you use the Microsoft Windows Server operating systems.

Lessons

  • Windows Server Considerations
  • SQL Server Configuration
  • Optimize a SQL Relational Database
  • Analyze Network and Microsoft SQL Server Performance
  • Optimization Summary
  • Troubleshooting – Identify the Issue
  • Troubleshooting – Types of Issues and Resolution Sources
  • Troubleshooting – Tools
  • Batch Recovery Process

Module 9: Reporting
This module provides information on the available reporting options in Microsoft Dynamics GP and what is needed from an installation and setup prospective to use these different reporting options.

Lessons

  • Report Writer – Manage Reports and Report Security
  • Microsoft SQL Server Reporting Services
  • Microsoft SQL Server Report Builder
  • Microsoft Dynamics GP Business Analyzer
  • Microsoft Office Excel Reports Deployment and Configuration
  • Microsoft Word Templates – Configuration and Maintenance
  • Distribute Reports by Email
  • Report Scheduler
  • Management Reporter 2012 Installation and Configuration

Labs

Lab: Install Microsoft Dynamics GP
Lab: Run Microsoft Dynamics GP Utilities
Lab: Create a Client Installation Package
Lab: User Setup, Company Access and Security
Lab: Back Up Database
Lab: Microsoft SQL Server Memory Options
Lab: Using Microsoft SQL Profiler
Lab: Create a Dexsql.log
Lab: Create a Modified Report
Lab: Create a Custom Report
Lab: Deploy Excel Reports
Lab: Schedule a Report

Interested in learning more?

Expand

Introduction to Microsoft Dynamics GP – Training

[Note – all versions available]

COURSE DESCRIPTION
This course explores the basic elements of Microsoft Dynamics GP. Topics covered during this session include system and 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.

WHO SHOULD ATTEND
This course is intended for customers and partners wanting to learn the basic features and elements required to effectively use Microsoft Dynamics GP. 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
After completing this course, students will be able to:

  • 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.

 

COURSE OUTLINE

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

 

Labs

Lab: Advanced Lookups
Lab: OLE Notes
Lab: User Preferences
Lab: SmartList
Lab: Report Options and Groups
Lab: Security Tasks
Lab: Security Roles
Lab: Assigning Security Roles to Users
Lab: Modifying Posting Settings
Lab: Create a New Company
Lab: Account Format
Lab: Defining Fiscal Periods
Lab: Entering Company Information
Lab: Set Up Shipping Methods
Lab: Set Up Payment Terms
Lab: Set Up Custom Links
Lab: Set Up a New Tax
Lab: Checklists
Lab: Toolbars

 Interested in learning more?

Expand

General Ledger- Training

[Note-in Microsoft Dynamics GP – All versions available]

COURSE DESCRIPTION
This course 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.

WHO SHOULD ATTEND
This course is intended for customers and partners that want to learn the basic features and understand the typical day-to-day procedures of General Ledger. The class is targeted toward data entry clerks, administrators, office managers, CEOs, accountants, and consultants who need to understand the technical aspects of Microsoft Dynamics GP General Ledger and understand how to use it in accordance with the rest of the system.

WHAT YOU’LL LEARN

  • 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

 


COURSE OUTLINE
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

Labs
Lab: Enter a Posting Account
Lab: Enter a Unit Account
Lab: Enter a Fixed Allocation Account
Lab: Enter a Variable Allocation Account
Lab: Account Segment Setup
Lab: Mass Modify Chart of Accounts
Lab: Create a Blank Budget in Excel
Lab: Importing a Budget from Excel
Lab: Quick Journal Setup
Lab: Transaction Entry, Unit Accounts
Lab: Transaction Entry, Allocation Accounts
Lab: Transaction Entry, Recurring Transactions
Lab: Clearing Entry
Lab: Budget Transaction Entry
Lab: Quick Journal Entry
Lab: Multidimensional Analysis
Lab: Organizational Structure Setup
Lab: Organizational Tree Setup
Lab: Organizational Structure, User Setup
Lab: Organizational Structure, Mass Assignment
Lab: Quick Financial Setup
Lab: Quick Financial, Report Options

Interested in learning more?

Expand

Payables Management- Training

[Note-Microsoft Dynamics GP – All versions available]

COURSE DESCRIPTION
The one-day Microsoft Dynamics GP Payables Management course 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.

WHO SHOULD ATTEND
This course is intended for customers wanting 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 Payables Management. The class is targeted toward data entry clerks, administrators, office managers, CEOs, and consultants who need to understand the technical aspects of Payables Management and gain foundational knowledge of the application functionality.

WHAT YOU’LL LEARN

  • 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.

COURSE OUTLINE
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

Labs

Lab: Payables Management Setup
Lab: Setting up a New Vendor Class
Lab: Setting up a New Vendor
Lab: Enter an Invoice
Lab: Enter and Pay an Invoice
Lab: Enter a Credit Memo
Lab: Payables Scheduled Payments
Lab: Manual Payments, Credit Card
Lab: Manual Payments, Enter a Prepayment
Lab: Select Checks
Lab: Edit Payables Checks; Adding a Payment
Lab: Edit Payables Checks; Removing a Vendor/Voucher
Lab: Printing and Posting Checks
Lab: Applying Payables Documents
Lab: Transaction Holds
Lab: Void an Open Transaction
Lab: Void a Historical Transaction
Lab: Edit Transaction Information
Lab: Delete a Vendor
Lab: Remove History
Lab: Close Fiscal Periods
Lab: Year-End Closing

Interested in learning more?

Expand

Receivables Management-Training

[Note-Microsoft Dynamics GP – All versions available]

COURSE DESCRIPTION
The Microsoft Dynamics GP Receivables Management course 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 course is intended for anyone wanting 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 Receivables Management.

WHAT YOU’LL LEARN

  • 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.

 

COURSE OUTLINE
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

Labs

  • Lab: Receivables Management Setup
  • Lab: Set Up a New Sales Territory
  • Lab: Set Up a New Salesperson
  • Lab: Modify a Customer Class
  • Lab: Set Up a New Customer
  • Lab: Set Up a National Account
  • Lab: Set Up Refund Checks
  • Lab: Receivables Transaction Entry
  • Lab: Credit Memo Entry
  • Lab: Receivables Scheduled Payments
  • Lab: Cash Receipts Entry
  • Lab: National Accounts/Cash Receipts Entry
  • Lab: Apply Posted Transactions
  • Lab: Creating and Printing Refund Checks
  • Lab: Voiding a Document
  • Lab: Assessing a Non-Sufficient Funds Charge
  • Lab: Edit Receivables Transactions
  • Lab: Aging Process
  • Lab: Write Off an Invoice

Interested in learning more?

Expand

Bank Reconciliation- Training

COURSE DESCRIPTION
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.

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.

 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

Interested in learning more?

Expand

Fixed Assets- Training

[Note- all versions of Microsoft Dynamics GP available]

COURSE DESCRIPTION
The Microsoft Dynamics GP Fixed Assets course describes the processes required to enter, depreciate, and retire fixed assets. This course also demonstrates how to perform additional related functions such as changing asset information, mass changes, partial transfers and partial retirements.

WHO SHOULD ATTEND
This course is intended for someone wanting to learn the basic features and to develop a working knowledge of the typical day-to-day procedures required to effectively use Fixed Assets. The class is targeted toward data entry clerks, administrators, accountants, CEOs, and consultants who need to understand the technical aspects of Fixed Assets in Microsoft Dynamics GP and gain foundational knowledge of the application’s functionality.

WHAT YOU’LL LEARN

  • 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.

 

COURSE OUTLINE

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

Labs
Lab: Account Group Setup
Lab: Purchasing Posting Accounts Setup
Lab: Class Setup
Lab: Book Setup
Lab: Book Class Setup
Lab: Fixed Assets Company Setup
Lab: Asset General Information
Lab: Asset Book Information
Lab: Asset Book ITC Information
Lab: Payables Management Interface
Lab: Enter a Purchase Order for a Capital Item
Lab: Receive the Capital Item
Lab: Enter a Capital Item in Fixed Assets
Lab: Select Assets
Lab: Depreciation Projection
Lab: Mass Change
Lab: Transfer an Asset
Lab: Partial Retirement
Lab: Retire Undo
Lab: Depreciation
Lab: Fixed Assets to General Ledger Posting

Interested in learning more?

Expand

Inventory Control in Microsoft Dynamics GP – Training

COURSE DESCRIPTION
This course shows you how to define default system parameters to improve user efficiency and cut down on costly data entry errors. These parameters include General Ledger accounts used in the Inventory Control module, as well as sites, product classes, valuation methods, and more. This course shows you how to group items for pricing, promotional, or analytical purposes and by type, such as finished goods, raw material, component, and more. You learn how to quickly find information such as inventory quantity on hand, quantity available, quantity on back order, costs, and list prices, and where to drill down to transaction details. You learn how to manage multiple sites, multiple bins within sites, negative quantities, and lot/serial numbers. You see how Lot/Serial Number tracking is streamlined during inventory transaction entry. You will also learn how to simplify entry and reconciliation of physical inventory counts.

WHO SHOULD ATTEND
This course is intended for anyone who plans to implement, use, maintain, consult, or support any part of the Inventory and Order Processing series. The class is targeted toward administrators, office managers, CEOs, and consultants who need to understand the technical aspects of Inventory Control and gain foundational knowledge of the application functionality.


 

COURSE OBJECTIVES

  • Understand how Inventory Control module transactions integrate with other Microsoft Dynamics GP modules
  • Define Inventory Control setup options that allow you to customize the system to better fit your organization’s unique needs
  • Use the Inventory Control module to process receipts, make adjustments to inventory, and transfer transactions
  • Use Inventory Control inquiry screens and reports to extract and analyze appropriate information to maintain and improve inventory business processes
  • Create and assemble kits
  • Understand how maintenance screen options affect transactions in the Inventory Control module
  • Process physical inventory transactions and record the results
  • Document month-end processes and close the Inventory Control module

 

COURSE OUTLINE

Module 1: Overview and Setup

  • Course Description
  • Module Overview
  • Process Flow
  • Inventory Setup
  • Unit of Measure
  • Price Levels
  • Price Groups

 

Module 2: Item and Pricing Setup

  • Item Class Setup
  • Item Maintenance
  • Item Accounts
  • Item Price Lists
  • Item Quantities
  • Item Purchasing Options
  • Item Vendors Maintenance
  • Item Kits
  • Site Maintenance
  • Item Stock Count Cycles
  • Customer Item Maintenance
  • Beginning Quantities
  • Item History

 

Module 3: Daily Procedures

  • Transaction Entry Overview
  • Posting Overview
  • Inventory Batch Entry
  • Adjustment and Variance Transactions
  • Item Transfers
  • Bin Transfer Entry
  • In-Transit Transfer
  • Stock Count Scheduling
  • Stock Count Entry

 

Module 4: Editing and Removing Records

  • Change and Delete Records
  • Reconcile
  • Adjust Costs
  • Change Valuation Methods
  • Change Decimal Places
  • Price List Utilities
  • Remove History
  • Remove Bins
  • Purge In-Transit Transfer
  • Using Inquiry Windows
  • Reports
  • Report Lists

 

Module 5: Period-End Procedures

  • Period-End Procedures
  • Year-End Closing Procedures

Interested in learning more?

Expand

Sales Order Processing- Training

COURSE DESCRIPTION
The Microsoft Dynamics GP Sales Order Processing course explores the processes required to enter and ship sales orders. This course shows you how to easily manage the life-cycle of your customers’ orders, from the initial quote to the shipment documentation and final invoicing. This course also examines how to perform additional sales functions, such as setting up process holds for quality assurance and linking order documents to purchase orders.

WHO SHOULD ATTEND
Sales Order Processing is recommended for anyone who plans to implement, use, maintain, consult, or support Microsoft Dynamics GP. The class is targeted toward administrators, office managers, CEOs, and consultants who need to understand the technical aspects of Sales Order Processing and gain foundational knowledge of the application functionality.

WHAT YOU’LL LEARN
After completing this course, students will be able to:

  • Define module setup options that allow you to customize the system to satisfy your organization’s unique requirements
  • Create Quotes, Sales Orders, Back Orders, Invoices, and Returns
  • Link sales orders to purchase orders
  • Allocate and fulfill item quantities automatically and manually
  • Execute comprehensive reports and use inquiry screens to obtain information that can be used to analyze and improve business processes
  • Understand how the Sales Order Processing module interacts with the Inventory Control and Purchase Order Processing modules

 

Module 1: Overview and Setup
After reviewing the purpose and primary features of Microsoft Dynamics GP Sales Order Processing, this module examines in detail each of the Sales Order Processing setup options, along with each of the pricing structures available. Each of the available order document types are reviewed, including their affect on automated work flow in the life-cycle of an order. This module examines how the behavior of each order document type determines the steps and processes that must take place in the Sales Order Processing cycle. It also explains how to set up process holds, which provide greater control over document flow.

Lessons

  • Primary features of Sales Order Processing
  • Sales Order Processing Setup
  • Master Documents
  • Sales Quote Setup
  • Sales Order Setup
  • Sales Back Order Setup
  • Sales Invoice Setup
  • Sales Return Setup
  • Sales Process Holds Setup
  • Prospect Setup
  • User-Defined Fields Setup
  • Prospect Maintenance
  • Customer Item Setup

 

Module 2: Entering Quotes, Orders, Back Orders, and Returns
This module focuses on the Sales Transaction Entry window, which is the central location for entering customer orders. This module identifies the minimum required information to enter an order and the other important fields and options available for tracking, managing and handling orders. The data entry process involved in entering quotes, orders, back orders, invoices, and returns is also reviewed.

Lessons

  • Sales Batch Entry
  • Sales Document Fields
  • Line Item Entry for each document type
  • Sales Distribution Entry
  • Sales Commission Entry

 

Module 3: Using Special Item Types
This module examines the unique characteristics of “special type” items in Sales Order Processing. This includes entering non-inventoried items, drop-ship items, lot and serial numbered items, and sales kits.

Lessons

  • Non-Inventories Items
  • Drop-Ship Items
  • Serial Numbered Items
  • Lot Numbered Items
  • Sales Kit Options

 

Module 4: Printing, Posting, and Transferring Documents
This module examines the day-to-day printing and posting operations in Sale Order Processing. The various printing and posting options for individual and multiple documents are discussed. This module also focuses on which documents can be transferred to other document types and how the document information is affected.

Lessons

  • Printing Sales Documents
  • Printing Multiple Documents
  • Posting Process
  • Transfer Sales Documents
  • Sales Quantity Status

 

Module 5: Fulfilling, Allocating, and Committing Documents
This module discusses the terms “allocation” and “fulfillment” and determines how these processes can be tailored for a business. This module also examines the Sales Order Commitment process, which allows linking sales order documents to purchase orders in the Purchase Order Processing module.

Lessons

  • Allocating Item Quantities
  • Allocating by Line Item
  • Allocating by Document or Batch
  • Sales Order Fulfillment
  • Sales Hold Processing
  • Creating Purchase Order Commitments
  • Automatic Purchase Order Commitments

 

Module 6: Editing and Removing Records
This module examines the options available for editing, deleting, and voiding sales order documents existing in the system. The inquiry screens and reports are reviewed to assist you in making informed sales decisions and tracking sales data.

Lessons

  • Copying Line Items
  • Creating and Posting Sales Returns
  • Deleting Documents
  • Voiding Sales Documents
  • Removing Sales History
  • Reconciling Sales Information
  • Sales Inquiries and Reports
  • Report Lists

 

Labs

Lab: Overview and Setup
Lab: Entering Quotes, Orders, Back Orders, and Returns
Lab: Printing, Posting, and Transferring Documents
Lab: Fulfilling, Allocating, and Committing Documents
Lab: Editing and Removing Records

Interested in learning more?

Expand

Purchase Order Processing-Training

[Note- Microsoft Dynamics GP – All versions available]

COURSE DESCRIPTION
The Microsoft Dynamics GP Purchase Order Processing course explores the primary features in the Microsoft Dynamics GP purchasing lifecycle, including purchase order setup, purchase order entry, shipment receipts and returns, and shipment invoicing. This course examines the implications of each Purchase Order Processing setup option and how they can be tailored to meet your business requirements.

WHO SHOULD ATTEND
Purchase Order Processing 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 need to understand the technical aspects of purchasing and gain foundational knowledge of the application functionality.

WHAT YOU’LL LEARN

  • After completing this course, students should be able to:
  • Enter Purchase Orders, Receipts, and Returns
  • Enter Drop-Ship and Standard Blanket Purchase Orders
  • Copy item details from an existing Purchase Order
  • Use inquiry screens and reports to extract and analyze appropriate information to maintain and improve business processes
  • Understand how Purchase Order Processing integrates with the Accounts Payable module
  • Enter Landed Costs at the time you enter the receipt of inventory
  • Enter Landed Costs after the items have been received
  • Close the Purchasing module
  • Define set up options for the module that allow you to customize your system to better fit your organization’s unique needs

 

COURSE OUTLINE
Module 1: Overview and Setup
This module introduces you to Purchase Order Processing in Microsoft Dynamics GP by examining the core processes used in each step of the Purchase Order Processing lifecycle. This module helps you understand the default system and user options defined in the Purchase Order Processing Setup window and how they affect Purchase Order Processing transactions, such as purchase order entry, shipment receipts, returns, and invoice entry.

Lessons

  • Features and Benefits
  • Purchase Order Processing Setup
  • User-Defined Fields for PO Receipts
  • Purchasing Tax Schedules
  • Revalue for Cost Variances
  • Buyer Maintenance
  • Landed Costs

Module 2: Entering Purchase Orders
This module examines the processes of entering and printing purchase orders. It also reviews the types of purchase orders available and the steps for processing each order type. This module also examines how to set up a replenishment method to automatically generate purchase orders when inventory items are running low.

Lessons

  • Purchase Order Entry
  • Linking Purchase Orders to Sales Orders
  • Drop-Ship Purchase Orders
  • Blanket Purchase Orders
  • Printing Purchase Orders
  • Automatic Purchase Order Generation

Module 3: Entering Shipments
This module examines the process of receiving purchase order shipments for inventory, non-inventory, and lot/serial numbered items. It also reviews how to apportion landed costs during the receiving process, and how to post receipts to the General Ledger. This module also examines how to define lot and serial number masks that are used when lot/serial numbers are automatically generated during shipment receipt transactions.

Lessons

  • Entering Purchase Order Receipts
  • Shipment line item matching
  • Applying Landed Costs
  • Posting Receipts

Module 4: Entering Invoices and Returns
This module examines the process of entering invoices against purchase orders, including the posting of purchase price variances. This module reviews the affect of invoice entry on other modules that integrate with Purchasing Order Processing, and it examines how to return shipments to a vendor.

Lessons

  • Purchase Invoice Entry
  • Verifying Distributions
  • Posting Process and Cost Variances
  • Returning Purchase Orders

Module 5: Entering and Removing Records
This module examines the options available for editing, deleting, and voiding purchase orders that exist in the system. The available inquiry screens are reviewed, which enable businesses to make informed purchasing decisions and to track purchasing data. This module discusses the process of replenishing inventory quantities based on historical purchasing report information and how to view inventory quantity and cost information by vendor.

Lessons

  • Deleting and Voiding Purchase Orders
  • Editing Purchase Orders
  • Reconciling Purchase Orders
  • Purchase Order Inquiries
  • Purchase Order Reports and Reports Scheduler

Labs

  • Lab: Purchase Order Processing Setup
  • Lab: Entering Purchase Orders
  • Lab: Entering Shipments
  • Lab: Entering Invoices and Returns

 Interested in learning more?

Expand

Payroll-US -Training

[Note-Microsoft Dynamics GP – All versions available]

COURSE DESCRIPTION
This course provides an in-depth view of the extensive functionality contained within the Payroll application. Besides learning the functionality, this course also explains tips and techniques that can help make an implementation successful and gain a more thorough understanding of the Payroll application and its capabilities.

The course covers the setup of the Payroll module. It covers the setup windows that are necessary to complete to start using Payroll and the processing of Payroll checks, including information on using Direct Deposit. It also focuses on the options available to maintain and retrieve key Payroll data. Closing periods, quarters and the year-end is also covered in this course.

WHO SHOULD ATTEND
Customers and partners wanting 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 Payroll. The class is targeted toward data entry clerks, administrators, office managers, CEOs, and consultants who need to understand the technical aspects of Payroll and gain foundational knowledge of the application functionality.

WHAT YOU’LL LEARN

  • Use the Payroll Setup windows to customize the application to their organizational needs.
  • Understand the benefits of using employee classes.
  • Set up tax information for federal, state and local taxes for employees in Payroll.
  • Create pay codes, deduction codes, benefit codes and other employee related information used to calculate Payroll checks.
  • Assign methods to calculate vacation and sick time for employees.
  • Build and calculate checks.
  • Generate and void Payroll checks for employees.
  • Use inquiries to access Payroll information.
  • Create Payroll report options and produce desired reports.
  • Print numerous other Payroll documents such as Advice Slips, 1099Rs and others.
  • Use Direct Deposit instead of generating checks for certain employees.
  • Close periods and quarters in Payroll.
  • Close the Payroll year and prepare the system for the next year.
  • Print W-2 forms for employees.

 

COURSE OUTLINE

Company and Organizational Setup Procedures

  • Features and Benefits
  • Setting Up Payroll
  • Setting Up Organizational Codes
  • Payroll Direct Deposit Setup
  • ACH File Setup
  • ACH Header and Footer Setup
  • Setting Up Payroll Integration to Payables Management

Payroll Records Setup

  • Setting Up Pay Codes and Types
  • Setting Up Pay Codes For Tips
  • Setting Up Shift Codes
  • Setting Up Overtime Rate Manager
  • Setting Up Deductions and Benefits
  • Setting Up A Standard Deduction
  • Setting Up A Garnishment
  • Setting Up Earnings Codes
  • Setting Up Maximum Garnishment Rules
  • Setting Up A Company-Level Deduction Sequence
  • Setting Up Deduction In Arrears
  • Setting Up A Benefit
  • Setting Up Taxes And Compensation Codes
  • Setting Up Workers’ Compensation Codes
  • Setting Up A Local Tax
  • Setting Up State And Federal Unemployment Taxes
  • Setting Up An Unemployment Tax
  • Setting Up Federal And State Tax Identification Numbers
  • Setting Up Employee Classes
  • Setting Up A New Employee Class

Employee Setup

  • Employee Records
  • Employee Additional Information
  • Employee Vacation/Sick Time
  • Employee Tax Maintenance
  • Employee State Tax Maintenance
  • Employee Local Tax Maintenance
  • Employee Quick Assign
  • Employee Pay Code Maintenance
  • Employee Pay Code Options
  • Post-Dated Pay Rates
  • Employee Deduction and Benefit Maintenance
  • Employee Standard Deduction Maintenance
  • Employee Garnishment Deduction Maintenance
  • Deduction Sequence
  • Employee Benefit Maintenance
  • Employee Direct Deposit Maintenance
  • Arrears Transactions
  • Arrears Transactions Activity
  • Delete or Inactivate Employee Records
  • Reactivate Employee Records
  • Delete or Inactivate Payroll Codes
  • Change Employee Records
  • Change Setup Records
  • Employee Maintenance
  • Employee Tax Maintenance
  • Employee Pay Code Maintenance
  • Employee Modifying A Pay Rate

Daily Procedures

  • Activate Post-Dated Pay Rates
  • Payroll Batch Entry
  • Payroll Mass Transaction Entry
  • Payroll Transaction Entry
  • Creating Employee Retroactive Pay Transactions
  • Make A Backup
  • Build Payroll Checks
  • Calculate Checks
  • Make A Backup
  • Print Checks
  • Generate ACH File
  • Mandatory Arrears
  • Void Checks
  • Payroll Manual Check / Adjustment Entry

Inquiries and Reports

  • Retrieve Information
  • Employee Inquiries
  • Payroll Record Inquiries
  • Payroll Reports
  • Payroll Direct Deposit Reports

Payroll Utilities

  • Reconcile
  • Mass Update Employee Records
  • Calculating Net-To-Gross Wages
  • Remove Payroll History
  • Remove Employee Summary Information
  • Remove Inactive Records
  • Remove Year-end Information
  • Remove Distributions
  • Tax Utilities

Period, Quarter and Year-End Procedures

  • Payroll Checklists
  • Period-End Procedures
  • Government Forms and Report

Interested in learning more?

Expand

Human Resources- Training

[Note- Microsoft Dynamics GP – All versions available]

COURSE DESCRIPTION
This comprehensive course provides you with an in-depth view of the extensive functionality contained within the Human Resources application. Besides learning the functionality, you will also learn tips and techniques that can help make an implementation successful, and you will gain a thorough understanding of the HR application and its capabilities.

The course covers the setup of the Human Resources module. It covers Employee maintenance and recordkeeping in Human Resources. It also covers the Applicant functionality found in Human Resources so you can track the necessary information to hire quality employees. The class also discusses the Attendance functionality which can be used to track employee attendance and absences using time codes.

WHO SHOULD ATTEND
The class is targeted toward administrators, implementers, consultants and endusers who need to understand the technical aspects of using Microsoft Dynamics Human Resources and want to gain the ability to manage employee and applicant information.


 

COURSE OUTLINE
Module 1: System and Company Setup
The purpose of this chapter is to give students an understanding of the various setups that need to be completed for Human Resources. The setups will provide the foundation for maintaining employee and applicant data within the Microsoft Dynamics GP Human Resources module.

Lessons

  • Employee Number Setup
  • User Setup
  • Human Resources User Preferences
  • Human Resource Preferences
  • Organizational Structure
  • Benefit Setup

After completing this chapter, students will be able to:

  • Understand the system and user preferences available for Human Resources.
  • Understand the various components within Microsoft Dynamics GP Human Resources that define the organizational structure.
  • Define benefit preferences for FMLA and COBRA and then set up various types of benefits, such as garnishments, health insurance, life insurance, retirement plans and other miscellaneous benefits.

Module 2: Other Human Resources Setup
The setups found in this chapter complete the foundation for the Microsoft Dynamics GP Human Resources module. These employee-related setups include Interviews, Skills, Training and Reviews. In addition, User-defined fields and Extra fields can be used to provide flexibility for the organization and enable them to customize data within Microsoft Dynamics GP.

Lessons

  • Interviews
  • Skills, Skill Sets and Tests Setup
  • Defining the Employee User Defined window
  • Review Policy Setup
  • Creating a Property Item Record

Module 3: Applicants
This chapter defines the features of the Applicant feature that support gathering data about applicants for demographics, Equal Employment Opportunity (EEO), background information, requisitions and queries. The applicant portion of the Microsoft Dynamics GP Human Resources module crosses all companies so that when a person applies for a position, he or she can be assigned to whichever company is necessary. The more an organization knows about an applicant, the better their decision-making ability when it comes time to choose an applicant to hire. The Applicant feature also enables the user to record interview information, score interviews, prepare offer letters, and hire an applicant. Once an applicant is hired through this feature, relevant data is transferred to the Employee record to minimize the time involved when bringing someone new on board.

Lessons

  • Adding a Requisition
  • Adding an Applicant Record
  • Adding an Interview Record
  • Adding an Offer
  • Hiring an Applicant

Module 4: Employee Maintenance
This chapter discusses the importance of employee records. The information entered in these records are used to track the status of an employee and store vital information. Information that can be stored as part of the employee maintenance process includes: I-9 information, additional employee-related information such as birth date and spouse, multiple addresses, HR Status, VETS-100, review data information, dependent information, company property and union information.

Lessons

  • Adding An Employee I-9 Record
  • Creating An Employee Record
  • Changing An Employee’s Position and Creating An Additional Position Record For An Employee
  • Creating Additional information Records
  • Adding An Employee Address Record
  • Adding An Employee Human Resources Record
  • Adding An Employee Contact Record
  • Adding An Employee Dependent Record
  • Property Records
  • Union Records
  • Employee Extra Fields And User-Defined Fields
  • Employee Pay Code Maintenance
  • Pay Steps Maintenance

After completing this chapter, students will be able to:

  • Add an I-9 form and enter the verification data needed to support citizenship or immigration status.
  • Enter an employee record for a new employee and change the employee record to reflect the current employee information.
  • Create an Additional Position for an employee.
  • Enter an employee additional information record for a new employee or modify the record to reflect the current employee information.
  • Create additional address records including phone numbers and Internet information.
  • Set up additional Human Resources information such as ethnicity, gender, Vets-100 and information about the spouse.
  • Create employee contact information in the case of an emergency.
  • Set up employee dependent information to use in the Benefit subsystem.
  • Assign property to an employee.
  • Assign union information to an employee.
  • Enter data for extra fields or for user-defined windows per employee.
  • Assign pay codes to an employee.
  • Assign Pay Step Table to an employee and activate post-dated pay rates.

Module 5: Employee Attendance
The objective of this chapter is to explain how Microsoft Dynamics GP allows for accruing of benefit time through the Microsoft Dynamics GP Human Resources attendance feature. To accrue time using Microsoft Dynamics GP Human Resources, accrual periods, accruals, accrual schedules and time codes must be set up.

Lessons

  • Attendance Setup
  • Employee Maintenance and Summary
  • Attendance Transactions
  • Vacation Planning

After completing this chapter, students will be able to:

  • Set up Attendance including accrual periods, accruals, accrual schedules and time codes to account for benefit time using the attendance feature in Microsoft Dynamics GP Human Resources.
  • Assign time codes to employees using the Employee Attendance Maintenance window.
  • View employee time used and time available using the Employee Attendance Summary window.
  • Use the Attendance Transaction Entry window to enter transactions for Hours Used and for Hours Available adjustments.
  • Create Absence Entry records to update the vacation calendar for planned absences in the future.

Module 6: Employee Benefits
This chapter focuses on assigning various benefits, such as health insurance, life insurance, retirement plans and other miscellaneous benefits. These benefits can be entered through the Microsoft Dynamics GP Human Resources module, which also provides the ability to view an overview of each employee’s benefit enrollment, a benefit summary, the tracking of history and the ability to provide a customized total compensation report.
In addition, FMLA and COBRA is addressed, as well as the ability to track FMLA leave and COBRA enrollments. The organization can also choose to record premiums for benefits that are due and then record payments as they are received.

Lessons

  • Benefit Enrollment
  • Deduction and Benefit Records
  • Family and Medical Leave Act (FMLA)
  • COBRA
  • Benefit Summary and History
  • Total Compensation

After completing this chapter, students will be able to:

  • Enroll employees in health, life, retirement and other miscellaneous benefits.
  • Initiate FLMA leave and track insurance premiums due and those paid.
  • Initiate COBRA coverage by notifying an employee of his or her rights, recording the election and tracking the monthly payments made.
  • Use the Benefits Summary window to view benefits and to view benefit history where historical records are maintained.
  • Use the Total Compensation/Benefit Summary window to gather data to provide a report to employees about the value of their benefits.

Module 7: Employee Assets and Development
This chapter discusses how to assign the education, skills, tests and training codes to employees completing the cycle of Employee Assets. As indicated when setting up the codes for these various assets, it is increasingly important for employers to track relevant information about their employees and their endeavors to further educate themselves.

Lessons

  • Employee Education
  • Employee Skills and Test
  • Employee Orientation
  • Employee Training

After completing this chapter, students will be able to:

  • Assign education records to an employee.
  • Assign skills, skill sets and test records to an employee.
  • Assign an orientation checklist to an employee and maintain the progress of the orientation process.
  • Learn to add or remove individual or groups of employees to a training class.

Module 8: Employee Performance
This chapter focuses on tracking employee discipline, grievances, reviews and work-related injury and illness records. The system provides flexibility in how to document disciplinary actions and reviews providing multiple ways to document these processes. For grievances and injury and illness records, the processes are defined by the organization and maintenance is easy to accomplish.

Lessons

  • Employee Discipline
  • Employee Grievances
  • Employee Reviews
  • Employee Injury and Illness

After completing this chapter, students will be able to:

  • Create records for employee disciplinary actions using either a points system or progressive discipline.
  • Record an employee grievance and record the steps as the follow-up to the grievance that occurs.
  • Add employee review records with written information and numerical scoring.
  • Record critical information for meeting OSHA and organizational safety standards about job-related injuries and illnesses enabling the generation of OSHA reports and logs.

Module 9: Employee History
This chapter focuses on employee earnings history, position history, transfers and terminations. Microsoft Dynamics GP provides the flexibility to view earnings history through the Microsoft Dynamics GP Human Resources module and to add, view and change position history records.
In addition, the processing of employee transfer requests is supported in the Microsoft Dynamics GP Human Resources module. Multiple requests can be recorded along with any applicable notes that are required.
Finally when an employee is scheduled to leave employment, Microsoft Dynamics GP provides a termination checklist to ensure all the appropriate steps are taken and also provides the ability to record information from an exit interview.

Lessons

  • Employee Earnings and Position History
  • Employee Transfers
  • Employee Termination

Module 10: Inquiries, Reports and Organization Explorer
This chapter focuses on how Microsoft Dynamics GP allows information to be viewed and printed using Inquiry windows and Reports. The Inquiry windows allow the user to view information about employees, their benefits, and other historical data.
The Reports window allows the user to create a report option once and print it again at any time without having to redefine the option. The reports printed, as a result, are up-to-date and can be printed quickly and easily at any time.

Lessons

  • Inquiries
  • Reports
  • Organization Explorer

Lab : Reports
After completing this chapter, students will be able to:

  • View and print information from various inquiry windows available using Microsoft Dynamics GP Human Resources.
  • Learn to create report options, determine report destination and formats and print reports.
  • Use Organization Explorer to view an organizational chart, create or change the number of vacancies and create requisitions.

Module 11: Utilities
Microsoft Dynamics GP Human Resources provides various Utilities and Procedures to assist the user with tasks. Human Resources provides a way to ensure data integrity with the use of a Reconcile function. In addition, it provides the ability to archive employee and applicant records for those that are no longer active in an effort to maximize the efficiency of the system.
This chapter also explains the use of tools such as Compensation Management and Desk Accessories that assist the user in planning activities. Compensation Management helps to analyze and update employee compensation. Desk Accessories provides the means to update To Do Lists, create records of contact information and also provide a Notepad to keep notes in one place.

Lessons

  • Reconcile Feature
  • Archive Employee and Applicant Records
  • Compensation Management
  • Business Contact Information
  • To Do List entries

Module 12: Appendix: Job Aids
This appendix provides high-level checklists, reports options and a quiz for the Human Resources module in Microsoft Dynamics GP.

Lessons

  • Benefit Summary
  • Check Register
  • Company Benefits List
  • Company Local Taxes List
  • Deduction In Arrears Build Report
  • Department Wage and Hour Report
  • Detailed Employee List
  • Direct Deposit Detail List
  • Distribution Breakdown History Report
  • Earnings Code List
  • Earnings Register
  • Employee Address List
  • Employee Class List
  • Employee Lists (Sorted numerous ways)
  • Employee Pay History Report
  • Employees Without Pay Codes List
  • FICA Wage Report
  • FUTA Summary
  • Organization Reports
  • Overtime Rate Adjustment Report
  • Payroll Check History Report
  • Payroll Check History Report
  • Payroll Transaction History Report
  • Payroll Vendor Setup
  • Personnel List
  • Position Summary
  • Posting Accounts Report
  • Quarterly 941 Preparation Report
  • State Wage Report
  • Supervisor Codes List
  • Unemployment Rates List
  • Vacation/Sick Time Accrual Register
  • Workers’ Compensation Codes List
  • Human Resources Quiz

Interested in learning more?

Expand

Project Series- Training

[Note- Microsoft Dynamics GP – All versions available]

COURSE DESCRIPTION
This Microsoft Dynamics GP Project Series course explores project management from an accounting perspective. This course teaches you how to create Contracts, Projects, Cost Categories, and budgets. You also learn how to enter costs for projects and perform both Time & Materials and Progress Billing as well as revenue recognition. During this class, we discuss nearly every feature in Project Accounting.

WHO SHOULD ATTEND
This course is intended for people who would like to learn features and procedures required to effectively use Microsoft Dynamics GP Project Accounting. Project Accounting 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, and consultants who need to understand the technical aspects of Project Accounting and gain knowledge of the application functionality.

WHAT YOU’LL LEARN

  • Configure Contracts, Projects, and Cost Categories.
  • Set up and configure Billing Cycles to facilitate automated billing.
  • Create and assign rate tables to manage cost and billing rates.
  • Create and use Contract and Project Templates.
  • Use reports and inquiry windows in Project Accounting to extract whatever project related information is applicable to your business.
  • Perform maintenance on Project Accounting documents and maintenance records such as customers, employees, and vendors.
  • Perform all Project Accounting related data entry functions including customer invoicing and cost transactions (Timesheets, Employee Expenses, etc.).

COURSE OUTLINE

Module 1: Overview and System Setup

  • Product Relationships
  • Key Concepts
  • User Security
  • User Project Accounting Setup
  • Posting Setup
  • Posting Accounts Setup
  • Source Document Setup
  • Audit Trail Codes Setup

Module 2: Project Accounting Setup

  • Project Accounting Setup
  • Timesheet Setup
  • Equipment Log Setup
  • Miscellaneous Log Setup
  • Inventory Transfer Setup
  • Employee Expense Setup
  • Purchasing Setup
  • Billing Setup
  • Unit of Measure Schedule Setup

Module 3: Configuring Master Records

  • Customer Class Setup
  • Customer Maintenance
  • Employee Class Setup
  • Labor Overhead Calculation
  • Employee Maintenance
  • Project Access List
  • Equipment Class Setup
  • Equipment Maintenance
  • Miscellaneous Class Setup
  • Miscellaneous Maintenance
  • Vendor Class Setup
  • Vendor Maintenance
  • Cost Category Class Setup
  • Cost Category Maintenance
  • Position Rate Table Maintenance
  • Employee Rate Table Maintenance
  • Equipment Rate Table Maintenance
  • Billing Cycle Maintenance
  • Revenue Recognition Cycle Maintenance
  • Fee Maintenance

Module 4: Contracts and Projects

  • Contract Class Setup
  • Contract Maintenance
  • Project Class Setup
  • Project Maintenance
  • Template Maintenance
  • Project Template Information
  • Change Order Entry

Module 5: Transaction Entry

  • Transaction Entry Overview
  • Transaction Entry
  • Enter Timesheets
  • Timesheet Line Item Information
  • Enter Employee Expenses
  • Employee Expense Line Item Information
  • Enter Equipment Logs
  • Equipment Log Line Item Information
  • Enter Miscellaneous Logs
  • Miscellaneous Log Line Item Information

Module 6: Purchasing and Inventory

  • Enter Purchase Orders
  • Purchase Order Line Item Information
  • Purchase Order Totals
  • Drop-Ship Purchase Orders
  • Save and Print the Purchase Order
  • Enter Purchase Receivings
  • Purchase Receivings Line Item Information
  • Purchase Receivings Totals
  • Verify Posting Accounts and Landed Cost
  • Enter Purchase Invoice Transactions
  • Purchase Invoice Line Item Information
  • Edit Purchase Order Status
  • Returns From Project Entry
  • Enter Inventory Transfers
  • Inventory Transfer Line Item Information

Module 7: Billing and Revenue Recognition

  • Enter Billing Invoices
  • Billing Invoice Detail Information
  • Time and Materials Billing
  • Progress Billing
  • Fee Billing
  • Process Billing Cycle Batches
  • Cash Receipts
  • Enter Revenue Recognition Transactions
  • Revenue Recognition Cycle Batch Processing
  • Closing a Project

Module 8: Maintaining Records

  • Project Transaction Adjustment
  • Void Posted Transactions
  • Database Maintenance
  • SmartList Objects
  • Mass Contract Delete
  • Remove Cost History
  • Remove Billing History
  • Create Combined History
  • Project Accounting Recreate Periodic
  • Reconcile Inventory Quantities
  • Aging Process
  • Aging WIP Process
  • Paid Transaction Removal
  • Close Fiscal Period

Interested in learning more?

Expand

Manufacturing Applications- Training

[Note-Microsoft Dynamics GP – All versions available]

COURSE DESCRIPTION
This instructor-led course provides students with the knowledge and skills to explain the basic concepts and general functions of Microsoft Dynamics GP and to use central application functionality for the most common business tasks.

WHO SHOULD ATTEND
The Microsoft Dynamics GP Manufacturing course on the Microsoft Dynamics GP Manufacturing Series helps prepare students to set up and begin to use Manufacturing. This comprehensive course will provide you with an in-depth view of the extensive functionality contained within the Microsoft Dynamics GP Manufacturing Series. Besides learning the functionality, you will also learn tips and techniques that will help make your implementation successful, and you will gain a thorough understanding of the Microsoft Dynamics GP Manufacturing Application and its capabilities.

WHAT YOU’LL LEARN

  • Effectively set up the Manufacturing system options that apply to your production process and organizational needs.
  • Explain how the Microsoft Dynamics GP distribution and financial modules are integrated with Manufacturing.
  • Properly create component and manufactured items.
  • Properly structure Bills of Materials and Routings to fit specific manufacturing environments.
  • Create and schedule Manufacturing Orders for your production needs.
  • Make the necessary setups to use Outsourcing.
  • Understand the relationship between Manufacturing and Sales Order Processing.
  • Order, allocate, and fulfill manufactured items using Sales Order Processing.
  • Properly set up the Sales Configurator.
  • Understand basic MRP calculations and how to work with the outputs of MRP.
  • Plan production using the Sales Forecasting, MPS, MRP and CRP modules.
  • Use the Manufacturing report options to produce desired reports.

 

COURSE OVERVIEW

Module Integration and Process Overview

The goal of this chapter is to provide students with a list of the Manufacturing modules and how they integrate with the Distribution modules

Prerequisites – Inventory Control

  • Setup Procedures
  • Item Classes
  • Item Creation
  • Posting Inventory Transactions and Transfers
  • Tracing Serial and Lot Transactions

Prerequisites – Bill of Materials

  • Setup Procedures
  • BOM Creation and Maintenance
  • BOM Mass Update
  • BOM Inquiries and Reports

Prerequisites – Manufacturing Facility

  • Manufacturing Calendar
  • Labor Code/Machine OH Defaults
  • Labor Codes
  • Machines
  • Work Centers

Prerequisites – Routings

  • Setup Procedures
  • Routing Creation
  • Operation Code Setup
  • Pointer Routing Creation
  • Routing Copy
  • Routing Deletion
  • Other Routing Activity
  • Routing Inquiry
  • BOM Routing Link

Execution – Standard Costing

  • Setup Procedures
  • Managing Standards with Pending Costs
  • Managing Standard with Proposed Costs
  • Other Costing Considerations

Execution – Manufacturing Order Processing

  • Setup Procedure
  • MO Creation
  • Picklist
  • Manufacturing Routing
  • Component Allocation
  • Material Shortages
  • MO Release
  • MO Status Changes
  • Printing an MO
  • Component Issue
  • WIP Reporting
  • MO Receipt
  • MO Close
  • Scheduling
  • Quick MO
  • MO Inquiries

Execution – Outsourcing

  • Setup Procedures
  • Manufacturing Order Entry with Outsourcing
  • Purchase Orders and Shipments for Outsourcing
  • Receiving Outsourced Purchase Orders
  • Invoicing Outsourced Purchase Orders
  • Receiving an MO That Uses Outsourcing
  • Outsourcing Inquires

Execution – Sales Order Processing

  • Setup Procedures
  • Entering Sales Orders
  • Linking and Unlinking Sales Order Line Items to MOs
  • Transferring Document Types
  • Allocating Sales Order Quantities
  • Fulfilling Sales Order Quantities
  • Sales Order Extras

Execution – Sales Configurator

  • Setup Procedures
  • Super Bill of Material
  • Option Categories
  • Option Promotions
  • Configuring a Bill of Material
  • Configured Sales Order Options View

Planning – Material Requirements Planning

  • MRP Calculations
  • Setup Procedures
  • MRP Regeneration
  • Schedule of MRP Suggested Purchase Orders
  • Schedule of MRP Suggested Manufacturing Orders
  • Key Windows When Using MRP
  • Exception Messages
  • MRP Inquiries
  • Calculating Manufacturing Lead Times
  • MRP Quantity Definitions

Planning – Forecasting and Master Production Scheduling

  • Forecast Consumption
  • Forecast Entry
  • Master Production Scheduling
  • Forecasting Inquiry
  • Planning – Capacity Requirements Planning
  • Setup Procedures
  • Inquiry

Interested in learning more?

Expand

Report Writer-Training

[Note-Microsoft Dynamics GP – All versions available]

WHO SHOULD ATTEND
Microsoft Dynamics GP Report Writer training is recommended for people who plan to implement, configure, consult, or support Microsoft Dynamics GP and want to modify existing reports or create their own custom reports using Report Writer. The training is targeted toward application administrators, implementers, and end-users of the Report Writer application who need to understand the technical aspects of Report Writer and gain foundational knowledge of the application functionality and capabilities.

WHAT YOU’LL LEARN

At Training Material Completion

After completing this training, individuals should be able to:

  • Determine the setup configuration they want to use for Report Writer
  • Identify where modified reports are stored and how to limit access to certain reports using Microsoft Dynamics GP security
  • Create user-defined sorts and restrictions so information appears in the order desired, and only the information you want appears on a report
  • Understand general report layout functionality
  • Place text, report fields, graphics, and other items on a report layout
  • Modify existing reports to better fit their reporting needs
  • Design custom reports to access important application data
  • Identify the sections of a report and how to add additional headers & footers
  • Link tables together so reports can be developed using multiple data tables
  • Create user defined links for related tables that have common keys
  • Create user-defined fields by using calculated and conditional expressions
  • Understand how Field Options can be used to generate needed information
  • Import reports between report dictionaries using the Customization Maintenance window functionality

Interested in learning more?

Expand

Microsoft FRx Report Design- Training

[Note-Dynamics GP – All versions available]

COURSE DESCRIPTION

The Report Design Essentials – I, II course covers the basic report design skills needed to create, maintain and distribute presentation quality reports using Microsoft Business Solutions for Analytics – FRx. It also includes coverage of additional functionality designed to help users create new reports and distribute and analyze a company’s financial information. Students will learn about basic foundational skills, complex calculations, drag and drop reorganization, rounding adjustments and account sets.

The Report Design Essentials II course builds on the basic report design skills learned in Report Design Essentials I. Using Microsoft Business Solutions for Analytics-FRx you learn advanced report design including linking to external worksheet data, linking row formats, multi company consolidations, currency translation reporting and cash flow. A combination of instructor guided exercises and practice tutorials allow students to master their report design skills.

A thorough understanding of these topics allows users to easily design and maintain standard and essential reports that organizations need to understand their financial position. Students will learn how to use templates or create customized report designs as well as how to set up self-maintaining reports that will dynamically include newly added GL accounts and newly closed periods. This course also teaches students to generate and electronically distribute reports using their in-house e-mail system.

WHAT YOU’LL LEARN

  • Understand basic navigation and report creation in FRx
  • Drill down, analyze, print and export from the FRx Drilldown Viewer
  • Efficiently create and distribute many financial reports including:
  • Trial balances
  • Balance sheets
  • Transaction detail reporting
  • Trended reports
  • Side-by-side presentation
  • Actual vs. Budget
  • Rolling quarters
  • Know some tips and tricks for increasing speed and accuracy of month-end close
  • Create presentation quality reports
  • Understand security settings within FRx
  • Understand many ways to improve your company’s financial reporting package
  • Have a renewed understanding of basic FRx report design concepts
  • Explore ways to efficiently create and distribute many financial reports including: Linking to external worksheet data
  • Statements of Cash Flow
  • Using full accounts or multiple segments in reports
  • Allocation reporting
  • Linking Row Formats
  • Relational reporting
  • Multi company consolidations
  • Currency Translation
  • OLAP (Online Analytical Processing) output
  • XBRL (eXtensible Business Reporting Language) output
  • Advanced formatting tips and tricks

COURSE OUTLINE

Overview and Introduction

  • About FRx Software products
  • Terminology
  • Demo company account structure
  • Sample report demonstration

Creating a Trial Balance

  • Using the “Add Rows from Chart of Accounts” feature to automatically populate the row format with account numbers and descriptions
  • Using wildcards or ranges to summarize data
  • Using the Normal Balance field and how C’s affect the account presentation
  • Using underscores and totals
  • Using Header Codes to automatically update column headers each month
  • Use of the BASE Period and Year in the Column Layout to ease maintenance
  • Setting the Report Date to an option that automatically progress through the year for ease of report maintenance
  • Defining a detail level in the catalog
  • Introduce the default Formatting options
  • Using existing building blocks to speed setup time
  • Using the View, Subtotals function in the DrillDown Viewer

Creating an Income Statement

  • Using the Add Rows from Chart of Accounts function to quickly create a basic template
  • How proper placement of C’s in the Account Balance column of the Row Format will flip the balance of an account for presentation
  • How the presentation of the accounts included determine the math for related TOT or CAL formulas
  • How to use a Special Format Mask on a row formula to determine display
  • Using system defined or custom fonts for emphasis
  • Working with rounding options

Reporting Trees

  • Characters used with Add Reporting Units
  • Segment hierarchy
  • Defining a segment range
  • Adding custom units to a tree
  • The default Reporting Tree
  • Relating Reporting Trees to Row Formats
  • How trees define multiple reports in a single catalog
  • Using check rows to insure all accounts are included
  • Rounding options and how they relate to calculations
  • How to relate description or underscore rows to other rows
  • Exception reports and how they work

Review

  • Review basic report design concepts

More on Reporting Trees

  • How to create a Column Layout based on current and prior results
  • Defining unit hierarchy when building a Reporting Tree
  • How to split a segment to create a virtual segment in trees
  • Adding custom units to a tree
  • Generating specific tree units
  • Using header and footer codes in the Catalog

Transaction Detail Reporting

  • Creating a transaction detail Column Layout
  • Restricting a column to either debit or credit activity
  • Restricting a column to display beginning balances
  • Generating a catalog to the Excel output option
  • How report presentation varies between Excel and the DrillDown Viewer

What we Know

  • Review basic report design concepts

Using the DrillDown Viewer

  • Printing reports from the DrillDown Viewer
  • Using the Send function
  • Export options in the DrillDown Viewer

Working with Specification Sets

  • Understand the specification set (.F32) in the Company Information settings
  • Learn to “save as” between spec sets
  • Learn to export and import between spec sets

Practice

  • Practice the report design concepts learned thus far in class

Balance Sheets

  • Account Sets
  • Presentation of Balance Sheet accounts (using C in the Normal Balance)
  • Defining Year to Date Income in the Balance Sheet
  • Using the XD code to suppress drill down on specific rows
  • Using the Rounding Adjustments function

Income Statement Variations

  • Trended Income Statement design
  • Using conditional statements in the Column Layout
  • Using Account Modifiers in the Row Format to override the Column Layout
  • Variance reporting Over/(Under) and Favorable/(Unfavorable) methods
  • Sort commands

Practice

  • Practice the report design concepts learned so far in class

Side by Side Reporting

  • Using Account Filters in the Column Layout
  • Restricting columns to specific Tree Units in the Column Layout

Report Distribution

  • Naming conventions
  • Chain to Catalog ID functionality
  • Report archive options
  • E-mail distribution methods available in FRx
  • WebPort distribution
  • Report Manager Demonstration

What’s Wrong?

  • Importing a .tdb file
  • Troubleshooting a report

Troubleshooting

  • Rebuilding the GL Index (.G32 file)
  • Compacting the FRx Databases
  • Getting additional help
  • Report Design Guidelines

Advanced Concepts

  • Adding an FRx report to Microsoft Outlook
  • Adding FRx report information to Excel and Microsoft Word documents
  • Overview of the Report Design Essentials II training class

Concept Overview

  • Basic Row Format review
  • Working with TOTs and CALs in the Row Format
  • How C’s affect TOT and CAL rows and why to use them
  • Defining a sort in the Row Format
  • Relating rows to other rows
  • Basic Column Layout review
  • Defining a favorable/(unfavorable) variance Column Layout
  • Working with BASE periods and years in the Column Layout
  • Using “Add Reporting Units from Chart of Accounts” to build a Reporting Tree
  • Using the split function to isolate a single account mask character
  • Creating a new Reporting Catalog
  • Defining report headers and footers
  • Defining report headers and footers

Linking to External Worksheets

  • Referencing external worksheet data
  • Optional row modifiers
  • Determining the period of data to be reported on
  • Using the combined GL+Worksheet link in the Row Format
  • Calculation priority with working with intersecting row and column calculations
  • Adding an external worksheet link to the Row Format
  • Proper syntax in combined vs. separate linking
  • Using the optional row modifiers /CPO and /RPO when referencing worksheet data
  • Designing Column Layouts that report on either/or data (i.e. either Actual or Budget) depending on the report date

Gross Profit per Unit – Practice

  • Defining the GL+Worksheet link
  • Working with the /CPO and /RPO row modifiers
  • Using account and book code modif
  • Advanced calculations and non-printing rows

Full Account Code and Multiple Segments

  • Defining a fully qualified account in the Row Format
  • How a full account in the Row Format affects units in a Reporting Tree
  • Defining a range of periods in the Column Layout
  • Using conditional dates in the Column Layout
  • Using a range in a calculated column in the Column Layout

Defining Departments in the Row Format – Practice

  • Defining the Row Format on the Department segment
  • Defining a Reporting Tree that recognizes the Department in the Row Format
  • Using Account Filters in the Column Layout

Statements of Cash Flow

  • Using “C” in the normal balance to properly state sources and uses of cash
  • Using the beginning balance and year to date account modifiers
  • Defining a non-printing check row
  • Using specific placement calculations in the Row Format
  • Designing Column Layouts that display the changes in activity for the time frame being reported on
  • Defining calculation priority for intersecting row and column calculations

FASB Style Statement of Cash Flow – Review

  • Modifying an existing report design
  • Using a combined GL+Worksheet link
  • Using the /RPO row modifier
  • Using non-printing check rows to validate report accuracy

Allocations

  • Using specific column placement in Row Format calculation
  • Column G restrictions in the Row Format
  • Using Book Code modifiers in the Row Format
  • How to work with full accounts in the Row Format when using a Reporting Tree
  • Suppressing data from rolling up in the Reporting Tree
  • Using multiple GL Links in the Row Format and Reporting Tree
  • Presentation of external worksheet data in calculated columns
  • Advanced calculations in the Column Layout
  • Advanced formatting

Modified Allocation of Corporate Expenses – Practice

  • Modifying existing building blocks
  • Working with the Combined GL+Worksheet link
  • Using WKS type columns in the Column Layout
  • Using non-printing rows and specific column placement calculations in the Row Format
  • Proper catalog definition when linking to external worksheet data

Row Linking

  • Adding a Row Format link to a Row Format
  • Using text labels for row codes
  • Defining a Reporting Tree that relates to multiple Row Formats
  • Advanced formatting concepts
  • How rounding options work with Row Linking

Row Linking Income Statement – Practice

  • Linking to another Row Format
  • Defining a Reporting Tree that can access multiple Row Formats
  • Using the BASE+ concept in the Column Layout
  • Rounding options when using Row Linking

Review

  • Concept Review

Relational Reporting

  • Defining CBR (Base) rows in the Row Format
  • Defining Column Layout calculations that work with CBR in the Row Format
  • Suppressing CBR in detail reports

Multiple Base Row Definitions and Using Statistical Information as a Base Row – Practice

  • Defining the CBR or Base Row
  • Using Reporting Unit restrictions in the Row Format vs. full account codes to restrict the data being reported on
  • Using Reporting Unit restrictions in the Column Layout vs. Account Filters to restrict the data being reported on

Additional Formatting Concepts

  • IF/THEN/ELSE calculations in the Row Format
  • Defining effective dates in the catalog
  • Using column Z (Additional Text) in the Reporting Tree
  • Working with Microsoft Excel or Microsoft Word and FRx
  • Defining International Formats

Consolidations

  • Overview of multiple company consolidations in FRx
  • How to format amounts
  • Assigning an international format to a report
  • When is a Reporting Tree required
  • Side-by-side (consolidating) Column Layout design
  • Linking to external worksheet data

OLAP Output

  • FRx and OLAP
  • Microsoft Local Cubes
  • Microsoft Server Cubes
  • Excel Pivot Chart and Excel Pivot Table output options
  • Terminology in OLAP and FRx

XBRL

  • XBRL Overview
  • Adding an XBRL link and related taxonomy file
  • Assigning XBRL tags
  • The XBRL Instance Document output option

Currency Translation

  • Using an external worksheet link to pull in translation rates
  • Adding CTA (cumulative translation adjustment) to the Row Format
  • Using column restrictions in the Column Layout to define formatting
  • Defining the DAX rates path
  • Activating DAX in the catalog and Column Layout
  • Assigning currency conversion format codes and related rate IDs

Interested in learning more?

Expand