Course 8829A:

Cash Manager in Microsoft Dynamics SL 7.0

Length:1 Days
Published:August 01, 2007
Language(s):English
Audience(s):Information Workers
Level:200
Technology:Microsoft Dynamics SL 7.0
Type:Course
Delivery Method:Instructor-led (classroom)
About this Course
This one-day course explores the features and benefits of the Microsoft Dynamics SL Cash Manager module. Students discuss how to classify transactions by account type, view cash balances, reconcile bank accounts, and project cash flows.
Understanding these topics allows students to access current cash balance information instantly while entering transactions, which may help with tracking what is in the bank on a daily basis. The course also includes: transfering funds between different cash accounts, managing money effectively while accurately displaying critical information at a moment's notice, reconciling bank statements according to schedule and business demands, and assembling daily cash balances from subsidiary databases into a "consolidated" database, so cash account balances for the entire organization are available to view in one application.
Students reconcile at the check/deposit level and enter transactions that affect cash but are not captured in other Microsoft Dynamics SL modules, such as bank service charges, wire transfers, or other cash transaction types. This is an essential course for all end-users, consultants, and implementers who want to learn about this core module of the Microsoft Dynamics SL Financial system.
Classroom training provides in-depth learning via hands-on interaction. Through demonstrations, presentations, and classroom activities, students can receive hands-on experience with instruction from our certified staff and increase productivity and efficiency by learning tips and tricks from product specialists.
Audience Profile
Cash Manager training is recommended for anyone who plans to implement, use, maintain, consult, or support Microsoft Dynamics SL. The course is targeted toward data entry clerks, administrators, office managers, CEOs, and consultants who need to understand the technical aspects of Cash Manager and gain foundational knowledge of the application functionality.
At Course Completion
Course completion objectives are:
  • Ledger accounts.
  • View the results of the transactions and Daily Cash Balances.
  • Identify the appropriate use for the Reconciling options for the batches entered in Cash Account Transactions.
  • Perform the Bank Reconciliation process to reconcile Cash Manager balances to a bank statement.
  • Reconcile checks and deposits from Accounts Payable, Payroll, and Accounts Receivable.
  • Set up the Bank Reconciliation Import function.
  • Perform Cash Forecasting using what-if transactions and scenarios.
  • Troubleshoot and correct operator input errors including incorrect period to post, entries to incorrect accounts, and understanding transactions created in related modules and their effect on the Cash Manager account balances.
Course OutlineModule 1: Overview
The purpose of this chapter is to introduce the Cash Manager module of Microsoft Dynamics( SL product and training course. This chapter introduces the windows and processes that are used to complete the accounting cycle in Cash Manager.
Also, it is important to note that this chapter is optional and can be skipped at the instructor's discretion. If the instructor feels that each student's background provides sufficient experience in these topic areas, then the instructor reserves the right to skip this chapter.
Lessons
  • Course Description
  • Module Overview
  • Cash Manager Process Flow
  • Other Features
After completing this chapter, students will be able to:
  • Understand the goals of this course.
  • See how the General Ledger module fits into the suite of available modules for the Microsoft Dynamics SL system.
  • Follow the flow of transactions through the General Ledger.
Module 2: Active Overview
This chapter examines the core processes used in the General Ledger module. The chapter introduces each step in the accounting cycle, briefly discusses its purpose, and primary features, and focuses on its function in the accounting cycle. It is not intended to provide a detailed primer on each of these topics.
This chapter is optional and can be skipped at the instructor's discretion. If the instructor feels that each student's background provides sufficient experience in these topic areas, then the instructor reserves the right to skip this chapter.
Lessons
  • Establishing a Cash Account
  • Cash Transactions
  • View Cash Account Balances
  • Bank Reconciliation
After completing this chapter, students will be able to:
  • Identify the basic processes required to create a Cash Account.
  • Understand the processes involved in the Cash Manager accounting cycle.
  • View the results of transactions.
Module 3: Cash Account Maintenance
This chapter examines the setup of cash manager accounts. The purpose of this chapter is to describe the information required for accounts and discuss the criteria for tracking a cash account in the Cash Manager module. The importance of establishing a correct beginning balance for an account is discussed.
Lessons
  • Procedures for Maintaining Cash Accounts
  • Cash Account Maintenance
  • Establish beginning balances
Lab : Establish a New Cash Account
  • Create a New Account in the Chart of Accounts and add the account to track in Cash Manager.
After completing this chapter, students will be able to:
  • Understand which accounts should be tracked in Cash Manager.
  • Define accounts in Cash Manager.
  • Determine the beginning balance for an account.
  • Understand the purpose of the Cash Manager Integrity Check.
Module 4: Entry Types
This chapter examines the setup of Entry Types. The reasons for creating various entry types and the specific uses of system defined entry types are discussed. This chapter also explores the impact of the settings for an entry type in the data entry process.
Lessons
  • Procedures for Maintaining Entry Types
  • Types of Entry Types
  • Entry Type Maintenance window
Lab : Define Entry Types
  • Create new Entry Types for tracking miscellaneous transactions
After completing this chapter, students will be able to:
  • Understand how entry types are used.
  • Define Entry Types for tracking transactions.
Module 5: Cash Account Transactions and Transfers
This chapter discusses the fields and features of the Cash Transaction and Transfers windows. This chapter examines how the Entry Types are used and the processes required to update cash account balances. Integration of the Cash Manager module with the Microsoft Dynamics SL Accounts Payable, Accounts Receivable, and Payroll modules is discussed.
Lessons
  • Procedures for entering Cash Account Transactions
  • Cash Manager Process Flow
  • Processing Payments in AR
  • Procedures for Entering Cash Account Transfers
Lab : Cash Account Transactions
  • Enter example transactions for an account directly in Cash Manager
Lab : Cash Account Transfers
  • Transfer funds from one account to another in a single step
After completing this chapter, students will be able to:
  • Decide when to use the Release GL Batches window versus releasing batches from the data entry window.
  • Understand the criteria for a batch to display in the Release GL Batches window.
  • Release batches using the Release GL Batches window.
  • Reprint individual batch control reports or ranges of batch control reports
Module 6: Posting Transactions
Use the recurring invoice feature to make repetitive documents more efficient. This chapter shows how to define a recurring item and execute the process to create the transaction each period.
Lessons
  • Procedures for using Recurring Items
  • Recurring Item Maintenance
  • Generate Recurring Items
Lab : Recurring Items
  • Create a recurring item for a weekly fee
  • Generate the recurring transaction
After completing this chapter, students will be able to:
  • Determine when transactions should be defined as Recurring Items.
  • Set up Recurring Items.
  • Process Recurring Items to generate a batch.
Module 7: Cash Account Inquiry
The objective of this chapter is to examine the series of windows available for viewing account balances and drilling down to the transaction details. The Inquiry windows access cash account balances without having to print financial statements or reports. Learn to view balances and drill down to the details of the source transactions.
Lessons
  • Daily Cash Balance Window
Lab : Viewing Cash Balances
  • Use the Daily Cash Balance Inquiry window to view account balances and transactions entered in previous chapters
Lab : Entering and Viewing Cash Transactions
  • Enter additional transactions in the Cash Account Transaction window
  • Use the Daily Cash Balance Inquiry window to view account balances and locate transactions
Lab : Locating Cash Transactions in the General Ledger
  • Use Initialize Mode to view cash transactions in the General Ledger module
After completing this chapter, students will be able to:
  • Understand how to locate cash balances and transactions.
  • Understand how and when cash balances are updated.
Module 8: Bank Reconciliation
This chapter describes how to complete the Bank Reconciliation process. Students enter additional transactions that are found on the bank statement, clear ranges of checks and deposits, and learn to default information regarding cleared items.
Lessons
  • Procedures for performing Bank Reconciliation
  • Bank Reconciliation Window
  • Un-Clearing a transaction
  • Deleting a Bank Reconciliation
  • Bank Reconciliation Reports
Lab : Perform Bank Reconciliation
  • Complete the Bank Reconciliation process using a sample bank statement
After completing this chapter, students will be able to:
  • Understand the steps involved in the Bank Reconciliation process.
  • Perform the Bank Reconciliation.
Module 9: Bank Reconciliation Import
Set up the system to import a file transmitted from the bank to automatically clear checks and deposits. Associate un-matched transactions with specific items in the database. Complete the Bank Reconciliation process.
Lessons
  • Clear Check/Deposit Import Setup
  • Clear Check/Deposit Import
  • Clear Checks/Deposits
Lab : Complete the Clear Check/Deposit Import Setup Window
  • Define the settings for a bank import file
After completing this chapter, students will be able to:
  • Set up the system to import bank reconciliations.
  • Import a Bank Reconciliation file.
  • Clear imported items.
Module 10: Cash Flow Projections
This chapter introduces the concept of what-if reporting allowed in Cash Manager. Enter transactions that are used for reporting purposes. Students review how to combine the potential transactions with actual data to produce a Cash Flow Projection report.
Lessons
  • Procedures for Maintaining Cash Flow Items
  • Cash Projections
  • Cash Flow Projection Report
Lab : Enter Cash Flow Items
  • Enter potential expense and revenue transactions and generate a report using the potential items
After completing this chapter, students will be able to:
  • Understand how to use Cash Flow Items.
  • Define Cash Flow items for use in reporting.
  • Produce a Cash Flow Projection report.
Module 11: Month End and Closing
This chapter describes creating a closing checklist to ensure all transactions and activities have been completed for the accounting period, producing appropriate audit trail reports, and correcting an out of balance condition. The chapter demonstrates how to close only Cash Manager, or all modules for the period. This chapter also discusses the detail retention and deletion options.
Lessons
  • Balance the Cash Manager Module
  • Correct an Out of Balance Condition
  • Close for the Month or Year
  • Delete Cash Manager Detail
  • Perform Cash Manager Integrity Check
After completing this chapter, students will be able to:
  • Understand Month-End processes and procedures.
  • Balance Cash Manager.
  • Decide when to close Cash Manager for the period.
  • Execute the Closing process for all modules.
  • Delete detail for all modules.
  • Understand the CA Integrity Check and when to use it.
Module 12: Consolidation
This chapter discusses the Cash Manager consolidation process. Students take information from different databases with similar and differing periods, calendar years, and chart of account structures, and create a consolidated set of data for reporting purposes.
Lessons
  • Procedures for performing Consolidations
  • Generate Consolidation File
  • Read consolidation File
After completing this chapter, students will be able to:
  • Understand Month-End processes and procedures.
  • Decide when and if the Consolidation process is necessary.
  • Define Consolidation accounts.
  • Define Source and Destination databases.
  • Generate and Read the Consolidation File.
Module 13: Appendix: Cash Manager Setup
This appendeix describes the defaults and user options defined in the Cash Manager Setup window. Even though these options are typically not changed after the product is implemented, students review default values and processes through the settings in this window.
Lessons
  • Cash Manager Setup Checklist
  • Cash Manager Implementation Worksheet
  • Cash Manager Setup Window
After completing this chapter, students will be able to:
  • Understand the decisions that need to be made prior to setting up the Cash Manager module.
  • Define options in the CA Setup window that affect processing.
Module 14: Appendix: Cash Manager Case Study
This appendix includes a case study of Cash Manager. The case study allows students to practice what you have learned in a comprehensive exercise. The case study is organized such that each task builds on the previous task.
Based on country-specific needs, this chapter is optional for classroom presentation.
Lessons
  • Beginning Balances
  • Enter Cash Transactions
  • Perform a Reconciliation
After completing this chapter, students will be able to:
  • Set up and maintain Cash Manager.
  • Achieve a comprehensive understanding of how the various parts of Cash Manager are interconnected.
Before attending this course, students must have:
  • General knowledge of Microsoft Windows.
  • Knowledge of Basic navigation functions in Microsoft Dynamics SL.
  • Completion of the General Ledger training course is required. Attendance at Accounts Payable and/or Accounts Receivable training courses recommended.
Have Questions? For advice about training and certification, connect with peers: For questions about a specific certification, chat with a Microsoft Certified Professional (MCP): To find out about recommended blogs, Web sites, and upcoming Live Meetings on popular topics, visit our community site:
Course index

Find Training Near You

Location:
Eg: Seattle, WA or Paris, France

Related Services