Customize General Ledger posting settings.

Identify how data flows through the General Ledger Work, Open, and History Tables.

Maintain records easily and efficiently, utilizing a variety of functions.

Troubleshoot your General Ledger data.

Create and maintain budgets using Microsoft Excel - based Budgeting.

Configure and use Organizational Structures to apply account level security.

Setup Intercompany to automate intercom any transactions.

Use Inquiries, Reports, and SmartList to easily access and customize financial information to meet your company's needs.

Maximize easily customized reporting through Smartlist.

Perform the period-end and year-end closing procedures.

Financial Series I course or equivalent working experience with Microsoft Dynamics GP

General Ledger Setup

Account Categories

Posting Setup

Fixed Allocation Account Setup

Variable Allocation Accounts

Allocation Account Alternatives

Activate batch approval process

Enter and post journal entry batch

Set up a Fixed Allocation Account

Enter and post transaction for allocation account

Perform inquiry to verify allocation

Set up a Variable Allocation Account

Enter and post transaction for allocation account

Perform inquiry to verify allocation

Create fixed allocation account

Create posting account

Enter and post transaction

Enter Clearing Entry

Perform inquiry to verify entries

Set up the basic information for General Ledger.

Customize Account Categories to meet the needs of your company.

Configure Posting Setup for General Ledger.

Set up and use Fixed Allocation accounts to distribute percentages of a single transaction among several distribution accounts.

Set up and use Variable Allocation accounts to distribute percentages of a single transaction among several distribution accounts based on the relative balances of other posting or unit accounts.

Use Clearing Entries in combination with variable allocation accounts to track the details of the allocation in General Ledger.

Integration

General Ledger Document Status

Transaction Flow

Source Document Setup

Audit Trail Codes Setup

Tracing Transactions

Enter and post accrual transaction

Use zoom to verify transaction reversal

Understand how data flows from Work to Open to History tables.

Set up Source Document IDs.

Set up Audit Trail Codes.

Trace transactions using Zooms.

Multidimensional Analysis Overview

Setting up Analysis Groups and Codes

Assigning Analysis Groups to Accounts

Entering Transactions with Multidimensional Information

Performing Multidimensional Analysis Inquiry

Microsoft Excel-Based Budgeting Overview

Creating a Budget with the Budget Wizard

Exporting and Importing Budgets

Intercompany Processing Overview

Defining Intercompany Relationships

Entering General Ledger Intercompany Transactions

Post Intercompany Transactions in Destination Companies

View the Intercompany Transaction in Inquiry

Organizational Structures Overview

Define Components of the Organization

Define Organizational Relationships

Assign User Classes to the Organizational Structure

Assign Users to the Organizational Structure

Assign a Range of Accounts to the Organizational Structure

Assign an Individual Account to the Organizational Structure

Activate Account Security

Create analysis group

Create analysis codes

Assign analysis group to accounts

Enter and post transaction using Multidimensional Analysis

Perform inquiry on analysis information

Create a budget using the Budget Wizard for Microsoft Excel

Update existing budget in Microsoft Excel

Import the budget into Microsoft Dynamics GP

Create intercompany posting accounts

Enter and post an intercompany transaction

Post intercompany transaction in destination company

Set up a company¢s organizational structure

Set up the organization tree relationships

Assign users to the organizational structure

Assign Account Level Security

Test the Account Level Security

Use Multidimensional Analysis to track additional information on account transactions.

Use Microsoft Dynamics GP Budget for Microsoft Excel to create budgets and import or export into Microsoft Dynamics GP.

Use Intercompany transactions to record transactions that involve two or more companies.

Set up and use Organizational Structures.

Correcting Transactions

Posting to History

Changing and Deleting Posting and Unit Accounts

Changing and Deleting Allocation Accounts

Remove History

Verify setting for posting to history

Post adjusting entries

Post journal entry

Post correcting entry

Use inquiry to verify entries are correct

Correct posted entries.

Post transactions to History.

Change and delete records.

Remove General Ledger history.

Inquiries

SmartList

Use Budget vs. Actual Inquiry window

Drill down to source document

Create SmartList query

Save query to Favorites

Export query to Microsoft Excel

Create SmartList query

Save query to Favorites

Create restriction for default query

Drill down to original transaction

Perform Summary and Detailed inquiries for current and historical accounts.

Perform inquiries on a specific journal entry.

Perform inquiries on budget information.

Use SmartList to perform queries on General Ledger data.

Creating Report Options

Creating and Printing Report Groups

Creating and Printing Combined Groups

Cross Reference Reports

Trial Balance Reports

Enter and post journal entry

Create a Cross Reference Report by Audit Trail Code

Determine additional ways to get similar information

Create a Detailed Trial Balance Report

Analyze report totals and reasons for incorrect totals

Print a cross-reference report

Determine corrective action to complete reconciliation

Create report options.

Create and print report groups.

Create and print combined report groups.

Print Cross-Reference reports.

Print a Trial Balance Report.

Period-end Closing Checklist

Printing Financial Statements and Reports

Consolidating a Period

Closing the Fiscal Period

Verify all transactions have been posted for the period

Print financial statements

Print Detailed Trial Balance

Close the Fiscal Period

Complete the processes that are performed at the end of an accounting period.

Consolidate periods and be aware of the effects of performing the consolidation process.

Use the Mass Close option to close specific transaction origin types for a period.

Overview

Year-end Closing Checklist

Post Adjusting Entries

Verify Posting Type

Year-end Closing

Balance Sheet Accounts Set up as Profit and Loss Accounts

Perform year-end closing routines in all other modules

Verify all final adjustments have been posted

Print an Account List

Perform File Maintenance for the Financial Series

Print the General Ledger Summary Trial Balance report

Print Financial Statements

Set up a new fiscal year

Close the fiscal year

Print Detailed Trial Balance and Financial Statements

Close all Fiscal Periods

Complete the steps necessary to close a year in General Ledger.

Set up a special period for posting adjusting entries.

Set up posting for the closing entry to Divisional Retained Earnings accounts.

Correct the situation where an account had the wrong posting type when the year end closing was performed.

Posting Interruptions

Automated Fixes

Batch Recovery

Reconcile

One-sided Entries

Year-end Closing Interruption

Commonly Asked Questions

Modify fiscal year starting and ending dates

Reconcile fiscal years

Verify account balances

Enable Posting Numbers

Reconcile posting numbers

Properly recover data after a posting interruption.

Use the Automated Fixes on Customer Source to correct common problems.

Recover a batch that has become "stuck" in the system.

Reconcile General Ledger account information.

Create a "one-sided" entry to correct an error that occurred because of a posting interruption.

Customize General Ledger posting settings

Identify Work, Open, and History tables

Use fixed and variable allocation accounts to distribute amounts to breakdown accounts during transaction entry

Post transactions to a historical year and automatically adjust the balance of the retained earnings account or the beginning balance brought forward for an account

Use the inquiry windows to view open, history, or net change activity for an account

Use SmartList to access accounting data and export to Microsoft Word or Microsoft Excel

Print cross reference reports to research transactions by various criteria

Prevent transactions from being posted to a specific accounting period by marking it as closed

Perform the year end closing process and retain the ability to post adjusting entries to the most recent historical year

Create budgets in Microsoft Dynamics GP, export or import from Microsoft Excel

Use Organizational structures to define the components of your organization and their relationship

Record intercompany transactions that occur in one company and will create transactions in another company's General Ledger

How Smart Tags work

Smart Tag Benefits

Understand how Smart Tags work.

Recognize the ways Smart Tags can make your business more productive.

Financial Series Tools

Purchase Series Tools

Sales Series Tools

Payroll Series Tools

Inventory Tools

System tools

Tools Available Separately

Related Service Offerings

Understand the tools that are available in the Professional Service Tools Library and how they can be used in your organization.