8599: Receivables Management II in Microsoft Dynamics GP 9.0 (1 Day)
About this Course
The one-day Microsoft Dynamics GP Receivables Management II course explores the accounting cycle and the processes required to enter financial data into the system. As well, this course shows you how to perform additional functions such as Refund Checks, using National Accounts, Multidimensional Analysis and year-end closing procedures.
A thorough understanding of these topics allows you to streamline monthly and year-end closing processes by learning how to automate routine activities such as reports. You will learn tips for troubleshooting and maintaining data integrity. This course also teaches you how to maximize your reporting and analysis capabilities with inquiries and reports that can be customized to meet your specific business needs.
Audience Profile
Customers who would like a more in-depth understanding of the Microsoft Dynamics GP system. The class is targeted toward data entry clerks, administrators; office managers, CEO's, and consultants who need to understand the technical aspects of Microsoft Dynamics GP Receivables Management and gain foundational knowledge of the application functionality.
Prerequisites
Before attending this course, students must have:
Financial Series I course or equivalent working experience with Microsoft Dynamics GP
At Course Completion
After completing this course, students should be able to:
- Customize Receivables Management Setup to fit your business needs
- Use advanced functionality, such as Scheduled Payments, Refund Checks, Multidimensional Analysis and National Accounts
- Maintain Receivables data
- Use Inquiries and reports to retrieve financial data
- Complete period and year end closing procedures
Course Outline
Module 1: Setup Procedures
This chapter focuses on the setup procedures for the Receivables Management module. We examine how to customize the posting setup and posting accounts to streamline the data entry process. A big focus of this chapter is the use of customer classes and customer class accounts to minimize the amount of information that must be entered when setting up your customers.
Lessons
- Receivables Management Setup
- Receivables Setup Options
- Customer Class Setup
- Customer Class Accounts Setup
- Posting Setup
- Posting Accounts Setup
Lab : Receivables Management Setup
- Modify existing Receivables Management Setup
Lab : Posting Settings
- Modify Posting Setup
- Modify Level of Posting for Series
- Enter and post cash receipts
- Apply payments to invoices
- Verify level of posting in General Ledger
After completing this chapter, students will be able to:
- Configure Receivables Management Setup options such as Aging Periods and NSF Charges
- Use the Receivables Setup Options to assign codes and next document numbers for transactions
- Create and modify Customer Classes
- Set up posting accounts and preferences
Module 2: Transaction Flow and Integration
This chapter focuses on how data flows from the Work to Open to History tables as transactions are posted. A big focus of this section is the tables that are updated as data is processed for transactions in Receivables Management. We also discuss the integration of all modules in the Microsoft Dynamics GP system.
Lessons
- Integration
- Receivables Management Document Status
- Cash Receipts Transaction Entry Flow
- Receivables Management Computer Checks Transaction Flow
- Tracing Transactions
Lab : Tracing Transactions
- Enter and post credit memo for customer
- Use inquiry to verify origin of the credit memo
- Perform the inquiry, zoom to source document
- Print General Ledger trial balance report to the screen
- Perform Paid Transaction Removal
- Use inquiry to verify origin of the credit memo
After completing this chapter, students will be able to:
- Understand how data flows from Work to Open to History tables
- Use "Zooms" to trace transaction back to the source document
Module 3: Advanced Functionality
In this chapter we discuss the advanced functionality that is available in Receivables Management. Multidimensional Analysis provides increased reporting and analysis capabilities without expanding your chart of accounts. Another focus of this section is National Accounts which allows cash receipts to be posted to the child account on behalf of the parent company. Finally, processing Refund Checks for customers with credit balances is discussed in detail in this chapter.
Lessons
- Scheduled Payments
- Multidimensional Analysis
- National Accounts Maintenance
- Refund Checks
- Create Customer/Vendor Relationships
- Create Refund Checks
- Create Refund Checks for National Accounts
Lab : Receivables Scheduled Payments
- Create a payment schedule for customer invoice
- Post first invoice for the schedule
- Print an Aged Trial Balance report
Lab : Multidimensional Analysis
- Enter customer invoice
- Use analysis code to allocate the invoice amount
Lab : Setting up a New National Account
- Create National Account
- Enter and Post cash receipt
Lab : Creating and Printing Refund Checks
- Create a Refund Checks batch
- Create Customer/Vendor Relationship
- Print refund check
- Use inquiry windows to view status of customer account
Lab : Creating Refund Checks for National Accounts
- Enter a credit memo
- Create a Refund Checks batch
- Create Customer/Vendor Relationship for National Accounts
After completing this chapter, students will be able to:
- Enter and post Scheduled Payments
- Use Multidimensional Analysis information for Receivables transactions
- Use National Accounts
- Generate Refund Checks
- Generate Refund Checks for National Accounts
Module 4: Maintaining Records
This chapter examines the functionality available to maintain your Receivables Management records. There is also a section that focuses on correcting posted entries as well as changing and deleting records. Time is also spent discussing how to remove Receivables Management history and the types of history information stored in the system.
Lessons
- Handling NSF Checks, Voiding and Waiving Posted Transactions
- Voiding Posted Payment Schedules
- Writing Off Outstanding Debit and Credit Amounts
- Change and Delete Records
- Remove History
- Reconcile
Lab : Entering A NSF Check
- Locate customer payment
- Use "Zoom" to verify correct document selected
- Mark document as NSF
- Print posting journals
Lab : Waiving a Finance Charge
- Locate customer finance charge document
- Waive finance charge
- Enter password
- Print posting journals
- Modify customer record to not allow finance charges
Lab : Voiding a Document
- Select customer invoice
- Use "Zoom" to verify correct document selected
- Void customer invoice
- Verify invoice has been voided
Lab : Write Off Underpayment
- Set up the underpayment write off
- Preview the documents to write off
- Discuss how to email the preview list
Lab : Edit Receivables Transactions
- Select customer document
- Edit customer transaction
- Use Inquiry to verify change is complete
Lab : Removing History
- Use Inquiry to view customer transactions
- Remove transaction and distribution history for customer
- Delete customer record
After completing this chapter, students will be able to:
- Handle NSF Checks
- Void and Waive Posted transactions
- Write Off Overpayments and Underpayments
- Change and delete Customer records
- Edit posted Receivables Transactions
- Remove Receivables Management history
Module 5: Inquiry and SmartList
This chapter focuses on the multiple methods for quick and easy information retrieval. The Inquiry and SmartList functions provide numerous ways to instantly view relevant summary and detail information about account activity and transactions. We'll also look at exporting SmartList queries to Microsoft Excel or Microsoft Word.
Lessons
- Inquiries
- SmartList
Lab : Tracing Transaction
- Use Financial Inquiry window
- Drill down to source document
Lab : SmartList - Customers
- Create SmartList query
- Export query to Word
- Drill down to customer maintenance window
Lab : SmartList - Receivables Transactions
- Discuss modifications to default views
After completing this chapter, students will be able to:
- Perform Summary and Detailed inquiries for current and historical accounts
- Use SmartList to perform queries on Receivables Management data
- Use SmartList to export data to Microsoft Word
Module 6: Reports
This chapter focuses on how to create report options which may be grouped together to print multiple reports within a series or combined to print reports containing data from multiple series to maximize reporting capabilities for your financial data. Reports can be very useful in locating discrepancies that need to be corrected. Time is spent discussing how to utilize the trial balance reports to analyze Receivables Management data.
Lessons
- Creating Report Options
- Creating and Printing Report Groups
- Analyzing Payables Reports
Lab : Sales Analysis Reports
- Print the Receivables Sales Analysis and Accounts Due reports
Lab : Aged Trial Balance Reports
- Create a report option and print the Aged Trial Balance with Options report
- Create a report option and print the Historical Aged Trial Balance report
After completing this chapter, students will be able to:
- Create and modify report options
- Create and print report groups
- Analyze Receivables Reports
Module 7: Period-End Procedures
This chapter examines the process of closing an accounting period for Receivables Management. The steps necessary to complete each phase of the closing process are discussed in detail. We look at the reports that should be printed before performing the closing process and the steps to reconcile to General Ledger. Time is spent examining what actually takes place during the closing process and how to close the fiscal period to prevent additional transactions from being posted to a period.
Lessons
- Period-end Closing Checklist
- Aging Process
- Assess Finance Charges
- Print / Reprint Customer Statements
- Transfer Sales Commission
- Paid Transaction Removal
- Reconcile Receivables Management to General Ledger
- Period-end Reports
- Close Fiscal Period
Lab : Using the Period-end Procedures Checklist
- Perform Receivables Management month-end procedures using the month-end routine checklist
Lab : Period-end Exercise
- Print the General Ledger Trial Balance Report
- Print the RM Trial Balance Report with Options
- Discuss how to reconcile the two reports
Lab : Reprinting Statements
- Reprint Customer Statement
After completing this chapter, students will be able to:
- Complete the period-end processes using the Checklist Routine
- Print Customer Statements
- Perform account reconciliation
Module 8: Year-End Procedures
This chapter examines the process of closing the year. The steps necessary to complete each phase of the closing process is discussed in detail. Steps are provided for closing the calendar and fiscal year in Receivables Management and the Sales Tax Periods for the year.
Lessons
- Fiscal Year Close
- Calendar Year Close
- Close Fiscal Periods
- Tax Year End Close
Lab : Year-end Closing
- Post all transactions for the period
- Perform calendar and fiscal year-end closing procedures
- Close the sales tax periods for the year
After completing this chapter, students will be able to:
- Successfully perform the calendar and fiscal year-end closing procedures
- Close the sales tax periods
Module 9: Tips and Troubleshooting
This chapter focuses on techniques available for troubleshooting problems that may arise during the posting process. We look at the Batch Recovery process for releasing "stuck" batches and how to recreate the RM Key Master file. A section of commonly asked questions about Receivables Management transactions is included in this section.
Lessons
- Troubleshooting
- Understanding Error Messages
- Posting Interruptions
- Recreating the RM Key Master file
- Receivables Management Commonly Asked Questions
Lab : Recreating the RM Key Master File
- Run SQL statement
- Perform Check Links process
- Print error log
After completing this chapter, students will be able to:
- Fix common errors
- Use troubleshooting tips and techniques
- Recreate the RM Key Master file
Module 10: Conclusion
In this chapter we discuss the key points that have been covered throughout this course.
Lessons
- Customize Receivables Management Setup
- Options for posting to General Ledger in detail or in summary
- Integration between modules enables data entry to be faster and easier and provides for greater reporting capabilities
- Data flow begins in a "Work" status, moves to "Open" and culminates in "History"
- Scheduled Payments functionality allows you to perform "what-if" analysis in determining the viability of different interest rates, payment amounts payment frequencies and number of payments
- Multidimensional Analysis can be used with transactions in Receivables Management
- National Accounts can be used to group related customers that make up a single organization. Customer payments may be distributed on behalf of the child accounts
- Refund Checks enable you to refund customer credit balances with ease
- Inquiry windows and SmartList provide ways to view and export Receivables data
- Use the Receivables Summary Inquiry window to obtain a summary of all transactions currently affecting customer accounts
- Reports are available to determine discrepancies when the subledger does not balance with your general ledger account
Module 11: Appendix: Smart Tags
This section contains information on Smart Tags or links between Microsoft Office documents and data in Microsoft Dynamics GP. The items that may be recognized and "tagged" in Microsoft Office XP are discussed in the section. The focus of this section is to highlight the benefits of Smart Tags and how you can use them in your business.
Lessons
- How Smart Tags work
- Smart Tag Benefits
After completing this chapter, students will be able to:
- Understand how Smart Tags work
- Recognize the ways Smart Tags can make your business more productive
Module 12: Appendix: Professional Service Tools Library
This chapter contains information on the Professional Services Tools Library and how it can provide help for users to consolidate and change critical data - quickly and accurately. Users can purchase tool individually, select any three tools or purchase the entire library.
Lessons
- Financial Series Tools
- Purchase Series Tools
- Sales Series Tools
- Payroll Series Tools
- Inventory Tools
- System tools
- Tools Available Separately
- Related Service Offerings
After completing this chapter, students will be able to:
- Understand the tools that are available in the Professional Service Tools Library and how they can be used in your organization